Download Episode (mp3)
On this show, we take a deep dive into the Plan Cache and talk about how you can monitor and learn about query behavior using its DMVs.
We also talk about how a Dates table can benefit you, and why, and about weird issues with Dynamic SQL and locking.
Items mentioned in the show:
Guy Glantser - Monitor Query Statistics