Posts Tagged: SQL Server 2012

Unicorn Create Index

Index Analysis March Update

Posted by & filed under , , .

In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure today.  Without further ado, you can jump to the bottom and download it.  There are a few things I’ve fixed from comments from people using the script and then major change is the addition of […]

Lego Computer

Index Analysis Update – January 2012

Posted by & filed under , , , , .

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 […]

IndexSearch

Can You Dig It? – Determining Index Plan Usage

Posted by & filed under , , , , , , , , .

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. […]

image001.png

SQL Server Special Ops

Posted by & filed under , .

SQL Server 2012 is coming to 12 cities next year.  Is your city on the list?  It can be – or could be – take a few minutes to complete the survey at www.specialopstour.com and you will help determine where the tour will be heading.  Personally, I hope everyone puts in Minneapolis, MN – but […]