DBCC
DataBase Console Commands
NOTE: SHRINKFILE and SHRINKDATABASE will almost certainly cause fragmentation. As a general rule do not use them. The only exception may be TEMPDB.
Bibliography
Bibliography
https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/database-console-commandshttps://www.brentozar.com/blitz/whos-been-running-dbcc-commands/https://www.brentozar.com/archive/2016/02/when-shrinking-tempdb-just-wont-shrink/ https://www.brentozar.com/archive/2017/12/whats-bad-shrinking-databases-dbcc-shrinkdatabase/ https://dba.stackexchange.com/questions/53857/i-need-to-shrink-my-database-i-just-freed-a-lot-of-space
Deprecatedhttps://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-dbreindex-transact-sql (DBCC DBREINDEX)