11 – Parameter Sniffing (19m)
“Why is this query sometimes fast and sometimes slow? I swear nothing’s changed.” You’ve heard it a million times. You’ve played around with updating stats or rebuilding indexes, and you think that fixed it – but you’re really just putting a band aid on a nasty wound. Let’s show how it happens. Demo script: Transact-SQL […]
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.