When troubleshooting performance problems with stored procedures, use with recompile to make sure that each of the stored procedures used during the test are recompiled, so that no plan from a previous compilation is used during the test.
