10/4/2006 4:47:36 PM
SQL2005 introduces the OVER clause to T-SQL, and with it, ranking functions and windowing. Ranking functions, particularly the row_number() function, give database developers a lot more flexibility to solve many problems. And the windowing features of the OVER clause not only allow new solutions to old problems, but can allow a much higher level of query-optimisation than before. In this session, some of the uses of this new functionality will be explored - demonstrating some of the ways in which problems can be solved more easily and efficiently.
Rob Farley runs the Adelaide SQL Server User Group. He has been using databases extensively since leaving university in 1997, but considers himself more of a database developer than a database administrator. He holds various Microsoft certifications, and has recently sat way too many beta exams. You can read his blog at http://robfarley.blogspot.com. He has been awarded the Microsoft MVP award for SQL Server.
Venue: SA Innovation Centre, L2 Santos House |
Duration 12:00-14:00 |
On: Thursday, October 12, 2006