So much truth in those two words: "It depends." 🙂  I repeat these words often when discussing SQL-related topics with my coworkers.

Thanks for the article.  I found this helpful to expand my knowledge of functionality in more recent versions of SQL Server.
One thing that might be worth pointing out directly...

Heh, I read the last sentence about business-critical logic being stored "in Access on an old laptop in a cupboard somewhere", and my mind immediately substituted that with "in the...

venoym (2/4/2015)

---

The explanation is not correct. We do not want all rows except for Jones on 2008-04-01. We want all where cnt > 1. This will remove...

I'd love to win a copy of this book too. 🙂

WITH cte AS (

SELECT 1 AS UserID, 1 AS GroupID, 10 As Rating

UNION ALL SELECT...