NY Metro SQL Server Users Group Meeting Tonight
Traversing Hierarchies in SQL Server 2000 and SQL Server 2005
This presentation will compare and contrast the techniques of using stored procedures, user-defined functions and the new Common Table Expression in SQL Server 2005 to traverse a hierarchy with an unknown number of levels. Participants will learn how to use these features and how to compare the performance and general usability of the different approaches.
Speaker: Sharon F. Dooley
Sharon has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning, though she also does a lot of administration. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Manager. Ms. Dooley is the author of SQL Server 7.0 Essential Reference (New Riders), the lead author of Professional SQL Server 6.5 Administration (Wrox) and is a contributing author for the forthcoming SQL Server 2005 Bible. Sharon is an active member of PASS (The Professional Organization for SQL Server) and has presented at numerous conferences. She was named a Microsoft MVP in 2001 and was an MVP for SQL Server until 2004. In her spare time, she enjoys being bossed around by her three cats
If you want to attend please contact: Joe Lax or Linchi Shea, hope to see you there tonight!