Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries (Paperback or Softback)

Name: Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries (Paperback or Softback)
Author: Kellenberger, Kathi
ISBN: 9781484251966

Kellenberger, Kathi

Language: English

Published by Apress 11/3/2019, 2019

1484251962 / 9781484251966

Softcover
New

See all details

Seller: BargainBookStores, Grand Rapids, MI, U.S.A.BargainBookStores

5-star seller

AbeBooks seller since January 23, 2002

View this seller's items

Softcover

Condition: New

US$ 42.61

Free Shipping

Ships within U.S.A.

Quantity: 5 available

Add to basket

Free 30-day returns

Save for laterCreate a Want for similar items

Item description from seller

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

Seller Inventory # BBS-9781484251966

Contact seller about this item

Report this item

Title: Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries (Paperback or Softback)
Author: Kellenberger, Kathi
Publisher: Apress 11/3/2019
Publication year: 2019
Condition: New
Book Type: Book
Binding: Paperback or Softback
Language: English
ISBN 10: 1484251962
ISBN 13: 9781484251966
Edition: 2nd Edition
Item weight: 0.9 pounds

Become an expert who can use window functions to solve T-SQL query problems. Replace slow cursors and self-joins with queries that are easy to write and perform better. This new edition provides expanded examples, including a chapter from the world of sports, and covers the latest performance enhancements through SQL Server 2019.

Window functions are useful in analytics and business intelligence reporting. They came into full blossom with SQL Server 2012, yet they are not as well known and used as often as they ought to be. This group of functions is one of the most notable developments in SQL, and this book shows how every developer and DBA can benefit from their expressive power in solving day-to-day business problems. Once you begin using window functions, such as ROW_NUMBER and LAG, you will discover many ways to use them. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your querieswill run faster, be easier to write, and easier to deconstruct, maintain, and enhance in the future.

Just knowing and using these functions is not enough. You also need to understand how to tune the queries. Expert T-SQL Window Functions in SQL Server clearly explains how to get the best performance. The book also covers the rare cases when older techniques are the best bet.

What You Will Learn

Solve complex query problems without cumbersome self-joins that run slowly and are difficult to read
Create sliding windows in a result set for computing such as running totals and moving averages
Return aggregate and detail data simultaneously from the same SELECT statement
Compute lag and lead and other values that access data from multiple rows in a result set
Understand the OVER clause syntax and how to control the window
Avoid framing errors that can lead to unexpected results

Who This Book Is For

Anyone who writes T-SQL queries, including database administrators, developers, business analysts, and data scientists. Before reading this book, you should understand how to join tables, write WHERE clauses, and build aggregate queries.

"Synopsis" may belong to another edition of this title.

BargainBookStores

Grand Rapids, MI, U.S.A.

5-star seller

AbeBooks seller since January 23, 2002

Shipping rates within U.S.A.

Item	4 to 10 business days	4 to 9 business days
First item	US$ 0.00	US$ 39.50

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.

Payment methods

Store description

Save up to 90% on your favorite items at BargainBookStores.com! Our 20,000 square foot warehouse in Grand Rapids, Michigan is filled with hundreds of thousands of books and consumer goods, all at the lowest prices! We've been serving internet customers with great deals since 2001. All books ship from Grand Rapids, Michigan. 100% Customer Satisfaction Guaranteed We want to ensure your satisfaction. If you are dissatisfied with your purchase or shopping experience, we would like to hear from you. Please contact us by email: cs@bargainbookstores.com. Please be sure to include your contact information and order number. We do not charge a restocking fee for returns. Your Privacy BargainBookStores.com does not provide, sell or market customer information to other businesses or organizations.…

Specialty

Out of Print Books, Specializing in Academic and Professional Books, Bargain Books - Save Up to 90% Off Publisher's List Price!, Remainder Books, Store-Wide Range of New Books in all Categories

Seller's business information

BargainBookStores

3423 Lousma Dr SE
Grand Rapids, MI U.S.A. 49548

Contact sellerView this seller's itemsView seller's storefront

Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries (Paperback or Softback)

Item description from seller

Bibliographic details

Synopsis

About the title

About the Author

BargainBookStores

Shipping rates within U.S.A.

Payment methods

Store description

Specialty

Seller's business information

Terms of sale

Shipping terms