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 – Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction
Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Estimating How Much Memory SQL Server Needs
How much memory SQL Server needs depends on the active working set, grants, and host headroom; learn to measure pressure and avoid fixed ratios.
Data Types That Waste Space
Data types that waste space include oversized integers, blanket nvarchar(max), and unnecessary datetime2 precision; measure before changing.
Index Optimization Checklist: A Printable One-Page Guide
The twelve things I ask a junior DBA to check before I touch a slow query, with three quick proofs you can run yourself.
What Is a Heap in SQL Server?
A heap in SQL Server is a table with no clustered index. Forwarded records pushed one count from 11,113 reads to 199,844, and a single REBUILD put it back. When a heap is fine and when it is not.
SQL SERVER – 2005 TOP Improvements/Enhancements
SQL Server 2005 brings two enhancements to the TOP clause: pass a variable or sub-query as the TOP value, and use TOP in INSERT, UPDATE and DELETE.