Default image

Ernie

How To Shrink TempDB Without Restarting SQL Server

–DBCC DROPCLEANBUFFERS/*Clears the clean buffers. This will flush cached indexes and data pages. You may want to run a CHECKPOINT command first, in order to flush everything to disk.*/CHECKPOINT;GODBCC DROPCLEANBUFFERS;GO –DBCC FREEPROCCACHE/*Clears the procedure cache, which may free up some…