Try Creating a database with a large filesize. e.g. 8gb or more and see how long it takes with instant initialization and with out

Awesome post. Been using the feature ever since I learnt from Kim Tripp (> 4years)

A little bit of explanation around why log files are not zero initialized would...

When you have context connection=true, it can only perform operations on databases within the same instance

You cant use time variant, affecting commands in functions

The assumption that files coming in are of fixed length is little hard to generalize.

In that case the Configuration table values are hard to determine.

Great work in getting it up...

We have page file as 32gigs as opposed to 16gigs of memory

Hope it doesn't do any harm

We have twice as much of Memory allocated as pagefile.

Is there a threshold or related impact on having such a setup?

Its noteworthy to know that DMV's are a reflection of historical query data since SQL Server started.

If you try running it right after restart, the results could be disastrous

sysdepends is going to be deprecated in future releases.

While it runs perfectly on older editions, do not get addicted to it

The facet thing works only on SQL 2008.

If you were to run it in SQL2005, you'll have to use runas along with other parameters

Its not necessary to install SQL 2008 R2.

Just the client tools from Nov CTP of SQL 2008 R2 will do

The Jan Bill is going to be a informational Statement (Warning)

Feb 2010 onwards it will be actually billed

There was a video by Popular SQL Server Security MVP Brian Kelly.

Visit sqlshare and lookup video by the above author or the link below

http://www.sqlshare.com/how-to-recover-from-being-locked-out-of-a-sql-server-2005-database_578.aspx

Go to Tools->References->

Check the latest version of Microsoft ActiveX Data Objects and say OK.

Now Hit Debug->Compile VBA Project. It shouldn't give you any...

Try creating reports in SSRS using 4Part names (ServerName.DatabaseName.SchemaName.TableorViewName)