Category: Intermediate

The #TSQL2sday #70 roundup

Post author By Jen McCown
Post date September 10, 2015
Categories In Admin, Advanced, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tech and Learning
6 Comments on The #TSQL2sday #70 roundup

Time for the T-SQL Tuesday #70 roundup! I asked people for their best enterprise management strategies, and they responded beautifully. Here we go. Rob Farley : Superhero powers for managing the enterprise. Rob talks about what his consulting company looks for when talking to a customer. Specifically, things that are out of the ordinary. And of […]

Assigned reading: FREEPROCCACHE

Post author By Jen McCown
Post date August 25, 2015
Categories In Admin, Intermediate, sqlserverpedia-syndication, SSC, Tech and Learning

I don’t often find myself blogging for the sole purpose of showing you someone else’s blog, but today is one of those days. I’d like you to read Grant Fritchey’s excellent piece, “Targeted Plan Cache Removal“, for this reason: the more people have learned about parameter sniffing, the more popular DBCC FREEPROCCACHE() becomes. Grant’s post explains […]

Video: A Better Way to Reindex

Post author By Jen McCown
Post date January 23, 2015
Categories In Admin, Intermediate, Minion by MidnightDBA, sqlserverpedia-syndication, SSC, Tech and Learning
1 Comment on Video: A Better Way to Reindex

Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to download the free Minion Reindex tool.