sp_blitzindex

First Responder Kit Updates: So Many Updates, Brent Quit

Last Updated February 13, 2017

I got 128 GB of RAM just to develop sp_BlitzCache with! Also, thanks to @RichBenner @BrentOzar and @douglane for code, and @LitKnd and @HenrikStaunPoulsen for great ideas! Grab the newly updated First Responder Kit, and here’s what’s in it: sp_Blitz Improvements #677 Finally! A bug that isn’t ours! Microsoft forget to let SE clean up…

sp_BlitzIndex® Holiday Week Edition

Last Updated February 13, 2017

Kendra Little

First Responder Kit, SQL Server

Only one thing could have dragged me away from the soft glow of the electric leg lamp glowing in the window… sp_BlitzIndex® It’s one of those weeks when things get nice and slow. Your business users and managers are all out of the office due to holidays. Your inbox is blissfully quiet. You get a…

Instant Index Insight: How to Use sp_BlitzIndex® (video)

Last Updated February 13, 2017

Kendra Little

First Responder Kit, Videos

You probably don’t have enough time to dig through DMVs trying to figure out which indexes you should add or drop. Whether you’re a DBA or developer, junior or senior, you’re probably too busy doing your real job to master all the index best practices – and now you don’t have to. In this 30…