index create memory Option
Use the index create memory option to control the amount of memory used by index creation sorts. The index create memory option is self-configuring and should work in most cases without requiring adjustment. However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value. Query sorts are controlled through the min memory per query option.
The default value for this option is 0 (self-configuring).
index create memory is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change index create memory only when show advanced options is set to 1. The setting takes effect immediately (without a server stop and restart).
To set the index create memory option
Transact-SQL