SQL Server

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

Answer Wiki

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

Here 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: 2  Replies

 
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
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,295 pointsBadges:
    report
  • bhannah
    "The tempdb system database is a global resource that is available to all users connected to the instance of SQL Server and is used to hold the following":  Quote from MSDN.  In most cases, when you open a database, you may not actually open the database, you open a copy of the database.  This is a temporary storage area to store all transactional data to the database, including adding and deleting records, querying the database and storage of said information, changing records, changing structure, and other information.  When you close your instance of the database, any changes that you may have made get written back to the actual database.  This is an over simplification of the process, but it does cover it.
    1,495 pointsBadges:
    report

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