use tempdb
\nGO<\/p>\n
DBCC FREEPROCCACHE — clean cache
\nDBCC DROPCLEANBUFFERS — clean buffers
\nDBCC FREESYSTEMCACHE (‘ALL’) — clean system cache
\nDBCC FREESESSIONCACHE — clean session cache
\nDBCC SHRINKDATABASE(tempdb, 10); — shrink tempdb
\ndbcc shrinkfile (‘tempdev’) — shrink db file
\ndbcc shrinkfile (‘templog’) — shrink log file
\nGO<\/p>\n
— report the new file sizes
\nSELECT name, size
\nFROM sys.master_files
\nWHERE database_id = DB_ID(N’tempdb’);
\nGO<\/p>\n","protected":false},"excerpt":{"rendered":"
use tempdb GO DBCC FREEPROCCACHE — clean cache DBCC DROPCLEANBUFFERS — clean buffers DBCC FREESYSTEMCACHE (‘ALL’) — clean system cache DBCC FREESESSIONCACHE — clean session cache DBCC SHRINKDATABASE(tempdb, 10); — shrink tempdb dbcc shrinkfile (‘tempdev’) — shrink db file dbcc shrinkfile (‘templog’) — shrink log file GO — report the new file sizes SELECT name, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts\/2002"}],"collection":[{"href":"https:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2002"}],"version-history":[{"count":0,"href":"https:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts\/2002\/revisions"}],"wp:attachment":[{"href":"https:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}