That computer that Tom Cruise uses in Minority Report. I could get so much stuff done with an interactive screen that size.

A little addition here. I was, obviously, having this problem as well. Here is an example of what my proc looked like:

CREATE PROC Reports.MyExampleProc

@StartDate DateTime,

@EndDate DateTime

AS

IF(@EndDate is null)...

Ditto here. I supplied a value to my optional parm and Wammo! Super fast. Why do optional parameters cause this slow down?