Return of Index Analysis Part 5

Alright, up to the last of the changes I’ve made to the index analysis query that I had planned.  This makes the fifth post in the series on this query. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output … Continue reading Return of Index Analysis Part 5

3-Weeks to PASS Summit 2010 Countdown –

Only 3 more weeks until the PASS Summit and it's time for another countdown post. I've done a few of these now ( 1 , 2 , 3 , 4 ) to hopefully prepare readers for the opportunities at PASS. Trying make sure that you will know as much as possible about the summit to … Continue reading 3-Weeks to PASS Summit 2010 Countdown –

Return of Index Analysis Part 4

We’ve got through the first three parts of this continued series on the Index Analysis query last week.  The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes … Continue reading Return of Index Analysis Part 4

SSWUG Fall 2010 Virtual Conference Starts Today!

Conference Time! The SSWUG Fall 2010 Virtual Conference is starting today.  It’ll go on from today through Friday – if might be getting late but you can still attend the conference.  It doesn’t matter if you are in the comforts of your living room, office, or couch.  You can still sit back where ever you … Continue reading SSWUG Fall 2010 Virtual Conference Starts Today!

SSWUG Fall 2010 Virtual Conference This Week

Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up this week.  On October 20-22, you can attend a conference from the comforts of your living room, office, or couch.  And while you are at it you’ll get to sit in on some incredible presentations, interaction with speakers, and chat with other attendees. All … Continue reading SSWUG Fall 2010 Virtual Conference This Week

Finding Missing Values from an Array

Missing Numbers Today a developer came up to me and wanted help solving a problem he was running into with a list of numbers.  He had a list of 53 numbers in a comma separated list. Unfortunately, the 53 numbers were not all in the table that he was querying.   He wanted to know if … Continue reading Finding Missing Values from an Array

Return of Index Analysis Part 3

Time for part three of my continued Index Analysis query.  The previous posts in this series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes Analyze Your Indexes Part 3 – Find the relationship … Continue reading Return of Index Analysis Part 3

Return of Index Analysis Part 2

Time for part two of my continued Index Analysis query.  The previous posts in this series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes Analyze Your Indexes Part 3 – Find the relationship … Continue reading Return of Index Analysis Part 2