Customer Reviews


4 Reviews

4 star
0

3 star
0

2 star
0

1 star
0

 
 
Average Customer Review
Share your thoughts with other customers
Create your own review
 
 
Most Helpful First | Newest First

9 of 9 people found the following review helpful
5.0 out of 5 stars The Best Microsoft SQL Server focused Book by far, 3 Sept. 2010
By 
Verified Purchase(What is this?)
This review is from: Inside Microsoft® SQL Server® 2008: T-SQL Querying (Developer) (Paperback)
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 .
Brilliant
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Best Tech book I've read, 7 Nov. 2011
This review is from: Inside Microsoft® SQL Server® 2008: T-SQL Querying (Developer) (Paperback)
NB I am primarly reviewing the earlier version Inside Microsoft® SQL ServerTM 2005: T-SQL Querying (Solid Quality Learning) and have only read parts of the newer book to cover various updates. But it is the best tech book I have read, even just a few pages of chapter one showed how much I didn't know. EG that the select statement didn't read (or was processed top to bottom) It starts with the 'from' statement goes down to the 'having' then up to the top for 'Select' and 'Distinct' then back to the bottom to 'Order by' then back to the top for the keyword 'Top'. This is pretty obvious once you know but why is it not in other books or in the course I went on! Anyway superbly written. Don't be put off by the physical query execution and the (query tuning/indexes) sections. I still haven't read most of those two chapters and still rate this as the best tech book I've ever read.
Worth the money. As another reviewer said, I'd buy another when this one falls apart.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Great book on TSQL - packed with good information, 12 Feb. 2015
Verified Purchase(What is this?)
This review is from: Inside Microsoft® SQL Server® 2008: T-SQL Querying (Developer) (Paperback)
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)
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars A must have for beginners, 8 May 2012
By 
Marvin L. Perrott (London, United Kingdom) - See all my reviews
(REAL NAME)   
Verified Purchase(What is this?)
This review is from: Inside Microsoft® SQL Server® 2008: T-SQL Querying (Developer) (Paperback)
This is a great book that give you a firm foundation in understanding SQL and the RDBMS model. It is methodical and explains the best methods of writing your code and more importantly how it will improve performance and reduce cost. There are always examples to illustrate the concept being explained and the logic behind it. An ex excellent resource.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Most Helpful First | Newest First

This product

Inside Microsoft® SQL Server® 2008: T-SQL Querying (Developer)
£30.99
In stock
Add to basket Add to wishlist
Only search this product's reviews