October 22, 2009 at 7:58 pm
My temp db is 121,940,160 mb that is mdf .How can I make it smaller
October 22, 2009 at 8:30 pm
Use DBCC SHRINKDATABASE Command.
Follow the Link on Microsoft http://support.microsoft.com/kb/307487
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 22, 2009 at 9:05 pm
I ran the command to 10% limitation, do I need to re start sql server? I already see that file now is 32,000,000 MB.
I need to update 48 mil records, I am planning to update seletop top 2 million records and it joins to tables. Any suggestions?
October 22, 2009 at 9:21 pm
I ran the command to 10% limitation, do I need to re start sql server? I already see that file now is 32,000,000 MB.
I need to update 48 mil records, I am planning to update seletop top 2 million records and it joins to tables. Any suggestions?
Are you saying you have 32,000 (approx) Gigs of DataFile? Please check and confirm again.
Have you checked the TempDB File properties using the Shrink option in Enterprise Manager ? or connect from SSMS in SQL 2005 and look from it. it shows the Free Space available and also give you a choice of the least size you may want to shrink the Data/ Log File.
You can shrink to the least value that is shows and permits.
If your System is not in Production or you have enough maintenance time, you can restart SQL Instance and that would make the tempDB size to actual starting size.
Regd updating rows, I could not follow "update seletop top 2 million records and it joins to tables", please explain a bit more.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply