I was testing one of our web applications one day and happened to see a simple Stored Procedure took over a minute to complete.  The Stored Procedure only takes one parameter.  If I get rid of the parameter and directly run the SQL statement inside the Stored Procedure, it took less than a second to [...]