Configuration: Instant File Initialization

Usually when data file grows or when you create a new file for it or whatever else, SQL will have to zero out the disk that that file is added on or grown out to. It zeros, and that can be a really slow process depending on the size of the growth, and what else…

To access this incredible, amazing content, you gotta get Fundamentals of Database Administration or Recorded Class Season Pass, or log in if you already shelled out the cash.