Bhuvnesh (11/20/2012)

---

Brian-444611 (11/15/2012)

---

but no seriously this advanced search thing has an endless number of parameters and generates 100+ line queries that are just ugly. it's like "lets do a 30 table view" situation

i think you also need to think to move tempdb files (i assume you have multiple) on different seperate disks.

see this http://blogs.msdn.com/b/sqlserverstorageengine/archive/2009/01/04/managing-tempdb-in-sql-server-tempdb-configuration.aspx