March 2008 - Posts

• TempDB:: Table variable vs local temporary table

  As you know the tempdb is used by user applications and SQL Server alike to store transient results needed to process the workload. The objects created by users and user applications are called ‘user objects’ while the objects created by SQL Server engine Read More... Posted Sunday, March 30, 2008 9:56 PM by Sunil Agarwal | 8 Comments Filed under: TempDB

• Overhead of Row Versioning

  Last week I was teaching a class on snapshot isolation and we discussed the overheads of snapshot isolation. There are three main overheads that you need to be aware of when you enable snapshot isolation read-committed-snapshot on a database. First, each Read More... Posted Sunday, March 30, 2008 12:41 AM by Sunil Agarwal | 10 Comments Filed under: Concurrency

• CHECKSUM and Tempdb

  You may recall that starting with SQL Server 2005, you have an option available to enable CHECKSUM on the user databases. For details, please refer to http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/29/Enabling-CHECKSUM-in-SQL2005.aspx . Read More... Posted Sunday, March 23, 2008 10:52 PM by Sunil Agarwal | 1 Comments Filed under: TempDB, General

• Minimal Logging changes in SQL Server 2008 (part-3)

  So far we had discussed ( http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/23/minimal-logging-changes-in-sql-server-2008-part-2.aspx ) how minimal logging changes impact when you are moving data from one table to another table. Now let us Read More... Posted Sunday, March 23, 2008 10:08 PM by Sunil Agarwal | 4 Comments Filed under: Bulk Import/Export

• Minimal Logging changes in SQL Server 2008 (part-2)

  In the previous example http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/06/minimal-logging-changes-in-sql-server-2008-part-1.aspx , I described minimal logging while moving data from a source table into a heap. You may recall that it requires Read More... Posted Sunday, March 23, 2008 7:54 PM by Sunil Agarwal | 5 Comments Filed under: Bulk Import/Export

• Minimal Logging changes in SQL Server 2008

  Please refer to the earlier post for the background information on minimal logging. Starting with SQL Server 2008, the minimal logging has been enhanced. These enhancements are available to regular TSQL Insert as well. One of the key customer scenario Read More... Posted Thursday, March 06, 2008 5:12 AM by Sunil Agarwal | 6 Comments Filed under: Bulk Import/Export

• FILESTREAM Configuration and Setup Changes in SQL Server 2008 February CTP

  FILESTREAM is disabled by default in SQL2008. Before you can start to use FILESTREAM, you must enable FILESTREAM on the instance of the SQL Server Database Engine. Enabling/configuring FILESTREAM is a bit different from configuring other SQL features Read More... Posted Monday, March 03, 2008 5:14 PM by OmelJ - MSFT | 6 Comments Filed under: SQL Server 2008, TechEd 2008, FILESTREAM

• Example: Index fragmentation with insert/updates, measuring it and fixing it

  This blog shows a very simple example to illustrate data fragmentation, measuring it, seeing behind the scene data and steps to address it. I recommend reading the overall series on index fragementation at http://blogs.msdn.com/sqlserverstorageengine/archive/tags/Index+Fragmentation+Series/default.aspx Read More... Posted Saturday, March 01, 2008 1:11 AM by Sunil Agarwal | 1 Comments Filed under: Index Fragmentation Series