on 3 September 2010
I have read over 25 books on SQL Server.
In my opinion - This one is by far the best - highly recommended for all levels, from beginner to advanced.
To become proficient in querying relational databases - you have to understand the maths based set theory and predicate logic, upon which Relational Databases are founded. This book elegantly achieves the difficult task of - clearly explaining the theory, then building upon this with illustrations which solve hundreds of realistic real world complex problems .
on 12 February 2015
Great book. Pitched at a sensible level - assumes you know the basics of SQL, so doesn't waste time covering these, just straight into useful stuff. Covers the following topics:
- Logical query plans v physical query plans
- Examining query plans and query optimisations
- Missing indexes
- Join ordering
- Window / ranking functions
- The apply operator
- Aggregation and pivoting
- Data updates
- Querying partitioned tables
- Common SQL problems (top n for each group, compare current and previous)