This stored procedure queries a view, which queries a multi-statement table valued function (MSTVF). We unwrap this hot nested mess, make a quick fix to inline the function, and add an index to support the function’s work. We fire up SQLQueryStress again, and we’re going even faster.
To access this incredible, amazing content, you gotta get Live Class Season Pass, The Team Membership, Mastering Query Tuning, Level 3 Bundle (Live Classes, Lab VM Included) or Level 2 Bundle (Live Classes, No VM Included), or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}