3. Dynamic SQL (36m)

You already know that dynamic SQL means building strings and executing them, and it’s a really powerful technique. However, there are a couple of big performance and security gotchas. In this session, you’ll learn how sp_executesql isn’t just more secure, but it can be faster, too. Transcript: Good afternoon all you dastardly dudes and dubious…

To access this incredible, amazing content, you gotta get Fundamentals of Query Tuning, Recorded Class Season Pass or The Team Membership, or log in if you already shelled out the cash.

You already know that dynamic SQL means building strings and executing them, and it’s a really powerful technique. However, there are a couple of big performance and security gotchas. In this session, you’ll learn how sp_executesql isn’t just more secure, but it can be faster, too. Transcript: Good afternoon all you dastardly dudes and dubious...
To access this incredible, amazing content, you gotta get Fundamentals of Query Tuning, Recorded Class Season Pass or The Team Membership, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}