SQL TEMP DB KÜÇÜLTME

USE [tempdb] 

GO 

CHECKPOINT; 

GO 

DBCC DROPCLEANBUFFERS; 

GO 

DBCC FREEPROCCACHE; 

GO 

DBCC FREESYSTEMCACHE ('ALL'); 

GO 

DBCC FREESESSIONCACHE; 

GO 

DBCC SHRINKFILE (N'tempdev',4) 

GO 

DBCC SHRINKFILE (N'temp2' , 4) 

GO 

DBCC SHRINKFILE (N'temp3' , 4) 

GO 

DBCC SHRINKFILE (N'temp4' , 4) 

GO 

DBCC SHRINKFILE (N'temp5' , 4) 

GO 

DBCC SHRINKFILE (N'temp6' , 4) 

GO 

DBCC SHRINKFILE (N'temp7' , 4) 

GO 

DBCC SHRINKFILE (N'temp8' , 4) 

GO