Yep - sounds like dynamic SQL is my best bet, I've got lots of optional parameters and lots of rows.

Maybe in the future, Microsoft will improve their optimization algorithms for...

Both methods (Using an OR, and Using the CASE block) FAIL to "Short Circuit".

In this simple example it doesn't matter, but in this nightmare query I've recently inherited, I've got...