This is the kitchen sink stored procedure - you want one procedure that handles all possible combinations of search criteria that a user might enter. It is literally impossible to make SQL Server derive a single execution plan that will be efficient for all of these combinations - I don't care wh...