John Rowan (7/9/2008)

---

The query optimizer is 'smart' enough to create the execution plan for a query based off of the actual data within a parameter. It can use the...

Yep. Parameter Sniffing was it i guess. I executed it "with Recompile" and it finished right away. Great. Thank you. I will create these with Recompile option...

Parameter Sniffing? I'll google it. In the meantime Here is my stored proc. It is very basic. Thanks for the help.

ALTER PROCEDURE [dbo].[usp_DeleteIlvsLmgrBatch]

@LmgrBatchId int,

@InsUser...

It is opposite of mine usually too. There are no other major tasks running. Sql Server takes 50% CPU when the proc is running. As soon as i kill...

Thank you Andy. Nice article. Short and sweet. Looking forward to the rest of them.