Spatial Data Types (GEOMETRY and GEOGRAPHY) in SQL Server 2008

Spatial Data Types (GEOMETRY and GEOGRAPHY) in SQL Server 2008 SQL Server 2008 provides support for geographical data through the inclusion of new spatial data types, which you can use to store and manipulate location-based information. These native data types come in the form of two new data types viz. GEOGRAPHY and GEOMETRY. These two…


FILESTREAM Data Type in SQL Server 2008

FILESTREAM Data Type in SQL Server 2008 The new SQL Server 2008 FILESTREAM data type enables SQL Server applications to store unstructured data, such as documents and images, on the file system with a pointer to the data in the database. This enables client applications to leverage the rich NTFS streaming APIs and performance of…


Large User Defined Types in SQL Server 2008

Large User Defined Types in SQL Server 2008 With SQL Server 2005, Microsoft integrated the .NET Common-Language Runtime (CLR) into the database engine itself, with that now you were allowed to create used defined type (UDT) and use it in SQL Server in a similar way as you use any in-built data type once assembly…


HIERARCHYID Data Type in SQL Server 2008

HIERARCHYID Data Type in SQL Server 2008 SQL Server 2008 has introduced a new data type HIERARCHYID to store hierarchical data in database table. HIERARCHYID is a variable length system data type, and used to locate the position in the hierarchy of the element. The HIERARCHYID data type is optimized for representing trees, which are…


New Date and Time Data Types in SQL Server 2008

New Date and Time Data Types in SQL Server 2008   SQL Server 2008 introduces four new DATETIME data types which are more optimized for type of usage and memory requirement, along with DATATIME2 which is now SQL compliant and compatible with .Net type DATETIME. To learn more about it and how it works click…


User-Defined Table Type and Table Valued Parameter (TVP) in SQL Server 2008

User-Defined Table Type and Table Valued Parameter (TVP) in SQL Server 2008   With SQL Server 2008, you can create a user-defined table type which represents the definition of a table structure. To ensure that the data in a user-defined table type meets specific requirements, you can also create unique constraints and primary keys on…


SQL Server 2008 : T-SQL Enhancements

SQL Server 2008 has come up with different compelling new features. One of them is T-SQL Enhancements which increase the productivity of developers by reducing overall development time and also improves the performance of SQL Server.I have written an article covering few of the T-SQL Enhancements, for example· Intellisense Enhancements· Syntax Enhancements· Object Dependencies Enhancements·…