While working on a problem today I happened to think about what the impact to startup might be for a really large tempdb transaction log file.  Its fairly common knowledge that data files in SQL Server 2005+ on Windows Server 2003+ can be instant initialized, but the transaction log files can not.  If this is news to you see the ...

Its funny to see this new technical note posted by the SQLCAT team today because we just recently had a discussion about this on Twitter.  My good friend Sankar Reddy (Blog/Twitter) sent me an IM with the link to this page based on the twitter discussions.  Essentially, the problem deals with inserts into a table with a identity column ...