Posts Categorized: SQL Server 2005

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

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

A couple years back, I wrote a few blog posts about an indexing script that I use with clients from time to time. While I provided some updates to it over the years, I haven’t pushed out anything new on it in quite some time. Seems I got distracted with an indexing book and never […]

In a previous post, we looked at how to take the the binary page values in sysindexes and convert the values into file id and page id for the first and root index page and first IAM page for each index. This information can be useful when you need to find the base pages for […]

Have you ever looked at the first, root, and FirstIAM columns in sysindexes and wondered… “What do these values mean?” Recently, I took the time to dig into these values to figure out what they meant. And then, how to take the information that they contain and turn it into something useful. By the Book […]

In my blog series Lost in Translation – Deprecated System Tables, I’ve been going through the compatibility views in SQL Server and translating and mapping them over to catalog views and dynamic management objects. One of the ones that I was working on recently was mapping sysindexes to sys.indexes. While working on that post, there […]

What would you say if I offered you the best indexing book on the market for SQL Server 2012? Wow, right? The “best” indexing book! Unfortunately, this is also the “worst” indexing book. Coincidentally, it is also the “only” indexing book for SQL Server 2012. And even though the book was written with SQL Server […]

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

At some point last year after finishing the 31 Days of SSIS, I decided to bundle up all of the posts into a single document. That way, if someone was on the go and didn’t have a good internet connection or wanted be able to read all of the posts in a single setting it would […]

Another month and it’s another T-SQL Tuesday. This month we are being hosted by Allen White (Blog | @SQLRunr) and the topic is to Share Your Tricks. One of my favorite things to do in SQL Server is to run queries against the plan cache. Within there, you have the ability to see what SQL […]