A reader asked if there is anyone who should not attend my SQL Server Performance Tuning Practical Workshop for EVERYONE. Here is my honest answer.
Price Increase Alert – SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019
Missed the early bird for my SQL Server Performance Tuning Practical Workshop for EVERYONE? I extended the USD 800 price until March 7, before it goes to USD 900.
SQL SERVER – How to Drop All the Hypothetical Indexes of Database?
A client wanted to undo the damage from Database Engine Tuning Advisor. Here is how to drop all the hypothetical indexes of a database that DTA left behind.
SQL SERVER – Query Listing All the Indexes Key Column with Included Column
We had too many indexes to consolidate, so I needed a query listing all the indexes with their key columns and included columns. Here is the script.
What is Consolidation of Index? – Interview Question of the Week #212
What is consolidation of index? When a table has overlapping indexes, like one on Col1 and one on Col1, Col2, here is how I think about combining them.
SQL SERVER – Say No To Database Engine Tuning Advisor
After 20 years with SQL Server, my advice is simple: say no to Database Engine Tuning Advisor. It was fine in 2000, but tuning has moved far beyond it.
SQL Server Performance Tuning Practical Workshop – Relaunched
My SQL Server Performance Tuning Practical Workshop began as an experiment in 2017. In 2018 I ran 112 workshops for 84 organizations, and now it is relaunched.