Home Forums SQL Server 2012 SQL 2012 - General Create Clustered Index on a Very Large Table (500 GB) RE: Create Clustered Index on a Very Large Table (500 GB)

  • May 7, 2014 at 9:57 am

    #1711583

    1. Change SORT_IN_TEMPDB = OFF

    2. Remove MAXDOP or set it to high and run at at weekend.

    3. Consider partitioning such a huge table by date.