http://sqlblog.com/blogs/jonathan_kehayias/archive/tags/Did+You+Know/Internals/default.aspxTags: Did You Know, InternalsenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/05/14/does-tempdb-get-recreated-from-model-at-startup.aspxFri, 14 May 2010 10:32:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:25147Jonathan Kehayias3http://sqlblog.com/blogs/jonathan_kehayias/comments/25147.aspxhttp://sqlblog.com/blogs/jonathan_kehayias/commentrss.aspx?PostID=25147In my last post Does the tempdb Log file get Zero Initialized at Startup? I questioned whether or not tempdb is actually created from the model database or not at startup.&#160; There is actually an easy way to prove that this statement, at least internally...(<a href="http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/05/14/does-tempdb-get-recreated-from-model-at-startup.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=25147" width="1" height="1">Database AdministrationDid You KnowInternalshttp://sqlblog.com/blogs/jonathan_kehayias/archive/2010/05/13/does-the-tempdb-log-file-get-zero-initialized-at-startup.aspxFri, 14 May 2010 00:13:53 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:25137Jonathan Kehayias9http://sqlblog.com/blogs/jonathan_kehayias/comments/25137.aspxhttp://sqlblog.com/blogs/jonathan_kehayias/commentrss.aspx?PostID=25137While 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.&#160; Its fairly common knowledge that data files in SQL Server 2005+ on Windows Server 2003+ can be instant...(<a href="http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/05/13/does-the-tempdb-log-file-get-zero-initialized-at-startup.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=25137" width="1" height="1">Database AdministrationMiscellaneousDid You KnowInternals