28/09/2005 6:54:10 AM
Row numbers are numbers calculated for rows in the result set of a query, based on a given order. Row numbers have numerous practical applications like paging, ranking and many others. This session will cover different techniques to calculate row numbers in SQL Server 2000, some slow, some fast, some guaranteed to work correctly and some not. This session will also cover the ROW_NUMBER() function introduced in SQL Server 2005, and several of its practical applications.
Itzik Ben-Gan is one of the founders of Solid Quality Learning http://www.SolidQualityLearning.com.au. A SQL Server MVP since 1999, Itzik has delivered dozens of training events across the US and Europe focused on T-SQL Programming, Performance Tuning and Internals, Administration, Implementation, Data Warehousing and OLAP. An accomplished author, Itzik has written many articles for SQL Server Magazine as well as articles and whitepapers for MSDN and co-authored the book Advanced Transact-SQL for SQL Server 2000 (APress). In 1999 Itzik founded the Israeli SQL Server and OLAP Users Group and has been managing it since. Itzik makes his home outside Tel-Aviv with his wife Lilach.
Venue: Melbourne Microsoft Office - Level 9 Como Office Tower, 644 Chapel Street, South Yarra, Melbourne |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 8:00 pm finish |
On: Tuesday, 18 October 2005