Zero Initialization: In SQL Server 2005, it is no longer required to zero initialize the database. In SQL Server 2000 there is a wait time while the SQL Server received the physical space from the NTFS driver and then zero all of the sectors to create a blank database. SQL 2005 can create databases without zeroing out all of the data sectors. This makes database creation much faster, but potentially more risky if there is a need for data recovery.
3rd Party (Microsoft) design enhancement
Yes, when using LiteSpeed Version 4.6 with a SQL Server 2005 server, this feature is used and the VDI Timeout messages are no longer written in the LiteSpeed verbose log while the space is being allocated.
The latest version of LiteSpeed for SQL Server may be downloaded at: http://support.quest.com/support_download/Downloads.asp.
