Tag Archive for SQL Server 2012

Lego Tree

A Replacement for DBCC IND in SQL Server 2012

Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles.  Some of these, like Availability Groups and ColumnStore, are great additions and their introduction includes much fanfare.  Among all of those new features, is the occasional little bell which offers us a chance to change how we investigate SQL…

NumberDial

STATS_DATE() Doesn’t Indicate The Validity of Statistics

From time to time, you might have caught yourself in a conversation similar to the following: Fred: Hey folks, we have a query that isn’t working right anymore? Wilma: I wonder if there’s a problem with the statistics.  Maybe they are out of date. Barney: I checked the statistics with STATS_DATE() and they are really…

Lego Computer

Index Analysis Update – January 2012

In the past couple weeks, I’ve gotten a couple reports of issues with sp_indexanalysis.  The update today fixes those issues.  It’s fun to finally be playing with these scripts again.  I’m hoping to start writing blog posts showing the scripts in action in the next couple weeks. INDEX ANALYSIS UPDATES The main updates to the…

Lego Computer

Index Analysis Post Christmas Update

Last week I mentioned that I had put up a few new versions of my index analysis script.  Turns out a few people downloaded it and found some issues.  I also have been playing with it some more and noticed some quirks that were a bit irritating to me, so there are new versions of…

Can You Dig It? – Determining Index Plan Usage

A while back I was asked, if you can use the plan cache to determine which plans are using specific indexes.  The answer is, of course, yes, you can.  And it’s important that people, especially DBAs, understand how to do this.  Usually during index analysis, we concern ourselves with whether an index is being used.…