Home Forums SQL Server 7,2000 Performance Tuning Sql Server Performance RE: Sql Server Performance
Abhishek Chaturvedi
SSC Eights!
Points: 970
More actions
January 23, 2012 at 11:07 am
#1437250
If you are doing a lot of Temp table operations. You can improve performance by moving the TempDB files to a different drive and Create multiple files as oppose to one.
This is not a direct answer but it will help on a large scale.