This project involves performing a series of SQL queries on the dvdrental sample database to explore various aspects of data retrieval and manipulation. Below are the scenarios and objectives covered ...

Great blog entry from Denny Lee on optmising distinct count measures here: I’d seen a ppt deck of a presentation he did at PASS a few years ago where he first set out these ideas, but it lo… ...