| Author |
Topic |
|
waterduck
Aged Yak Warrior
982 Posts |
 Posted - 2009-06-29 : 23:37:45
|
| as i know tempdb grow when some event occur like:- Sorting,- Unions, join,- leftover transaction,- temp table.I wish to know is there any hidden event that help grow tempdb... |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-06-29 : 23:48:36
|
| Server Error404 - File or directory not found.The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.FInish reading~ |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-06-29 : 23:55:49
|
| HUMAN ERRORTOO SLEEPY TO READ!THX Q KHTAN ^^ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-29 : 23:57:51
|
quote:
Originally posted by waterduck
HUMAN ERRORTOO SLEEPY TO READ!THX Q KHTAN ^^
Good reading material if you can't sleep at night. But then again it might keep you awake all night thinking about your tempdb 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-06-30 : 00:01:26
|
neh...my 'dai lou' call me to do research for it only  ps we call our boss or supervisor 'dai lou' in cantonis ^^ |
|
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-06-30 : 00:31:21
|
| Erm...ok now i understood that tempdb grow everytime many user logged in and used nasty select statement...is there anyway to shrink the tempdb to its original size without closing sql server 2005? |
|
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-06-30 : 01:27:33
|
| lolz, the forum full of info...thx for all hehe |
|
|
|
|
Tempdb Full!