SQL Server

5 pts.
Tags:
SQL Server 2005
TempDBs
Visual Studio 2005
Windows XP
What is a tempDB in SQL Server?

Answer Wiki

Thanks. We'll let you know when a new response is added.

<a href=”http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx”>Here </a> is an excellent technet article that should give you all the information you are looking for.

———-

The basic summary of tempdb is that it’s used for temporary objects. Temp tables, table variables, when SQL Server needs to stage data into a database for sorting data, doing joins in a hash table, etc it’s all done within the tempdb database.

Each time the SQL Service is restarted the tempdb database is deleted and recreated as an empty database.
*****************************************************
TemDB in SQL Server is the area where all temporary information is stored. It consists of log files based on various transactions taking place in the database. Like MasterDB contains Master Database data, this contains temporary data. The log files need to be flushed on regular basis and don’t forget to Shrink TempDB to bring it back to actual size after flushing temp log files otherwise it will keep on utilizing the White Space.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following