Sql Server

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