Tag Archives: CTE

Deduplicating data with a CTE

Posted on July 27, 2011 by thomasrushton

Typical.  You answer a question only to find that the answer you provided isn’t what the original poster was looking for by reading the dozen or so comments that arrived on the question while you were figuring out your answer… … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 2 Comments

T-SQL Tuesday #018 – CTEs – They’re not always good for you

Posted on May 10, 2011 by thomasrushton

T-SQL Tuesday is a monthly event on the second Tuesday of each month; various SQL Server bloggers write about a specific topic.  In this case, the subject, chosen by Bob Pusateri (blog | twitter), is CTEs or “Common Table Expressions”. … Continue reading →

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , | 6 Comments

T-SQL Tuesday #16 – Aggregates and Average Weekly Backup Sizes

Posted on March 8, 2011 by thomasrushton

T-SQL Tuesday this month is hosted by Jes Borland. T-SQL Tuesday, which occurs on the second Tuesday of each month, provides an opportunity for many SQL Server bloggers to come together to discuss a single issue, selected by the host … Continue reading →

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , , , | 2 Comments