DEP011
Published 20 N 2017
DBCC INDEXDEFRAG is deprecated
DBCC INDEXDEFRAG is deprecated.
ALTER INDEX REORGANIZE can perform index defragmentation without taking the database offline, allowing users to access the tables being defragmented (enterprise edition only).