Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
indersshekhawat
Starting Member
26 Posts |
 Posted - 2008-03-31 : 00:54:33
|
| what is the use of tempdb database. should it require on different location |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-31 : 01:37:14
|
| The tempdb is defined as a universal resource accessible by users of a given instance. Such objects as temporary tables , temp tables when recordsets are being sorted etc , are kep in there.It is recommended that you place the tempdb on a fast I/O disk, preferably separate from the data and ldf files. Chek "tempdb performance " in SQL Books OnlineJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 09:36:45
|
| Here is the article i like:http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html |
|
|
|
|
|
|
what is the use of tempdb