What’s New in SQL Server 2008
Most of the new table-oriented features available with SQL Server 2008 are related to the columns that define a table. Columns can now be defined with several new data types that further expand the type of data that SQL Server can store and manage. Some of these new types, such as the FILESTREAM storage and the geometry and geography data types take SQL Server beyond the typical relational model. FILESTREAM storage provides a reference point to a flat file in the operating system where the data actually resides, and the geometry and geography data types bring you into the world of spatial data storage.
The hierarchyid data type is system-provided. You use hierarchyid as a data type to create tables with a hierarchical ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
