This is the sixth and last for now post in which I’m going through a query that can be used to analyze indexes. Thus far the following has been added to the query: Combine existing index statistics and missing indexes into a single output Find existing duplicate and overlapping indexes Find the relationship between indexes … Continue reading Analyze This – Analyze Your Indexes – Part 6
Month: April 2009
Analyze This – Analyze Your Indexes – Part 5
This is the fifth post in which I am walking through a query that I use to analyze indexes. Thus far I have added to the following to the query that I use: Combine existing index statistics and missing indexes into a single output Find existing duplicate and overlapping indexes Find the relationship between indexes … Continue reading Analyze This – Analyze Your Indexes – Part 5
Find Query Plans That May Utilize Parallelism
When ever I go to a new client to assist with performance issues, I inevitably download the Troubleshooting Performance Problems in SQL Server 2005 white paper. In my opinion and many others, it is one of those documents that should be at the click of a button to open and I keep it handy on … Continue reading Find Query Plans That May Utilize Parallelism
Analyze This – Analyze Your Indexes – Part 4
This is the fourth post in which I am walking through a query that I use to analyze indexes. Thus far I have added to the following to the query that I use: Combine existing index statistics and missing indexes into a single output Find existing duplicate and overlapping indexes Find the relationship between indexes … Continue reading Analyze This – Analyze Your Indexes – Part 4
What is the size of your index?
I got the following question a couple days ago: “I have one problem with my database. The size of mdf file is huge and i feel it is not the data that is causing the increase in size, i feel indexes might be occupying space. Is there any way to find that indexes are occupying … Continue reading What is the size of your index?
Analyze This – Analyze Your Indexes – Part 3
This is the third post in which I am walking through a query that I use to analyze indexes. Thus far I have added to the following to the query that I use: Combine existing index statistics and missing indexes into a single output Find existing duplicate and overlapping indexes An error in the WHERE … Continue reading Analyze This – Analyze Your Indexes – Part 3
Analyze This – Analyze Your Indexes – Part 2
This is the second post in which I am walking through a query that I use to analyze indexes. For some reason the grammar on the title of the first post was a bit jacked so I’ve corrected it for this post and the all following ones. Here’s a summary of what I’ve added to … Continue reading Analyze This – Analyze Your Indexes – Part 2
Analyze This – Your Indexes Analysis – Part 1
Shrinks have no idea what’s wrong with you when you walk in the door. In you come you try to describe what appears to be the problem and then they start asking about your mother. But you don’t want to talk about your mother, most likely you’d like some relief to whatever the concern is … Continue reading Analyze This – Your Indexes Analysis – Part 1
Populating Birthday From Contacts
This is completely off topic and has everything to do with Outlook and my calendar. While traveling something happened to my contact and calendar synchronization and I ended up with 4 or 5 birthdays for all of my contacts. Some were on a single day and others started and ended 2-hours early – most likely … Continue reading Populating Birthday From Contacts
Strate SQL 