Index creation operation will use %1!s! KB of memory specified in the advanced sp_configure option "min memory per query ...