Learning Curve…

New Features in SQL Server 2008

Posted on: November 3, 2011

1. Date and Time Data in SQL Server 2008 (ADO.NET)

SQL Server 2008 introduces the following date and time data types.

  • date
  • time
  • datetime2
  • datetimeoffset

These new data types support a greater range of date and time values as well as time zone awareness. 

2. FILESTREAM Data in SQL Server 2008 (ADO.NET)

SQL Server 2008 introduces the FILESTREAM storage attribute for binary data stored in a varbinary(max) column. This allows you to store the data on the local NTFS file system instead of in the database file. 

3. Table-Valued Parameters in SQL Server 2008 (ADO.NET)

Table-valued parameters are a new parameter type in SQL Server 2008 that gives you the ability to encapsulate rows of data in a client application and send it to the server in a single parameterized command. The incoming data rows are stored in a table variable that can then be operated on by using Transact-SQL. 

4. Large UDTs in SQL Server 2008 (ADO.NET)

In SQL Server 2005, UDTs were restricted to a maximum size of 8 kilobytes. This restriction has been removed for UDTs that have a format of UserDefined. 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Learning days (Calendar)

November 2011
« Oct   Dec »

Knowledge Bank (Archives)

I am on Twitter

Blog Stats

  • 532,897 hits

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 43 other followers

%d bloggers like this: