dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Apr 10, 2019

Resize Your TempDB in SQL

You can resize the tempdb temporary database in SQL by using the ALTER DATABASE command, as shown below:

ALTER DATABASE tempdb
MODIFY FILE (Name = tempdb_data, filesize = 100MB),
MODIFY FILE (NAME = tempdb_log , filesize = 20MB);

This resizes the data and log files of tempdb respectively.

Hannes du Preez
 
Thanks for your registration, follow us on our social networks to keep up-to-date