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 |
|
tapaswani86
Starting Member
26 Posts |
 Posted - 2011-05-31 : 09:40:01
|
| Hi All,1)How to manage tempdb, if it will grow unexpectdly?2)what we will we do, if tempdb is full ?Thanks,Tapaswani |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-31 : 09:55:33
|
| 1) Write code so that it doesn't. Put a limit on it's size - usualy if something is using up a lot of tempdb space then it is using a lot of resources and slowing the server down - you want to stop it sooner than later so that the user tells you about an error rather than going home and forgetting about it.2) tempdb is rebuilt whenever the server restarts - so a restart should sort it out. Make sure it doesn't fill the disk and cause other problems though.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tapaswani86
Starting Member
26 Posts |
Posted - 2011-05-31 : 10:21:10
|
| Thanks,Tapaswani |
|
|
|
|
|
|
Temp db database grow