國立虎尾科技大學 |

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

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Expert T-SQL Window Functions in SQL Server 2019/ by Kathi Kellenberger, Clayton Groom, Ed Pollack.
Reminder of title:	The Hidden Secret to Fast Analytic and Reporting Queries /
Author:	Kellenberger, Kathi.
other author:	Groom, Clayton.
Description:	XVIII, 213 p. 123 illus.online resource. :
Contained By:	Springer Nature eBook
Subject:	Database management. -
Online resource:	https://doi.org/10.1007/978-1-4842-5197-3
ISBN:	9781484251973

Expert T-SQL Window Functions in SQL Server 2019 = The Hidden Secret to Fast Analytic and Reporting Queries /
Kellenberger, Kathi.

Expert T-SQL Window Functions in SQL Server 2019The Hidden Secret to Fast Analytic and Reporting Queries /[electronic resource] :by Kathi Kellenberger, Clayton Groom, Ed Pollack. - 2nd ed. 2019. - XVIII, 213 p. 123 illus.online resource.

1. Looking through the Window -- 2. Discovering Ranking Functions.-3. Summarizing with Window Aggregates -- 4. Calculating Running and Moving Aggregates -- 5. Adding Frames to the Window -- 6. Taking a Peek at Another Row -- 7. Understanding Statistical Functions -- 8. Tuning for Better Performance -- 9. Hitting a Home Run with Gaps, Islands, and Streaks -- 10. Time Range Calculations -- 11. Time Trend Calculations.

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 queries will 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. You will: 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.

ISBN: 9781484251973

Standard No.: 10.1007/978-1-4842-5197-3doiSubjects--Topical Terms:

557799
Database management.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

Expert T-SQL Window Functions in SQL Server 2019 = The Hidden Secret to Fast Analytic and Reporting Queries /
LDR:03661nam a22003975i 4500 001 1015010
003 DE-He213
005 20200702012522.0
007 cr nn 008mamaa
008 210106s2019 xxu| s |||| 0|eng d
020 $a 9781484251973 $9 978-1-4842-5197-3
024 7 $a 10.1007/978-1-4842-5197-3 $2 doi
035 $a 978-1-4842-5197-3
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Kellenberger, Kathi. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 792340
245 1 0 $a Expert T-SQL Window Functions in SQL Server 2019 $h [electronic resource] : $b The Hidden Secret to Fast Analytic and Reporting Queries / $c by Kathi Kellenberger, Clayton Groom, Ed Pollack.
250 $a 2nd ed. 2019.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2019.
300 $a XVIII, 213 p. 123 illus. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a 1. Looking through the Window -- 2. Discovering Ranking Functions.-3. Summarizing with Window Aggregates -- 4. Calculating Running and Moving Aggregates -- 5. Adding Frames to the Window -- 6. Taking a Peek at Another Row -- 7. Understanding Statistical Functions -- 8. Tuning for Better Performance -- 9. Hitting a Home Run with Gaps, Islands, and Streaks -- 10. Time Range Calculations -- 11. Time Trend Calculations.
520 $a 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 queries will 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. You will: 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.
650 0 $a Database management. $3 557799
650 0 $a Programming languages (Electronic computers). $3 1127615
650 0 $a Microsoft software. $3 1253736
650 0 $a Microsoft .NET Framework. $3 565417
650 1 4 $a Database Management. $3 669820
650 2 4 $a Programming Languages, Compilers, Interpreters. $3 669782
650 2 4 $a Microsoft and .NET. $3 1114109
700 1 $a Groom, Clayton. $e author. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1264122
700 1 $a Pollack, Ed. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1108406
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484251966
776 0 8 $i Printed edition: $z 9781484251980
856 4 0 $u https://doi.org/10.1007/978-1-4842-5197-3
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)