Tuesday, 28 March 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Special Sydney Meeting - Discover the Power of Row Numbers (Itzik Ben-Gan)
Author: Rowan Burke Date Posted: 30/09/2005 3:57:57 PM
Please note this will be in addition to the regular user group meeting on the 25th of October.

-------------------------------------------------------------------------------------------------

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.

Presentation and TSQL code can be found here
http://www.sqlserver.com.au/Resources/DownloadFile.aspx?resourceId=48

Venue: Cliftons (Level 2, 190 George Street, Sydney) | Duration 5:30PM Pizza - Session 6PM until 8PM | On: Tuesday, 11 October 2005