MyDoggieJessie (12/6/2014)
Thanks guys, I wasn't aware of these trace flags. I read the article and do have some concerns that Trace flag 1117 will cause all files to grow equally (not just limited to TempDB), but that's something I can bring back to the table and discuss with the DBA group.FWIW - I completely agree that what I was doing was only adding more unnecessary complexity to a problem that could be avoided, but was trying to find a way to accomplish what I was being asked to do.
Much appreciate the feedback and wisdom.
You're a wise man for being concerned but read this. You concerns will vanish...
http://www.sqlskills.com/blogs/paul/misconceptions-around-tf-1118/[/url]
--Jeff Moden
Change is inevitable... Change for the better is not.