Expert T-SQL window functions in SQL server. ([2015])

• Record Type: Book
• Further Information: Note: Kathi Kellenberger with Clayton Groom.
• Authors: Kellenberger, Kathi; Groom, Clayton
• Contents: ""Contents at a Glance""; ""Contents""; ""About the Authors""; ""About the Technical Reviewer""; ""Acknowledgments""; ""Authorâ€?s Note""; ""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 Queries""; ""Using 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 Aggregates""; ""The 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 PERFORMANCE""; ""Summary""; ""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""
• Publisher Details: Berkeley, CA : Apress
• Publication Date: 2015
• Extent: 1 online resource, illustrations
• Subjects: 005.75/6; Computer science; SQL (Computer program language); COMPUTERS -- Programming Languages -- SQL; SQL (Computer program language); Computer Science; Database Management; Programming Languages, Compilers, Interpreters; Computers -- Programming Languages -- General; Programming & scripting languages: general; Database management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484211038; 1484211030; 1484211049; 9781484211045
• Related ISBNs: 9781484211045
• Notes: Note: Vendor-supplied metadata.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.