Watch Brent Tune Queries 2020

Summary

Want to get better at fixing slow Ever wonder how somebody else does it? First hour of the stream: writing a blog post on how to read someone else's temp table contents in Microsoft SQL Server. Second ... I'm live coding T-SQL in Microsoft SQL Server with the Stack Overflow database: BrentOzar.com/go/querystack ... You're a developer or a DBA, and you're comfortable writing Learn more and register at sqlbits.com/information/event20/Mastering_Index_Tuning/trainingdetails See you in London! I take the output of your sp_BlitzFirst SinceStartup = 1 and tell you what you should do next to improve your server's performance. I code T-SQL to find objects whose statistics recently updated, which can affect plan caching and parameter sniffing. Looking for comprehensive, deep-dive training on SQL Server Performance One of my clients wants a tutorial on implementing batching to update millions of rows while staying under the lock escalation ...