Bhuvnesh (12/20/2012)
OK thanks for explanation . can you please explain the phraseWe Added a Tempdb Data File, and Data Was Wrong
from http://www.brentozar.com/archive/2011/08/tempdb-multiplefiles-sort/
Why don't you read the blog post? It was explained in there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability