March 2008 - Posts

• 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 Read More... Posted Tuesday, March 18, 2008 4:25 PM by mssqlisv | 0 Comments

• 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 Read More... Posted Tuesday, March 18, 2008 3:49 PM by mssqlisv | 1 Comments

• 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 Read More... Posted Thursday, March 06, 2008 11:33 AM by mssqlisv | 0 Comments