Session

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.

Brent Ozar

I make Microsoft SQL Server go faster.

Las Vegas, Nevada, United States

Actions

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