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 ...

Ever feel like the guy in the Bing Search Overload commercials?  You are not alone.  It’s happened a couple of times recently that someone has been looking for something online and couldn’t find what they were looking for and in a few quick searches I have been able to locate the information.  Now I don’t profess to be the master ...