[Video] Watch Brent Write T-SQL

This morning I worked on a new check for sp_BlitzFirst to find statistics that were updated in the last 15 minutes, possibly causing plan caching issues and parameter sniffing. I streamed it live, and you can watch.

In part 1, the first hour, I write the proof-of-concept query:

In part 2, the second hour, I move the query into sp_BlitzFirst, test it, debug it, and check it into Github:

And finally in the third hour, I switch to open Q&A and do a few live demos:

And now, I’m enjoying the well-earned bagel that I discussed on the webcast:

Previous Post
[Video] How to Think Like the SQL Server Engine: All-Demo Edition
Next Post
SQL ConstantCare® Now Tells You Which Indexes to Drop.

2 Comments. Leave new

  • Scott Coutant
    May 26, 2020 1:54 pm

    Try putting Details BEFORE the ID column to solve your sorting problem

    Reply
    • SCOTT! You, my friend, are smarter than both me and everyone on that webcast. You rock. I’m sending you a thank-you gift. I really appreciate the attention to detail!

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}