• All of the changes are already default or pure textual, except for the fillfactor. And that is only used on creation of the constraint, the fillfactor won't be evaluated dynamically. Only on the fillfactor you need to decide what's the best here, depending if this table is update-intensive or not.

    In general, the first statement is slightly better if many updates are made in this table. As a result, you need more storage space for this option.

    Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2