DBCC
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://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