Identifying and Fixing Parameter Sniffing
You swear nothing changed - but suddenly your SQL Server has ground to a halt. Queries are slow across the board. You restart the server, rebuild indexes, or update statistics, and magically the problem goes away - but what really happened, and how do you fix it faster and more permanently?
Brent Ozar will explain what parameter sniffing is, show it happening live, explain why most people fix it the wrong way, and give you options to fix it long term.
Blocking: How to Find and Fight LCK* Waits
When you’re facing lock waits and blocked queries, it’s tempting to just slather NOLOCK all over the queries. Thing is, this won’t necessarily fix it, and there are much better ways to track, diagnose, and cure blocking issues. You’ll learn them here.
Dynamic SQL: Pro Tips for Building and Tuning It
Dynamic SQL is one of the most powerful tools in the database developer's arsenal. When you need a complex search stored procedure that takes all kinds of parameters (price, category, location, color), dynamic SQL can run extremely quickly by leveraging better indexes. However, when done wrong, it's extremely painful to troubleshoot.
I'm Brent Ozar, a Microsoft Certified Master who's been working with dynamic SQL for over a decade. I'll show you how to use sp_executesql, sp_BlitzCache, and my favorite tricks for easier debugging and commenting.
SQL Saturday Boston 2023 Sessionize Event
Techorama Belgium 2019 Sessionize Event
Techorama NL 2018 Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top