This week, I’m giving away modules from my How I Use the First Responder Kit class. So far, we covered a server-wide health check with sp_Blitz, then a server-wide performance checkup with sp_BlitzFirst, then using sp_BlitzCache to find the queries causing your bottlenecks. Now that you’ve seen those slow queries, let’s see if we can fix ’em en masse with index changes.
If you bookmark these posts for later reading, just be aware that they’ll self-destruct on May 1 – so keep up. If you can read & watch quickly, you get the benefit of free training. (Worth the quarantine? Probably