When creating a large database, we usually install the final size creation to reduce fragmentation, however, when initializing data and log files, it takes a lot of time to overwrite any existing data left by the previously deleted files on the disk.
However, SQL Server provides the instant file initialization function, which can be used to instantly initialize data files.
The instant file initialization function is only available after se_manage_volume_name is granted to the SQL Server (MSSQLServer) service account. Members of the Windows Administrator Group have this permission and can add other usersExecute Volume Maintenance TasksThis permission is granted to the security policy.
But you also need to consider some security factors, For details refer to the official Microsoft documentation: http://msdn.microsoft.com/zh-cn/library/ms175935 (SQL .105). aspx