Well right, which is why I'm trying to find a middle gorund. Right now, if it doesn't have WITH RECOMPILE, the execution plan eventually doesn't cover a situation and pegs the database at 100%. But if ...