Expert T-SQL window functions in SQL server [electronic resource] / Kathi Kellenberger with Clayton Groom.
2015
QA76.73.S67 K45 2015eb
Linked e-resources
Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks
Details
Title
Expert T-SQL window functions in SQL server [electronic resource] / Kathi Kellenberger with Clayton Groom.
Author
Kellenberger, Kathi, author.
ISBN
9781484211038 electronic book
1484211030 electronic book
9781484211045
1484211030 electronic book
9781484211045
Published
[Berkeley, CA] : Apress, [2015]
Language
English
Description
1 online resource : illustrations.
Item Number
10.1007/978-1-4842-1103-8 doi
Call Number
QA76.73.S67 K45 2015eb
Dewey Decimal Classification
005.75/6
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.
Note
Includes index.
Access Note
Access limited to authorized users.
Added Author
Groom, Clayton, author.
Series
Expert's voice in SQL server.
Available in Other Form
Print version: 9781484211045
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
All Resources