Seats for Practical Real World Performance Tuning with Brent Ozar are nearly gone. Here are answers to the questions I keep getting by email about the course.
[Exclusive] Practical Real World Performance Tuning – Live Training Session for Limited Time
Brent Ozar and I launched Practical Real World Performance Tuning, a demo-driven live course built on handy scripts. Registration is open for a limited time.
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.
SQL SERVER – Improve Index Rebuild Performance by Enabling Sort In TempDB
A client’s index rebuild was taking forever. We improved their index rebuild performance by enabling sort in TempDB, and here is how it works.
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.