4.3a Final Lab: usp_Q1080

This query accepts a pair of year parameters, and SQL Server can’t figure out how to do index seeks with those. We’ll rewrite them as dates, and then use dynamic SQL to improve the second phase of the query. We even bust out some slick comment injection tricks to get different plans for different volumes…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM or Mastering Query Tuning, or log in if you already shelled out the cash.

This query accepts a pair of year parameters, and SQL Server can’t figure out how to do index seeks with those. We’ll rewrite them as dates, and then use dynamic SQL to improve the second phase of the query. We even bust out some slick comment injection tricks to get different plans for different volumes...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM or Mastering Query Tuning, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}