Expert T-SQL window functions in SQL server
Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. First introduced in SQL Server 2005, window functions came into full blossom with SQL Server 2012. They truly are one of the most notable developme…
Read More ↓Title Statements
- Full title :Expert T-SQL window functions in SQL server / Kathi Kellenberger with Clayton Groom.
Summary
Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. First introduced in SQL Server 2005, window functions came into full blossom with SQL Server 2012. They truly are one of the most notable developments in SQL in a decade, and every developer and DBA can benefit from their expressive power in solving day-to-day business problems. Begin using windowing functions like ROW_NUMBER and LAG, and you will discover more ways to use them every day. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your queries will run faster, they will be easier to write, and they will be easier to deconstruct and 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 explains clearly how to get the best performance. The book also covers the rare cases when older techniques are the best bet. Stop using cursors and self-joins to solve complicated queries. Become a T-SQL expert by mastering windowing functions. Teaches you how to use all the window functions introduced in 2005 and 2012. Provides real-world examples that you can experiment with in your own database. Explains how to get the best performance when using windowing functions.
Read More ↓Edition Statements
- Publication Date:2015
Publication Statements
- Publisher(s):Apress
- Place of Publication:Berkeley, CA
- Language:eng
- Publication Date:2015
Notes
Includes index.
The Physical Object
- Description:1 online resource : : illustrations
Edition Identifiers
- ISBN:9781484211038, 1484211030, 1484211049, 9781484211045
- DOI:10.1007/978-1-4842-1103-8
- oclc:ocn905902707
- LC Classification:QA76.73.S67
- Dewey Decimal:005.75/6
Table of 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 GroupSolving 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 FunctionsPerforming Time Comparisons -- Summary -- Ch…
Subjects
Writers
More from this Series
No reviews yet. Be the first to rate this work.
Related Works
more →
Database management systems
Database concepts
Python data science essentials: a practitioner's guide covering essenti…
Boschetti, Alberto
Mastering Lotus Notes and Domino 6
DAMA-DMBOK: data management body of knowledge
The Modern Data Warehouse in Azure: Building with Speed and Agility on Micr…
How, Matt
111 Thesen zur erfolgreichen Softwareentwicklung: Argumente und Entscheidungshilfen für M…
Gerlich, Rainer
Practical Entity Framework: Database Access for Enterprise Applicat…
Gorman, Brian L.
Digital libraries: 6th Italian Research Conference, IRCDL …
Italian Research Conference on Digital Libraries, Padua, Italy)
Database programming with C♯: understand the options available in usi…
Thomsen, Carsten
Advances in knowledge discovery and data mining: 10th Pacific-Asia conference, PAKDD 200…
Pacific-Asia Conference on Knowledge Discovery and Data Mining, Singapore)
Knowledge science, engineering and management: first international conference, KSEM 20…
KSEM 2006, Guilin, Guangxi Zhuangzu Zizhiqu, China)
Rate & Review