From the Blogosphere
Book Review: Expert T-SQL Window Functions in SQL Server | @CloudExpo #API #Cloud #TSQL #SQLServer
These Window functions make it easy to calculate running totals, moving averages and more
By: Steven Mandel
Aug. 18, 2016 01:00 PM
There is an old saying that good things come in small packages. This saying definitely applies to this book, which focuses in on a set of functions that most people are not aware of that are available in SQL Server. To start off with we need to answer the following question: What are T-SQL Window functions? These functions have nothing to do with the Microsoft Windows API. They are in essence a way to create a window into your data as you process each line in a query. Their strength lies in the ease with which you can solve tricky queries. The authors also point out that these functions don't add any new functionality per se as you could create the queries the old way; however, in general the functions are much more efficient.
One very neat capability of these functions is to allow you to include non-aggregated columns in an aggregated query, which is a big limitation with existing aggregate functions. These Window functions make it easy to calculate running totals, moving averages and more. Also starting with SQL Server 2012, you can add an order by to window aggregates to calculate running totals.
I like this book because the authors provide real-world examples that these functions can solve. Each chapter discusses some of the functions and, in many of the chapters, examples of how to solve real problems are provided. Here is a partial list of some of the examples provided.
There is also a well-written chapter on performance. It discusses how to determine how well these functions perform. It includes a discussion on tuning and how to understand execution plans and statistics. These give you a basic understanding of how to gauge performance.
This book is well worth having for any SQL developer wishing to expand his or her knowledge and skills but especially if you generate a lot of reports with a lot of analytical data. If you do a lot of number crunching with SQL Server, you'll want to buy this book.
Reader Feedback: Page 1 of 1
Latest Cloud Developer Stories
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
SYS-CON Featured Whitepapers
Most Read This Week