Programming Books C Java PHP Python Learn more Browse Programming Books
Microsoft SQL Server 2012 High-Performance T-SQL Using Wi... and over one million other books are available for Amazon Kindle. Learn more
Buy New
$26.27
Qty:1
  • List Price: $36.99
  • Save: $10.72 (29%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $8.53
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference) Paperback – May 1, 2012

ISBN-13: 978-0735658363 ISBN-10: 0735658366 Edition: 1st

Buy New
Price: $26.27
42 New from $23.38 23 Used from $18.50
Amazon Price New from Used from
eTextbook
"Please retry"
Paperback
"Please retry"
$26.27
$23.38 $18.50

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference) + Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) + Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 (Microsoft Press Training Kit)
Price for all three: $101.12

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: Developer Reference
  • Paperback: 244 pages
  • Publisher: Microsoft Press; 1 edition (May 1, 2012)
  • Language: English
  • ISBN-10: 0735658366
  • ISBN-13: 978-0735658363
  • Product Dimensions: 9 x 7.4 x 0.6 inches
  • Shipping Weight: 13.6 ounces (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (12 customer reviews)
  • Amazon Best Sellers Rank: #43,740 in Books (See Top 100 in Books)

Editorial Reviews

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.


More About the Author

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 T-SQL Fundamentals and Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. He has written many articles for SQL Server Pro as well as articles and whitepapers for MSDN. Itzik's speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and SolidQ's events to name a few. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.
For more details please visit http://tsql.solidq.com.

Customer Reviews

4.3 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

19 of 19 people found the following review helpful By Dr. Robotnik on May 25, 2012
Format: Paperback Verified Purchase
This book is a refreshing alternative to the usual 900 page everything-and-the-kitchen sink tomes that seem to dominate this genre.

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.)
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 13 people found the following review helpful By SQL Learner on August 20, 2012
Format: Paperback
One of the good "Cheat" book I came across. Yes, I agree with many that there is no doubt Itzik Ben-Gan is one of the great T-SQL experts in the industry. Initially I thought many of the functions he described cannot be used in OLTP model. Very quickly I realized I was wrong to some extent, I had to identify duplicate entries and Islands and the queries were right there. But I think I will stick to my Original Comment - the book is very specific for certain window function as the title suggests which are - ranking, distribution, ordering, getting ranges, gaps, island, duplicates, running totals, packing intervals, aggregates and finally optimizing them. Ofcourse that's what the title suggest (Window Functions..) and is very well concised in 200 odd pages when compared to 900 or so in other books. Actually I was expecting - to know different alternatives for creating such functions, which I did not find much. There is a mention of CLR, but one should be good with .NET coding. My final conclusion would be go for the book in case you have to deal a lot with analytical type of coding. This is the book, where we can simply use the proven logic.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 5 people found the following review helpful By John on June 3, 2012
Format: Paperback
Worth every penny. Every chapter is packed with new tools for your toolbox. I am wrapping up a project that would not have been possible without these window functions.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By T. Copling on February 12, 2014
Format: Kindle Edition Verified Purchase
The book started off great explaining Window Functions; however I felt that there were certain parts that the author could have left out. For example, he went over some functionality that wasn't available in SQL SERVER; where I was hoping he would focus primarily with what was currently available. Overall, it's a good book; I'm definitely going to have to read it again.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By John R. Spencer on November 11, 2012
Format: Paperback Verified Purchase
The book has proven invaluable on the job in a current project.
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 4 people found the following review helpful By Guna on July 25, 2012
Format: Paperback Verified Purchase
Initially I had a doubt before buying this book regarding the content and how clearly does it explain the Window Functions concepts. But Author Itzik Ben - Gan has given a detailed explanation of Different types of Window Functions supported in SQL Server, what the Standard SQL supports and at one point he explained a feature present in Teradata. I recommend this book to people who want to take advantage by using Windows Functions
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Search