Practical Table Partitioning
Be sure to come and hear Ron Talmage, contributing author to: Inside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimization, and, Visual FoxPro 6 Enterprise Edition.
Ron will be discussing data partitioning, introduced with SQL Server 2005. Data partitioning allows more efficient quering of data stores that contain archival or historical data.
Arnie Rowland, SQL Server MVP:
Using OUTPUT Can Solve Many Problems
Arnie will present several insightful ways to use the OUTPUT clause of SQL query statements that was introduced in SQL 2005. If you ever need to insert data into two (2) tables with one statement, or delete from one table while inserting into a second, you must see this presentation.