- Series: Developer Reference
- Paperback: 244 pages
- Publisher: Microsoft Press; 1 edition (April 25, 2012)
- Language: English
- ISBN-10: 0735658366
- ISBN-13: 978-0735658363
- Product Dimensions: 7.1 x 0.3 x 8.8 inches
- Shipping Weight: 13.6 ounces (View shipping rates and policies)
- Average Customer Review: 23 customer reviews
- Amazon Best Sellers Rank: #719,807 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
What other items do customers buy after viewing this item?
About the Author
Itzik Ben-Gan is a principal mentor and a founder of SolidQ. A Microsoft MVP for SQL Server since 1999, Itzik teaches and consults internationally on T-SQL querying, programming, and query tuning. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Instead, it is focused and concise (200+ pages). And extremely well-written, by someone who clearly takes his teaching role seriously. Beyond just describing how to use the window functions, it does a great job of delving into the background needed to really understand how & why they work as they do.
In addition to describing SQL Server 2012 support for window functions, the book also details those areas in which full support for standard SQL window functions has not yet been implemented in SQL Server. It also suggests improvements that could be made to both the standard and to MS SQL.
Whenever possible, the book gives alternative queries constructed without the use of window functions. This is great as both a learning tool, and to convince you that in general you don't really want to go that route (non-window) if at all possible.
If you want to learn both the subtleties and quotidian uses of SQL window functions, get this book. Your brain will light up with new possibilities.
(If it helps credibility-wise, check out my mostly negative review of the same author's "Inside Microsoft SQL Server 2005: T-SQL Programming"--I am the proud holder of the "Most Helpful Critical Review" honor for that title. Ben-Gan's lucidity has increased considerably with this current effort.)
For now i will give this 5 stars but I still think it could be made simpler and more practical for us 'regular' users. I will say the accuracy of the book and samples seems pretty good so far which is nice since it can be annoying when you run into samples you are trying to learn from that don't work in some articles by other authors I have read. This authors material and books seem very accurate.
I wonder if regular expressions would be useful with these functions?
I had used 'window' functions in the past; however, I truly did not have a real understanding of what 'result set' I was working with. And, as correctly stated, performance was 'blazing' now that the use of a 'window' function is known to be using the current result set. While probably not a 'nugget' for SQL experts, just realizing that proved a real 'tip'...
I have used other books by the author and found his instructional style quite pleasing to deal with considering the 'complexity' of how one 'should' think when dealing with SQL.
Most recent customer reviews
I was hoping event more examples of applications.Read more
This is a must for enterprise data processing
Worth every dollar