Trace flags let a DBA turn a database function on or off for a while. How to use DBCC TRACEON and TRACEOFF, with deadlock trace flag 1205 as the example.
SQL SERVER – Disable Index – Enable Index – ALTER Index
When DTS, BCP or BULK INSERT needs an index out of the way, I prefer to disable index with ALTER INDEX and enable it again with REBUILD. AdventureWorks example.
SQL SERVER – DBCC commands List – documented and undocumented
The full list of documented and undocumented DBCC commands with their syntax, plus how DBCC TRACEON(2520) and DBCC HELP show all of them in Query Analyzer.
SQL SERVER – DBCC Commands to Free SQL Server Memory Caches
You do not need to restart the server to clear SQL Server memory caches. DBCC FREESYSTEMCACHE and related DBCC commands do it, for the rare times you need it.
SQL SERVER – Good, Better and Best Programming Techniques
My notes for a programmers meeting on Good, Better and Best Programming Techniques in SQL Server, plus a funny bug ticket about a client who got no email.
SQL SERVER – 2005 – DBCC ROWLOCK – Deprecated
Many people search for DBCC ROWLOCK in SQL Server 2005. It is deprecated, since row locking is on automatically. I also link the list of discontinued features.
SQL Server Interview Questions and Answers Part 2
Interview Questions and Answers Part 2 explains clustered vs non-clustered indexes and the index configurations a table can have. The updated set has moved.