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 – Index Optimization CheckList
My Index Optimization checklist for Jr. DBAs: index columns used in WHERE, ORDER BY, GROUP BY and JOINs, drop indexes you do not need and keep keys small.
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 – 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 – Difference Between Unique Index vs Unique Constraint
Unique Index vs Unique Constraint: is there a difference? No. A unique constraint creates a unique index, and performance is the same. Syntax for both.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table
A query to list every identity column with its seed, increment and current value, plus what those numbers mean and how to reseed a table safely.
SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index
Clustered index and non-clustered index compared: how many you can have, how each stores data, and where the SQL Server 2005 included column index fits.