T-SQL Window Functions: For data analysis and beyond

Description

Use window functions to write simpler, better, more efficient T-SQL queries 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 About This Book • For developers, DBAs, data analysts, data scientists, BI professionals, and power users familiar with T-SQL queries • Addresses any edition of the SQL Server 2019 database engine or later, as well as Azure SQL Database Get all code samples at: MicrosoftPressStore.com/TSQLWindowFunctions/downloads

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Other editions

• 

  T-SQL Window Functions

  • 2019-11-04
  • 352 pages
  • Paperback
  • Microsoft Press

Similar books

• 

  Expert T-SQL Window Functions in SQL Server

  By Kathi Kellenberger, Clayton Groom

  You also need to understand how to tune the queries. Expert T-SQL Window Functions in SQL Server explains clearly how to get the best performance. The book also covers the rare cases when older techniques are the best bet.

• 

  Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

  By Itzik Ben-Gan

  Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.

• 

  Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries

  By Kathi Kellenberger, Clayton Groom, Ed Pollack

  Before reading this book, you should understand how to join tables, write WHERE clauses, and build aggregate queries.

• 

  T-SQL Querying

  By Adam Machanic, Dejan Sarka, Itzik Ben-Gan

  Write faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation ...

• 

  SQL in a Nutshell: A Desktop Quick Reference

  By Daniel Kline, Kevin Kline, Brand Hunt

  For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products.

• 

  Microsoft SQL Server 2012 T-SQL Fundamentals

  By Itzik Ben-Gan

  Presents information on the fundamentals of T-SQL to develop code and query and modify data in Microsoft SQL Server 2012.

• 

  SQL Cookbook

  By Anthony Molinaro

  A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.

• 

  Beginning T-SQL: A Step-by-Step Approach

  By Kathi Kellenberger, Lee Everest

  Beginning T-SQL starts you on the path to mastering T-SQL with an emphasis on best practices. Using the sound coding techniques taught in this book will lead to excellent performance in the queries that you write in your daily work.

• 

  Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications

  By Lisa Bohm

  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 functionality that is supported in current versions of SQL ...

• 

  SQL Server 2019 Administration Inside Out

  By Joseph D'Antoni, Louis Davidson, William Assaf

  Conquer SQL Server 2019 administration–from the inside out Dive into SQL Server 2019 administration–and really put your SQL Server DBA expertise to work.