I was just going to ask about tweaks (as in this current form it is really slow and the database is in Full Recovery mode, so I do not want...

Lynn Pettis (8/15/2012)

---

SQL_ME_RICH (8/15/2012)

---

Lynn - thank you again! So - based on what you have constructed, it looks like if my PROD db is a db called 'AutoDispatch' and...

Michael - great question, and not one that I hadn't thought of, but the place I am working at is not looking at best practices because in all honesty -...

Sorry - I was desparate for some help

:w00t:

Lynn - thank you again! So - based on what you have constructed, it looks like if my PROD db is a db called 'AutoDispatch' and my ARCH db...

Hi Lynn - thank you so much for your fast reply!

No - the tables are different in that the one in PROD has a PKey/Clustered Index on the leading column,...

Anyone have any ideas or thoughts on this?

P.S. Here is the table in the target database (where the records will eventually be copied to...The only difference between this table, and the table in the main database...

patrickmcginnis59 (8/3/2012)

I'm one of those who might create a denormalized database for performance, especially in the case of a web application. In these cases, performance could itself be a design...

I guess this all goes in part of being a newbie, and those who are stubborn enough to not care about appropriate database development and technique.

I guess the part of...

I really do appreciate you all sounding off here. It really rattled me earlier this year when I was told that the place I worked at didn't like the...

OK...I had seen this ad-hoc query in the mix of things in past deadlocks, but couldn't tell that it was the victim until now.

Thank you so very much for pointing...

Sorry about that - here ya go...

Deadlock Graph...

Ooooooooooooooooooooooooooooo Lynn! That's dangerously close to an INSERT!

:w00t:

hehe