Shop now Shop now Shop now Shop Black Friday Deals Refreshed in Fashion Cloud Drive Photos Shop now Learn More Shop now DIYED Shop now Shop Fire Shop Kindle Paperwhite Listen in Prime Shop Now Shop now

Customer Reviews

4.0 out of 5 stars4
4.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star

Your rating(Clear)Rate this item
Share your thoughts with other customers

There was a problem filtering reviews right now. Please try again later.

1 of 1 people found the following review helpful
on 12 September 2013
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).
0CommentWas this review helpful to you?YesNoReport abuse
on 29 July 2013
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.
0CommentWas this review helpful to you?YesNoReport abuse
2 of 3 people found the following review helpful
on 23 February 2013
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"
0CommentWas this review helpful to you?YesNoReport abuse
1 of 2 people found the following review helpful
on 16 July 2012
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!
0CommentWas this review helpful to you?YesNoReport abuse

Send us feedback

How can we make Amazon Customer Reviews better for you?
Let us know here.

Sponsored Links

  (What is this?)
Meet The Top 10 SQL Server Developers For Hire in November.
Identify Bottlenecks & Wait Types. DBA Performance Tools. Free Trial.