SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX

It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients.