sql server services, sql server agent services, backup, restore, error, jobs, scripts,indexes,replication, log shipping, database mirroring, AlwaysON, clustering, DBCC commands, stored procedures, DMV's commands, basics and etc.
22 November 2013
TempDB Shrinking
Use Tempdb go DBCC FREEPROCCACHE GO DBCC DROPCLEANBUFFERS go DBCC FREESYSTEMCACHE ('ALL') GO DBCC FREESESSIONCACHE GO DBCC SHRINKFILE (N'tempdev' , 4) GO
No comments:
Post a Comment