Microsoft SQL Server 2012. Высокопроизводительный код T-SQL. Оконные функции

by Itzik Ben-Gan, Ицик Бен-Ган

Эта книга - подробное руководство по применению оконных функций в SQL Server, а также в стандарте SQL, в том числе по использованию элементов, которые пока не реализованы в SQL Server. Здесь описаны принципы работы с окнами в SQL Server и работа различных оконных функций (ранжирования, аналитики, агрегирования и смещения), а также функции упорядоченных наборов. Подробно освещен вопрос оптимизации оконных функций в SQL Server 2012 для достижения максимальной производительности. Отдельная глава посвящена тщательному анализу примеров практического применения оконных функций.
Книга состоит из пяти глав; адресована разработчикам для SQL Server и администраторам баз данных, а также всем, кому необходимо создавать запросы и разрабатывать код с использованием T-SQL.

Подробнее: http://www.labirint.ru/books/372984/

256 pages, Paperback

First published April 15, 2012

About the author

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions and Microsoft SQL Server 2012 T-SQL Fundamentals. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.

Itzik Ben-Gan is a co-founder of Solid Quality Mentors, a technical education company, and is a Microsoft SQL Server MVP.

Reviews

[Tim · Rating 5 out of 5]

Whether you've never used window functions in your life and are looking to learn about them, or you've been using them occasionally and are looking to systematize your knowledge, or even if you've been using them all the time, you are going to benefit from reading this book. It starts with an explanation of theory, throws in a few practical examples to whet your appetite, covers each individual function in depth, and provides a plethora of examples to keep you going; all in a very clear, methodical, and thorough Ben-Gan fashion. My only gripe is that the author is too enthusiastic to show "alternative" ways to address problems, which usually means standard, pre-window functions SQL. While this is not useless or uninteresting information, I doubt someone would intentionally pick up a book on window functions when looking for ways on how to do without them! It would be more beneficial to include additional examples of real-life problems instead (the ones included are great, but if you have prior window experience with window functions, you've probably seen and used most of them already). Still, this is a minor gripe which in no way detracts from the overall value of the book. If window functions is something you want to learn about, this is a great resource.