Posts Tagged: T-SQL

2741583611_faa31b7acb_m.jpg

December AppDev Webcast

Posted by & filed under , , , , .

The new year is just around the corner.  And before you know it, we’ll have an opportunity to start moving SQL Server 2012 into production.  While we anxiously await that day, it is a good idea to make sure that you are up on the latest T-SQL enhancements that are coming in the next release.  […]

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 the Index Analysis Report

Posted by & filed under , , , .

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

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