Thomas Keller (7/11/2014)
4 stars! You should mention how to confirm that it took effect, by looking at the errorlog after creating a database, to see if it no longer says "Zeroing completed". There is a script to check for this, using sp_readerrorlog, at: http://sqlblog.com/blogs/tibor_karaszi/archive/2013/10/30/check-for-instant-file-initialization.aspxNote it also requires trace flags 3004 and 3605 to make that information actually show up in the errorlog, see: http://www.rdx.com/Blog/dba_tips/2011/03/undocumented-trace-flags-inside-the-restore-process/[/url]
Thanks for your valuable comments Thomas. When writing this article, I initially thought to provide this information in the article, however I skipped that later for the simplicity of article.
My idea was that after reading the article people will be curious about IFI & they will find out about these undocumented DBCC commands very soon.