MSDN Webcast: New T-SQL and Engine Features, New Data Types for SQL Server Programmability (Level 200)
With Microsoft SQL Server Compact 3.5 and Visual Studio 2008, developers have an easy-to-deploy solution for local data. Ranging from caching reference data to full offline scenarios, developers can use a single engine for their Windows Mobile devices to their full desktop client computers, benefiting from the power of SQL Server. This webcast gives an overview of the major programmability enhancements in the SQL Server 2008 Database Engine. It covers the new data types, table-valued parameters, and other new capabilities, like the ability to define sparse columns and filtered indexes.