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

Name: Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
Author: Kellenberger, Kathi; Groom, Clayton; Pollack, Ed
ISBN: 9781484251966

Kellenberger, Kathi; Groom, Clayton; Pollack, Ed

Language: English

Published by Apress, 2019

1484251962 / 9781484251966

Softcover
Used

See all details

Seller: clickgoodwillbooks, Indianapolis, IN, U.S.A.clickgoodwillbooks

4-star seller

AbeBooks seller since July 5, 2024

View this seller's items

Softcover

Condition: Used - Good

US$ 31.72

US$ 3.99 shipping

Ships within U.S.A.

Quantity: 1 available

Add to basket

Free 30-day returns

Save for laterCreate a Want for similar items

Item description from seller

Used - Good: A book that has been read but is in good condition. Very minimal damage to the cover including scuff marks, but no holes or tears. The dust jacket for hard covers may not be included. Binding has minimal wear. The majority of pages are undamaged with minimal creasing or tearing, minimal pencil underlining of text, no highlighting of text, no writing in margins. No missing pages.

Seller Inventory # CSIV.1484251962.G

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
Author: Kellenberger, Kathi; Groom, Clayton; Pollack, Ed
Publisher: Apress
Publication year: 2019
Condition: good
Binding: Soft cover
Language: English
ISBN 10: 1484251962
ISBN 13: 9781484251966
Edition: 2nd Edition

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.

clickgoodwillbooks

Indianapolis, IN, U.S.A.

4-star seller

AbeBooks seller since July 5, 2024

Shipping rates within U.S.A.

Item	5 to 8 business days	3 to 6 business days
First item	US$ 3.99	US$ 9.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

About us Our Mission: Goodwill changes lives every day by empowering people to increase their independence and reach their potential through education, health and employment. Our services include: Tuition-free, charter high school for grades 9-12 for students experiencing barriers to education. Tuition-free, charter high schools for adults that focuses on removing barriers to education by offering students flexible scheduling, tutoring, life coaching, child care, transportation, college credits and other resources. Direct hiring for Goodwill jobs, especially for job-seekers with employment barriers like a disability, criminal history or limited education. Job readiness, training and placement for individuals with barriers. Pre-natal and maternal health, parenting skills, child development and school readiness. Connections to resources for transportation, housing, child care, financial literacy and more. A child development center and preschool for children ages six weeks to five years.…

Specialty

multiple genres, used books

Seller's business information

Goodwill of Central and Southern Indiana

1635 West Michigan Street
Indianapolis, IN U.S.A. 46222

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

Item description from seller

Bibliographic details

Synopsis

About the title

About the Author