It may be operating off a bad cached plan... try the WITH RECOMPILE option in the stored procedure. It could also be "parameter sniffing"... lot's of articles available for...

Lynn Pettis (7/23/2008)

---

Does anybody have some code to build a table of strings from 1 to 10 characters in length, with no trailing or leading spaces (embedded spaces are allowed)...

That scenario (like many) audits the wrong thing... you should only Audit the DELETED table... the current value is always in the original table.

??? I'm not sure why you say that! We...

Now THAT sounds like a fun system to be on and that the DBA (you, Gail?) might...

Ross McMicken (7/23/2008)

---

The DBA's that specified the 50MB were of the opinion that aproperly designed application doesn't need more tempdb. I was glad I didn't have to deal with them....

Heh... I think about 99% of all CLR code is...

Heh... 50MB for a TempDB... we start our TempbDB up at 12 Gig!

OK... maybe I'm missing something, but why would you want to do that with a CLR? :blink:

That pretty much summarizes my feelings about certificates...

Those are done using the "code" IFCodes... when...

Sorry Gus, I have no idea what ORLY means...

Lot's of good stuff there Gus... I just don't think any of it needs to audit the original insert... 🙂

Thanks, Jack... must've been some latte in my coffee or sumthin':P

Heh... that's what I was getting at... none of the methods has a huge advantage over the other which means it all becomes a personal preference for readability and understanding.

On...