This content is not currently approved and is visible here for review only.

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
Authors
Itzik Ben-Gan
ISBN
0735658366
Published
22 Apr 2012
Purchase online
amazon.com

Perform efficient database queries with T-SQL window functionsGet a detailed look into the practical applications of window functions in Transact-SQL—the database programming language built into Microsoft SQL Server. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to perform calculations against sets of rows in your database—in a flexible, clear, and efficient manner. Delve into SQL windowing concepts and discover practical uses for various T-SQL window functions.Discover how to

Editorial Reviews

Perform efficient database queries with T-SQL window functions

Get a detailed look into the practical applications of window functions in Transact-SQL—the database programming language built into Microsoft SQL Server. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to perform calculations against sets of rows in your database—in a flexible, clear, and efficient manner. Delve into SQL windowing concepts and discover practical uses for various T-SQL window functions.

Discover how to:

  • Apply SQL windowing concepts and window function design
  • Gain experience with window aggregate, ranking, offset, and distribution functions
  • Know when to use SQL ordered set functions, such as hypothetical set functions and inverse distribution functions
  • Optimize window functions in SQL Server 2012
  • Use practical examples of T-SQL window functions to address common business tasks

You might also like...

Comments

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“I invented the term Object-Oriented, and I can tell you I did not have C++ in mind.” - Alan Kay