how to clear the tempdb

Question

Post reply

how to clear the tempdb

narayanan.mudam

SSC Veteran

Points: 238
More actions
September 21, 2012 at 6:53 am

#262034

hi all please clear the problem how to clear the tempdb

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113563 More actions · Answer 1

Quickest way is to restart the SQL service which will create a blank TempDB when it restarts.

What is the problem you are facing?

narayanan.mudam SSC Veteran Points: 238 More actions · Answer 2

I ATTENDED A INTERVIEW hoe to clear the tempdb if only one server is their and do not restart the server

Ant-Green SSC Guru Points: 113563 More actions · Answer 3

As this is for an interview question/answer, I recommend that you do the research and come back with potential answers to the question and then the great people here can hopefully point you in the right direction.

Abu Dina SSChampion Points: 14155 More actions · Answer 4

Google DBCC SHRINKFILE

---------------------------------------------------------

It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

Abu Dina (9/21/2012)
Google DBCC SHRINKFILE

And after you've done that, find the kb article that advises not to shrink TempDB and why.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 6

Objects in tempdb should clear when the connections drop or they are dropped by the connection that created them. There are some objects created by the system to satisfy queries, and they should disappear when the query/batch ends.