Seems I managed to make it through all of April without an update to the index analysis stored procedure. It wasn't for lack of using it with clients, but a lack of time to get the changes out the door. A few months back, I added the option to look at just duplicate index or … Continue reading Index Analysis May 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
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
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 … Continue reading STATS_DATE() Doesn’t Indicate The Validity of Statistics
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
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
If you are looking for a little training on SQL Server Integration Services (SSIS) without having to leave the comforts of your cubicle – this is your week. This Friday (11/19/2011), SSWUG will be hosting an expo titled “Building and Developing with SQL Server Integration Services”. The event will consist of four sessions that will … Continue reading SSWUG SSIS Expo Event This Friday
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
Want to take a few minutes out of your day on to learn a bit more about indexes? On Thursday, I’ll be presenting at Quest’s Pain of the Week webcast. The session will be Understanding Your Indexes: Operational Stats. There's a lot that goes on under the covers of SQL Server with your indexes. But … Continue reading Pain of the Week: Understanding Your Indexes
Tomorrow is time for part two of my presentations this month on Extended Events for the PASS DBA Virtual Chapter. If you missed the first part of this series, you can watch it before hand here. Below are the details on the event and the session description… Extended Events, Work Smarter Not Harder – Part … Continue reading PASS DBA Virtual Chapter Tomorrow
Strate SQL 