Customer Reviews


4 Reviews
5 star:    (0)
4 star:
 (4)
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

1 of 1 people found the following review helpful
4.0 out of 5 stars Pretty good book, 12 Sep 2013
By 
D. Stan (U.K.) - See all my reviews
(REAL NAME)   
Verified Purchase(What is this?)
This review is from: Microsoft SQL Server 2012 High Performance T-SQL Using Window Functions (Paperback)
The book is split in two (in my opinion): the first part explains everything about the window functions implementation in SQL Server 2012 (and also what is missing still from the standard); the second part is about optimizing window functions.

However, it's one of those books that is so well written, that you just read it once, grasp the concepts, and never look back to it. I got the paperback, but now after reading it I wish I had bought the Kindle version.

As a SQL Server Professional, I rate it 4 stars, mainly because most of the stuff in the first part can be found on the Internet (up to a certain extent) or in other books Itzik wrote, but definitely the second part (Optimizations) it's pure Itzik magic that you won't find easily on Google.

Plenty of example code, explanations and lessons to be learnt in this book. Also some shockers (eg. when a RBAR cursor is faster than a set based approach), and even more shockers (I'll let you find out).

Must buy (on Kindle).
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


4.0 out of 5 stars clearly explains TSQL Window Functions, 29 July 2013
Verified Purchase(What is this?)
This review is from: Microsoft SQL Server 2012 High Performance T-SQL Using Window Functions (Paperback)
This book makes it easy to understand TSQL Window functions, explaining which functions implemented in the SQL Standard and explaining each function and how they are implemented in all the most commonly used database management systems including Oracle,Mysql but concentrating on Microsoft SQL Server.
Explaining each function in detail with some useful real-world uses that you will be able to adapt for your applications and databases.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


1 of 2 people found the following review helpful
4.0 out of 5 stars Its great BUT, 23 Feb 2013
By 
This review is from: Microsoft SQL Server 2012 High Performance T-SQL Using Window Functions (Paperback)
Lots of info here about windowing function BUT its gets quite annoying learning all about a function only to find it isnt implemented in SQL 2012. This is a SQL2012 book, stick to SQL 2012 concepts. Too much "this isnt included in SQL 2012 but Im going to talk about it anyway" and "wouldnt it be cool if SQL did these things"
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


1 of 2 people found the following review helpful
4.0 out of 5 stars Excellent book, 16 July 2012
By 
R Howson (Doncaster, South Yorkshire United Kingdom) - See all my reviews
Verified Purchase(What is this?)
This is a great book that I am learning lots from. As I implement these new techniques my query performance is improving massively and my SQL is easier to read and maintain!
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Most Helpful First | Newest First

This product

Microsoft SQL Server 2012 High Performance T-SQL Using Window Functions
£22.99
In stock
Add to basket Add to wishlist
Only search this product's reviews