Are there any recommended books or resource which explain the internal workings of SQL Server engine(2008, 2012)? Which for example explains why Jeff's answer scales better than the solution provided...

Luis Cazares (6/11/2014)

---

Hi Rob,

The problem with your first query is that you missed to add the join condition for the CustomerID. In result, you're getting a cross join between all...

Hi,

I am new to SQL and tried to solve this in my own way. In one of my approaches I first wanted to get a list of the customers who...