Add an option to the behavior section to include SORT_IN_TEMPDB = ON on all of the CREATE INDEX statements.
For those of us working with data warehouses, using SORTINTEMPDB is the default behavior we need.
9
votes
Anonymous
shared this idea
-
Mike
commented
This would be very helpful for not having to tweak the scripts when creating hundreds of indexes!