Free Webcast on Dynamic SQL Pro Tips

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’ve been working with dynamic SQL for over a decade. At the next free GroupBy online conference on May 13th, I’ll show you how to use sp_executesql, sp_BlitzCache, and my favorite tricks for easier debugging and commenting. The full session list is out, and it’s a great lineup, especially for free.

Register now for free. See you there!

Previous Post
Can You Use NVARCHAR As a Universal Parameter? Almost.
Next Post
Starter/Good/Great/Bananas Live Streaming Setups

2 Comments. Leave new

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":""}