Presentation Materials “Discovering the Plan Cache” #SQLSat206

This past weekend, I took a quick trek into the land of beer and cheese for the second annual Madison SQL Saturday event.  The event was a great success, but  can you expect less when one of the organizers is wielding a light saber.  For a change this time, instead of bringing Sarah Strate (Blog | … Continue reading Presentation Materials “Discovering the Plan Cache” #SQLSat206

A Second March ‘Index Analysis’ Update

After this month's Index Analysis update, I was contacted by a reader about the index analysis script.  Reader Dick Baker let me know that he found and had a fix for an issue with the missing_index_impact column.  Thanks to Dick for this fix. If you find issues or have suggestions for changes to the script, please … Continue reading A Second March ‘Index Analysis’ Update

Index Analysis March Update

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 … Continue reading Index Analysis March Update

5 MCM Readiness Indexing Videos You Should Watch

Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification.  In the process of preparing for the MCM lab portion, I did a lot of studying.  One of the my key resources, were the MCM Readiness Videos that SQLSkills put together a couple years back. The thing is, even if … Continue reading 5 MCM Readiness Indexing Videos You Should Watch

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 … Continue reading Index Analysis Update – January 2012

T-SQL Tuesday #025 – Share Your Tricks #TSQL2sDay

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 … Continue reading T-SQL Tuesday #025 – Share Your Tricks #TSQL2sDay

Can You Dig It? – Researching Index Scans

Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. It’s been a while since the last plan cache series post.   In the last few posts, I was focusing on specific attributes.  Instead of continuing on that vein, I want to cover a use case that fit … Continue reading Can You Dig It? – Researching Index Scans