😛

Congrats on the award. I intend to take the app for a...

Oh, I'm sorry. I'll play dumb next thread... 😉

11pm Seattle time and I'm checking the forums. still...

A senior DBA who...

The transaction log is not there for auditing purposes. If you're wanting to audit data changes, look at triggers. DML triggers to capture data changes, DDL triggers to capture schema...

I don't have time right now to try and rewrite your entirequery, especially not without table schemas or sample data. Look at the sample update statement I posted above and...

Yeah, but at least those are...

does that login have a mapped user in that database/

The different settings may cause problems. Make the settings in management studio the same as in the app and see what behaviour you get.

Don't have time to rewrite it now.

Can you try moving the subquery with the sum into the from clause and treating it as a derived table? I know it's not...

There are articles on my blog on parameter sniffing.

Were all the parameter values the same? All the options (ansi_nulls, etc) the same?

Don't shrink. Even with the notruncate, you will badly fragment your indexes. There's little gain in moving the free space to the end of the file.

There will be no change...

Parameter sniffing?

Did you run the proc from management studio, or did you run the contents?

Can you post the proc?

Anything in the event log? Anything in the error log?

Right. Now we can talk about this.

Consider moving the subqueries into the from clause of the update. I can't rewrite the entire things now, I'm in a presentation.

So, the general...

Can you post the exec plan please?

There are places where this does happen and isn't a problem. The estimated rows is the estimated rows affected per execution of the operator...