SQL Server Tips, Techniques and Articles


Today's Site Sponsor

	SQL Compare quickly and easily compares and synchronizes SQL Server database schemas

Today's Tips

Your source for SQL Server!

	SEP 2	Performance Issue with large number of Virtual Log Files in SQL Server Transaction Log

	SEP 1	Extended Protection available in SQL Server 2008 R2

	AUG 31	August 2010 Tips - Recap

	AUG 31	Keeping your SQL Server DDL Trigger Audit Table in Check

	AUG 30	Cannot make a role a member of itself error in SQL Server

What others are reading right now (reload page to update)

Top Ten Tips

	How to execute a DOS command when xp_cmdshell is disabled in SQL Server
	SQL Server Cursor Examples
	SQL Schema Comparison with Visual Studio 2010
	Date/Time Conversions Using SQL Server
	Export data from SQL Server to Excel
	SQL Server restart validation checklist
	SQL Server Join Examples
	Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 1
	Issues with running DBCC SHRINKFILE on your SQL Server data files
	Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2

Tip Categories

Miscellaneous (3)
Monitoring (12)
Monthly Recap (51)
MS Access to SQL Server (1)
News (12)
Partitioning (6)
Performance Point (5)
Performance Tuning (34)
Policy Based Management (13)
PowerShell (12)
Professional Development (17)
Profiler / Trace (6)
Query Optimization (8)
Query Plans (7)
Referential Integrity (6)
Replication (10)
Reporting Services (45)
Scripts (21)
Security (52)
Service Broker (4)
Service Packs / Patches (10)
Sharepoint (5)
Spatial Data Storage (4)
SQL Azure (6)
SQL Server 2008 (34)
SQL Server 2008 R2 (3)
SQL Server Agent (29)
SQL Server Configurations (27)
SQL Server Integration Services (59)
SQL Server Management Objects (SMO) (3)
SQL Server Management Studio (26)
Stored Procedures (5)
Surface Area Configuration Manager (4)
System Stored Procedures (4)
T-SQL (27)
Testing (8)
Tools (16)
Triggers (6)
Upgrades (5)
User Defined Functions (UDF) (8)
User Defined Type (UDT) (1)
Views (3)
XML (5)

Search

More

How quickly can you compare and synchronize your database?

"I could do the job by hand in hours, or use SQL Compare in seconds."

Tim Kummer

Download SQL Compare now

Information From Our Sponsors

Industry Leading Products

	SQL defrag manager
SQL defrag manager is a one-of-a-kind solution that automates the time-consuming process of finding and fixing database index fragmentation issues across multiple SQL Servers. SQL defrag manager improves server performance by analyzing database index fragmentation levels, pinpointing fragmentation “hot spots” and taking action to defragment automatically, or at your command.