You can add the new file on the D drive, you have allocation contention, not IO contention (unless there are additional problems you haven't mentioned.

If TempDB is growing to 1.5...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1424621-146-1.aspx

Are the lookups a problem?

Some details on index column ordering

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

They can be, but the resultant index will be less efficient for queries that filter on anything other than A, B than the individual indexes would have been.

Or switch them into a partioned archive table and maybe merge the partitions.

No idea whatsoever. Call MS support and open a case with them (yes, there is...

The entire point of partitioning is ease of archiving and easier maintenance. It's not a performance tuning technique.

What's the point of encrypting? Who are you trying to protect the data against?

Look at the SQL functions EncryptByKey and EncryptByCert

http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx

http://technet.microsoft.com/library/Cc966545

http://www.sqlskills.com/blogs/paul/category/tempdb/

If you need urgent help on a rather odd problem, open a case with Microsoft support.

We're all volunteers here, we post in our spare time.

700.

For the sake of playing around, I once...

What Lynn suggested right at the beginning.

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 3.