MAXNOP8

SQL Server, SSIS, powershell

Friday, February 21, 2014

Shrink TempDb Without Restart

USE tempdb
GO
--sp_helpfile
DBCC FREEPROCCACHE
GO
DBCC DROPCLEANBUFFERS
go
DBCC FREESYSTEMCACHE ('ALL')
GO
DBCC FREESESSIONCACHE
GO
--second parameter is targe in percent
DBCC SHRINKDATABASE(tempdb,10)
Posted by Christophe at 2:28 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2016 (1)
    • ►  January (1)
  • ►  2015 (4)
    • ►  December (2)
    • ►  November (1)
    • ►  October (1)
  • ▼  2014 (8)
    • ►  August (3)
    • ►  July (1)
    • ►  May (1)
    • ►  March (1)
    • ▼  February (1)
      • Shrink TempDb Without Restart
    • ►  January (1)
  • ►  2013 (14)
    • ►  September (3)
    • ►  August (3)
    • ►  July (1)
    • ►  April (2)
    • ►  March (5)
  • ►  2012 (16)
    • ►  November (2)
    • ►  October (5)
    • ►  September (1)
    • ►  August (2)
    • ►  July (6)

About Me

Christophe
View my complete profile
Awesome Inc. theme. Powered by Blogger.