Tag Archives: CTE

Deduplicating data with a CTE

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

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 , , | 5 Comments

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

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