Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Expert T-SQL Window Functions in SQL Server / / by Kathi Kellenberger, Clayton Groom
| Expert T-SQL Window Functions in SQL Server / / by Kathi Kellenberger, Clayton Groom |
| Autore | Kellenberger Kathi |
| Edizione | [1st ed. 2015.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 |
| Descrizione fisica | 1 online resource (140 p.) |
| Disciplina |
004
005.13 005.74 |
| Collana | Expert's Voice in SQL Server |
| Soggetto topico |
Database management
Programming languages (Electronic computers) Database Management Programming Languages, Compilers, Interpreters |
| ISBN | 1-4842-1103-0 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents at a Glance; Chapter 1: Looking Through the Window; Discovering Window Functions; Thinking About the Window; Understanding the OVER Clause; Dividing Windows with Partitions; Uncovering Special Case Windows; Summary; Chapter 2: Discovering Ranking Functions; Using ROW_NUMBER; Understanding RANK and DENSE_RANK; Dividing Data with NTILE; Solving Queries with Ranking Functions; Deduplicating Data; Finding the First N Rows of Every Group; Solving the Islands Problem; Solving the Bonus Problem; Summary; Chapter 3: Summarizing with Window Aggregates; Using Window Aggregates
Adding Window Aggregates to Aggregate QueriesUsing Window Aggregates to Solve Common Queries; The Percent of Sales Problem; The Partitioned Table Problem; Creating Custom Window Aggregate Functions; Summary; Chapter 4: Tuning for Better Performance; Using Execution Plans; Using STATISTICS IO; Understanding the Performance Implications of Window Aggregates; Indexing to Improve the Performance of Window Functions; Performing Time Comparisons; Summary; Chapter 5: Calculating Running and Moving Aggregates; Adding ORDER BY to Window Aggregates; Calculating Moving Totals and Averages Solving Queries Using Accumulating AggregatesThe Last Good Value Problem; The Subscription Problem; Summary; Chapter 6: Adding Frames to the Window; Understanding Framing; Applying Frames to Running and Moving Aggregates; Measuring Performance; Understanding the Logical Difference Between ROWS and RANGE; Summary; Chapter 7: Taking a Peek at Another Row; Understanding LAG and LEAD; Understanding FIRST_VALUE and LAST_ VALUE; Using the Offset Functions to Solve Queries; The Year-Over-Year Growth Calculation; The Gaps Problem; Comparing Performance; LAG and LEAD Performance FIRST_VALUE and LAST_VALUE PERFORMANCESummary; Chapter 8: Understanding Statistical Functions; Using PERCENT_RANK and CUME_ DIST; Using PERCENTILE_CONT and PERCENTILE_ DISC; Comparing Statistical Functions to Older Methods; Summary; Chapter 9: Time Range Calculations and Trends; Putting It All Together; Percent of Parent; Period-to-Date Calculations; Averages, Moving Averages, and Rate-of-Change; Same Period Prior Year; Difference and Percent Difference; Moving Totals and Simple Moving Averages; Rate-of-Change Calculations; Summary; Index; Contents; About the Authors About the Technical ReviewerAcknowledgments; Author's Note |
| Record Nr. | UNINA-9910300643303321 |
Kellenberger Kathi
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
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
| 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 |
| Autore | Kellenberger Kathi |
| Edizione | [2nd ed. 2019.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 |
| Descrizione fisica | 1 online resource (221 pages) |
| Disciplina | 005.7565 |
| Soggetto topico |
Database management
Programming languages (Electronic computers) Microsoft software Microsoft .NET Framework Database Management Programming Languages, Compilers, Interpreters Microsoft and .NET |
| ISBN |
9781484251973
1484251970 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 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. |
| Record Nr. | UNINA-9910349524803321 |
|
Kellenberger Kathi
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||