5 Views0 Comments0 Likes
Kevin goes over how to do basic query tuning. Then he dives into 3 real world query tuning examples that are taken from Answers.SQLPerformance.com. The examples are SSMS vs. Plan Explorer, Massive MERGE, and the Case of the Log Shipping Mystery.
19 Views0 Comments0 Likes
Aaron Bertrand goes over the differences between SP_EXECUTESQL and EXEC(...). He also provides a demo to show why he likes one more than the other.
122 Views0 Comments0 Likes
Aaron Bertrand goes over how to generate Ad-Hoc Sets efficiently. He shows examples of how to generate them using recursive CTEs, system tables and number tables and shows which way has the best performance.
647 Views0 Comments0 Likes
Have you ever wondered who is the World’s Fastest DBA? Well now you have a chance! Watch as the SQL Sentry Racing Team takes to the Charlotte Motor Speedway to find out who is truly the World’s Fastest DBA.