TemDev database For Improving Sort Speed 1

[rebelknight]

To get performance gains out of splitting the TempDev database to a seperate disc, do you have to specify the use of the temp database explicitly on a T-SQL statement after moving tempdev to another drive or will sql server know it should use it?

 

[mrdenny]

There is no way to tell a query to use the TempDB for sorting. SQL will automatically decide when to use TempDB.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[rebelknight]

Thanks for your help.