• Home
    • Articles
    • Bookmarks
    • Apps
    • IP Address Lookup
    • Whois Lookup
    • DNS Lookup
    • Password Generator
    • Crontab Generator
    • DKIM Key Splitter
    • Contact Us



Data Sync App for Linux

    • Home
    • Articles
    • Bookmarks
    • Apps
    • IP Address Lookup
    • Whois Lookup
    • DNS Lookup
    • Password Generator
    • Crontab Generator
    • DKIM Key Splitter
    • Contact Us

Earn Bitcoins while you Chat

How to shrink the TempDB database without stopping MS SQL

Here's how:

DBCC FREEPROCCACHE

GO

DBCC DROPCLEANBUFFERS

GO

DBCC FREESYSTEMCACHE ('ALL')

GO

DBCC FREESESSIONCACHE

GO

DBCC SHRINKFILE (TEMPDEV,1024)

GO

Taken from : http://calyansql.blogspot.ca/2012/04/shrink-tempdb-data-file-without-sql.html

Quick Links

Articles

Bookmarks

Apps

Contact Us

Share & Spread


 ezref.info 2025