Shop now Shop now Shop now Shop All Amazon Fashion Up to 70% off Fashion Cloud Drive Photos Shop now Shop Amazon Fire TV Shop now Shop Fire HD 6 Learn More Shop now Shop now Shop now

Customer Reviews

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

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?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report 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?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report 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?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report 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?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
     
 
Customers who viewed this item also viewed
Microsoft SQL Server 2012 T-SQL Fundamentals
Microsoft SQL Server 2012 T-SQL Fundamentals by Itzik Ben-Gan (Paperback - 15 July 2012)
£21.07

T-SQL Querying (Developer Reference)
T-SQL Querying (Developer Reference) by Itzik Ben-Gan (Paperback - 6 Mar. 2015)
£24.04

Microsoft SQL Server 2012 Internals
Microsoft SQL Server 2012 Internals by Kalen Delaney (Paperback - 12 Dec. 2013)
£38.39
 
     

Send us feedback

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

Sponsored Links

  (What is this?)
  -  
Best of TechEd 2012 Award Winner. Download Full Feature 30 Day Trial.
  -  
with Datadog. Graph, Analyze, & Alert on Metrics. Try Free Now!
  -  
Meet The Top 10 SQL Server Developers For Hire In August 2015.