I've wrapped up my session at my first session at this year's PASS Summit. My session this Thursday was The Plan Cache Whisperer: Performance Tuning SQL Server [DBA-313]. The session appears to have gone really well and the content has been uploaded to the PASS Summit for download. To provide access to the materials now, the slide deck … Continue reading PASS Summit Session Follow-up: The Plan Cache Whisperer
Earlier this month, I presented a session for Pragmatic Works Training on the T's on the selecting the clustered index for a table in a SQL Server database. In the session, titled How Do Non-Clustered Indexes Improve Performance?, in this session I discussed the patterns around non-clustered indexes and why you might choose which patterns for … Continue reading Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance?
Earlier this month, I presented a session for Pragmatic Works Training on the T's on the selecting the clustered index for a table in a SQL Server database. In the session, titled Choosing Your Clustered Index, in this session I discussed the patterns around choosing clustered indexes and why you might choose one pattern over another. … Continue reading Webcast Follow-Up: Choosing Your Clustered Index
With today's SQL Server instances, there easily be anywhere from a dozen to a hundred databases on a single SQL Server instance. In fact, on my laptop, I currently have almost two dozen databases and these are just from working on projects. Setup a SharePoint server and add a few sites and you'll easily see … Continue reading Can You Dig It? – Find All Plans for a Database
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
I'm a little late getting the information from my Fargo SQL Saturday session posted, titled "Discovering the Plan Cache". But it's better a little late that never. Even though it was the end of the day, the session had great turnout and lots of good questions. Reviewing my session evals, I saw quite a few high … Continue reading Presentation Materials “Discovering the Plan Cache” #SQLSat175
Just got done with my morning session, titled "Discovering the Plan Cache", for SQL Saturday Chicago #211 and wanted to get out my session deck and scripts for people. The session got pretty high marks from the attendees and people seemed to get a lot of good information and humor out of it. Probably the best … Continue reading Presentation Materials “Discovering the Plan Cache” #SQLSat211
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
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
Strate SQL 