What is fragmentation, and how do you detect fragmentation and eliminate it? I explain the internal and external types and what each one does to your pages.
SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON
What does IGNORE_DUP_KEY = ON do on a unique nonclustered index? Duplicate inserts give a warning instead of an error, and my example shows both options.
SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction
Temp table versus table variable, part two: a transaction rollback undoes changes to a temp table, but a table variable keeps its values.
SQL Authority News – Training SQL Server Query Optimization And Performance Tuning
Our SQL Server Query Optimization and Performance Tuning course sold out in minutes, so we run it again in the first week of next year: three days, in depth.
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
Where in SQL Server does 100 equal 0? In Fillfactor settings. An in-depth look at how the Fillfactor of an index affects page fill and performance.
SQL SERVER – Difference TempTable and Table Variable – Table Variable in Memory a Myth
Is a table variable in memory while a temp table lives in TempDB? It is a myth: both are created in TempDB, and a simple script proves it.
SQL SERVER – 2008 Star Join Query Optimization
Star Join Query Optimization in SQL Server 2008 Enterprise Edition uses bitmap filtering to speed up data warehouse queries that join fact tables.