XQuery for the Non-Expert – Terminology

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. It’s time for a new series to blog posts – XQuery for the Non-Expert.  The purpose for these posts will be to provide a foundation for using XQuery against XML. Myself, I am not an XQuery expert.  These … Continue reading XQuery for the Non-Expert – Terminology

Return of the Index Analysis Report

Finally up to the last post of this series resurgence.  Time to update the Index Analysis Custom Report that I developed last year. 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 … Continue reading Return of the Index Analysis Report

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

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

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