SQL Experts

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
Posted by Unknown at Friday, November 22, 2013
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

List of articles from Shiva Sagar

  • ►  2015 (27)
    • ►  December 2015 (3)
      • ►  03 Dec (3)
    • ►  April 2015 (16)
      • ►  21 Apr (1)
      • ►  17 Apr (1)
      • ►  16 Apr (6)
      • ►  15 Apr (1)
      • ►  10 Apr (4)
      • ►  05 Apr (1)
      • ►  01 Apr (2)
    • ►  March 2015 (7)
      • ►  30 Mar (1)
      • ►  07 Mar (4)
      • ►  06 Mar (2)
    • ►  February 2015 (1)
      • ►  09 Feb (1)
  • ►  2014 (3)
    • ►  January 2014 (3)
      • ►  20 Jan (1)
      • ►  03 Jan (1)
      • ►  02 Jan (1)
  • ▼  2013 (73)
    • ►  December 2013 (15)
      • ►  31 Dec (1)
      • ►  29 Dec (14)
    • ▼  November 2013 (1)
      • ▼  22 Nov (1)
        • TempDB Shrinking
    • ►  April 2013 (8)
      • ►  19 Apr (1)
      • ►  18 Apr (1)
      • ►  09 Apr (3)
      • ►  08 Apr (2)
      • ►  02 Apr (1)
    • ►  March 2013 (49)
      • ►  28 Mar (5)
      • ►  21 Mar (6)
      • ►  18 Mar (1)
      • ►  14 Mar (1)
      • ►  12 Mar (13)
      • ►  11 Mar (23)

About Shiva Sagar

Unknown
View my complete profile
My thoughts. Simple theme. Powered by Blogger.