Posts Tagged: T-SQL

Aggregating With Correlated Sub-Queries #tsql2sday

Posted by & filed under , , , , , .

It’s that time of the month again.  Time for T-SQL Tuesday!  This month’s event is being hosted by Jes Schultz Borland (Blog|@grrl_geek).  The topic that she chose for this month is aggregates. The Dilemma A few months ago, a client I was working with had a dilemma with one of their search queries.  A query […]

Lego Analyze

Return of Index Analysis Part 4

Posted by & filed under , , , , , , .

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 […]

Lego Analyze

Return of Index Analysis Part 2

Posted by & filed under , , , , , , .

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 […]

Lego Analyze

Return of Index Analysis Part 1

Posted by & filed under , , , , , , .

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 […]