Interesting discussion. I prefer not to tibble anything but after reading all the entries, I can see how it might be a good idea to tibble view names and index...

Hi -

I don't know if this will help or not, but it's something I've seen in the past. Is your tempdb configured differently between production and test? ...

Never mind - I found it too.

In case someone else comes here and looks for an answer, if you don't have your SQL Server set up to start...

Hi there -

I have a similar problem - someone set our initial tempdb size to 16GB. I'm trying to follow the instructions given to stop SQL Server, start with...