SQL Compare to create indexes using WITH (ONLINE = ON)
When creating indexes on large tables, it would be very beneficial to include the "WITH (ONLINE = ON)" in the create statement for the index to prevent table locking. This will need to be optional because not all server versions support it.
1
vote
![](https://secure.gravatar.com/avatar/e285ff28248e63574136fe89acbacdc9?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)