IFI (7m)

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…