10 – How Plans Are Cached (10m)

SQL Server caches execution plans based on the exact string that you’re executing. Comments, whitespace, line returns, it all has to be an absolute, precise, exact match. If there are any variances – even so much as a line return – then you might be troubleshooting a different query plan than the users are getting….

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.