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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)