Clearly, I am as well.

Well, I just popped off

http://www.sqlservercentral.com/Forums/Topic635918-149-1.aspx?Update=1

Evidently I'm only providing problems, not solutions.

foxjazz (1/14/2009)

---

Ok, instead of giving me problems, how about providing a solution.

These tables are not (data) are not changed frequently, and the data is cached on the clients software.

When the...

GilaMonster (1/14/2009)

---

If you're on SQL 2005, and I assume you are because this is the SQL 2005 forum, use traceflag 1222 rather than 1204. It produces a lot more output...

foxjazz (1/14/2009)

---

so the best way to do it is to set a trigger for afterupdate / afterinsert / afterdelete

populate another table with :

changedtablename, changeddate, changedvaluestring

Have my service process run...

Can you turn on TraceFlag 1204 and capture the deadlock graph that it will generate in the error log and post it? That's the best way to help.

The exact locks...

I'm not entirely sure what you're shooting for here either.

But, if I'm understanding you correctly, you're wondering how to use MAX in the WHERE clause.

You would do something like this...

To create a common table expression (CTE) the last statment prior to the CTE must be closed off with a semi-colon, in your case:

DECLARE @sumAllProducts INT...

After you work through the best practices, you can start here [/url]to work on performance.

I'm assuming you're referring to data changes in the table...

Triggers are probably going to be the simplest to implement. Keep it really simple and just set a flag somewhere that...

Just to take a slightly different approach, what is the clustered index on the table where the inserts are occurring? With a bit of tuning, probably including the CreateDt column...

ALZDBA hit the nail on the head. You're setting the variable as a CHAR(10) and the very first parameter, 'David Howard', has 12 characters. So it's going to truncate the...

Bob Hovious (1/13/2009)

---

HERESY!!! :w00t:

Everybody down South knows you should deep-fry those suckers and serve 'em with come-back sauce. (They'd go...

Seems a little extreme... two words, Guy Fawkes.

Steve Jones - Editor (1/13/2009)

---

Lend me a kilt and I'll put one one!!

Thanks for the note and I do appreciate the kind words. I'd wear the Gears of War shirt,...