When should you use sort_in_tempdb for rebuilding indexes? A DBA asked me in a Health Check, and the simple answer is when TempDB sits on fast, separate drives.
SQL Authority News – Free Performance Tuning Videos
People often ask me to teach my SQL Server performance tricks. Here are two of my free Performance Tuning Videos where I explain how to tune SQL Server.
SQL SERVER – Performing IF…THEN In T-SQL With IIF Expression
IIF is one of the most underused SQL Server features. Here is how to perform IF…THEN logic in T-SQL with IIF Expression, and why people still prefer CASE.
How to Track Autogrowth of Any Database? – Interview Question of the Week #205
How do you track autogrowth of any database? Constant autogrowth was slowing a client’s busy e-commerce database, and here is how we found when and who caused it.
How to Create an Empty Table and Fool Optimizer to Believe It Contains Data? – Interview Question of the Week #204
How do you create an empty table and fool the optimizer into thinking it has data? Nobody asked me that in 20 years, but I use this trick in Health Checks.
Detect and Diagnose SQL Server Performance Issues with Spotlight Cloud
Apps run fast in testing and slow down once live. Spotlight Cloud helps detect and diagnose SQL Server performance issues with workload analysis and smart alarms.
Video – Bert & Pinal Troubleshoot a Slow Performing SQL Server
At my 10th PASS Summit, Bert Wagner and I recorded a video on how to troubleshoot a slow performing SQL Server. Here it is, with a little of the story behind it.