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.
How to Drop All the User Created Statistics by SQL Server? – Interview Question of the Week #158
SQL Server creates statistics on its own, but DBAs and the Tuning Advisor add more. Here is a script to drop all user Created Statistics safely.
SQL Authority News – Join me at SQLBits 2018 – 36 Scripts: Performance Tricks Jedi Master Wants You to Know
Join me at SQLBits 2018 at Olympia London for my in-person workshop, 36 Scripts: Performance Tricks Jedi Master Wants You to Know. Here is what it covers.
Difinity 2018 – Auckland, New Zealand – Pre-Con on SQL Server Performance Tuning
I am presenting three SQL Server Performance Tuning sessions, including a pre-con, at Difinity 2018 in Auckland, New Zealand, February 12 to 14.
Free Webcast – 3 Common Mistakes to Kill SQL Server Performance – My Best Online Presentation
I am most proud of my free Group By webcast, 3 Common Mistakes to Kill SQL Server Performance. Here is where to watch it and why it matters to me.
SQL Server Performance Tuning Practical Workshop – Forward Looking
After 120+ sessions in just five months, here are the numbers behind my SQL Server Performance Tuning Practical Workshop and what comes next for it.
SQL SERVER – How to Measure Page Splits Counter Value via T-SQL?
Question: How to measure the Page Splits counter value via T-SQL? Here is a quick script for DBAs who would rather not open PerfMon.