Continuing his knee-jerk series, this time Paul Randal (@PaulRandal) of SQLskills talks about SSDs, and some of the false impressions people get about them.
Continue Reading »Nov 262014
Nov 202014
SQL Sentry's @AaronBertrand discusses a handful of reasons "identical" queries might yield multiple plans, contributing to plan cache bloat.
Continue Reading »Nov 042014
Erin Stellato (@erinstellato) of SQLskills explains another reason she avoids the built-in sp_updatestats procedure: it doesn't consider indexed views.
Continue Reading »