Thank you!!! for this post, it just got us out of a jam with the server falling over because tempdb on C drive was eating up all available disk space...
@steve-2: Thank you for sharing this knowledge and instigating a great dialogue. I have dived into perf tuning and trying to swim much deeper than I've been given...