I was having a conversation today with one of my clients about TempDB data files and how to spread them out to alleviate contention on SGMA pages, I came across a great article by Sunil Agarwal which I’d like to share. http://blogs.msdn.com/b/sql... ......