Welcome to MSDN Blogs Sign in | Join | Help

March 2008 - Posts

Tuesday, March 18, 2008 4:25 PM

Using time zone data in SQL Server 2008

In SQL Server 2008 Microsoft has introduced a number of new date and time data types. One of these is the datetimeoffset data type. This data type includes an offset from UTC time as well as the datetime value and ensures that the datetime can be retrieved
Posted by mssqlisv | 5 Comments
Tuesday, March 18, 2008 3:49 PM

Increase your SQL Server performance by replacing cursors with set operations

You have probably heard many times, from different sources, that as a best practice; avoid using TSQL cursors. During a recent visit to a partner we ran into a common cursor case, which I wanted to use as an example to demonstrate why you should avoid
Posted by mssqlisv | 2 Comments
Thursday, March 06, 2008 11:33 AM

Appending Data Using SQL 2008 Filestream

SQL Server 2008 has a new feature called Filestream, which allows you to save large binary files in the file system, instead of in the database. This is targeted directly at the scenario that many document management and web applications have today where
Posted by mssqlisv | 1 Comments
 
Page view tracker