The "index create memory" option in sp_configure advance server settings, controls the maximum amount of memory initially allocated for creating indexes. This tip deals with common issues around this setting.  Read more...