Find the tipping point where key lookups cost more than a scan, then compare covering and filtered indexes with measured reads.
SQL SERVER – What is Forwarded Records and How to Fix Them?
Forwarded Records in heap tables still puzzle many SQL Server users, years after I first wrote about them. Here is what they are and how to fix them.
Sort in TempDB for Faster Index Rebuilds: When It Helps
To sort in tempdb during an index rebuild, add WITH (SORT_IN_TEMPDB = ON) to ALTER INDEX. This post tests the option and shows that the user database log stays the same size, because only the sort workspace moves. It also explains when the option helps, how much tempdb space it needs, and when to leave it off.
How to List All the Nonclustered Indexes of Your Table? – Interview Question of the Week #155
How do you list all the clustered and nonclustered indexes of your table, including columnstore? Here is the script I use in my performance health checks.
How to List All ColumnStore Indexes with Table Name in SQL Server? – Interview Question of the Week #153
Question: How to List All ColumnStore Indexes with Table Name in SQL Server? As ColumnStore Indexes are getting more and more popular.
SQL SERVER – Too many dumps generated. CPerIndexMetaQS::ErrorAbort – Index Corruption
A reader had too many dumps with CPerIndexMetaQS::ErrorAbort. Here is how we traced them to index corruption and the steps we took to fix it.
What are Forwarded Records in SQL Server? – Interview Question of the Week #145
What are forwarded records in SQL Server? It is an old concept, yet few new DBAs know it. Here is a short answer about heap rows that moved to a new page.