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?
Tag: Indexing
Webcast Follow-Up: Choosing Your Clustered Index
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
Can You Dig It? – Find All Plans for a Database
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
Q&A From “5 Ways to Improve Performance through Indexing”
A few weeks back spoke at a Pragmatic Works Training on the T's on indexing that was titled 5 Ways to Improve Performance through Indexing. The abstract for the sessions is: Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this session, we’ll look … Continue reading Q&A From “5 Ways to Improve Performance through Indexing”
Webcast Presentation Materials: 5 Ways to Improve Performance through Indexing
This past Tuesday, I delivered a presentation for Pragmatic Works Training on the T's. The session I delivered was 5 Ways to Improve Performance through Indexing. The abstract for the sessions is: Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this … Continue reading Webcast Presentation Materials: 5 Ways to Improve Performance through Indexing
My TechEd Presentation: Indexing Fundamentals for Microsoft SQL Server
This past Monday, I presented at TechEd North America for the first time. The session presented was Indexing Fundamentals for Microsoft SQL Server. Indexing is such a huge topic, that it was hard to boil down the fundamentals to a 75-minute presentation, but based on responses I think the resulting session was pretty good. If … Continue reading My TechEd Presentation: Indexing Fundamentals for Microsoft SQL Server
Index Analysis May Update
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
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
That’s Actually A Duplicate Index
As I've worked with clients on performance tuning through index improvements, one of the common areas that I discuss with them are duplicate indexes. The problem with duplicate indexes is that they are pointless and redundant. All they provide is an additional physical copy of the index and all you get is another index for … Continue reading That’s Actually A Duplicate Index