Home » Books » T-SQL Window Functions, 2nd Edition

T-SQL Window Functions, 2nd Edition Books

For data analysis and beyond

T-SQL Window Functions, 2nd Edition



Buy   Reviews
Price: $26.99
Rating:
Author: Itzik Ben-Gan
Publisher: Microsoft Press
Published on: 2019
Pages: 352
Format: Paper book / ebook (PDF)
ISBN-10: 0135861446
ISBN-13: 9780135861448


Description:

Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions. You'll find a detailed section on optimization, plus an extensive collection of business solutions - including novel techniques available in no other book.

Microsoft MVP Itzik Ben-Gan shows how to: Use window functions to improve queries you previously built with predicates; Master essential SQL windowing concepts, and efficiently design window functions; Effectively utilize partitioning, ordering, and framing; Gain practical in-depth insight into window aggregate, ranking, offset, and statistical functions; Understand how the SQL standard supports ordered set functions, and find working solutions for functions not yet available in the language; Preview advanced Row Pattern Recognition (RPR) data analysis techniques; Optimize window functions in SQL Server and Azure SQL Database, making the most of indexing, parallelism, and more; Discover a full library of window function solutions for common business problems.


Similar Books


T-SQL Window Functions, 2nd Edition

T-SQL Window Functions, 2nd Edition

by Itzik Ben-Gan Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them t......

Price:  $26.99  |  Publisher:  Microsoft Press  |  Release:  2019

Beginning T-SQL, 3rd Edition

Beginning T-SQL, 3rd Edition

by Kathi Kellenberger, Scott Shaw Beginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the......

Price:  $44.48  |  Publisher:  Apress  |  Release:  2014

Refactoring Legacy T-SQL for Improved Performance

Refactoring Legacy T-SQL for Improved Performance

by Lisa Bohm Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functi......

Price:  $23.99  |  Publisher:  Apress  |  Release:  2020