Triggers in SQL Server are fired once regardless of the number of rows inserted/updated/deleted. If the possibility exists, you need to code your triggers to handle multiple rows.

I'd start...

Having a DVR is great. It does allow me to watch my shows when I can get the TV.

Jack Corbett (7/21/2009)

---

I'm a little jealous. My wife isn't a big movie fan so we don't go, and I don't have NetFlix because it's just not the same if...

I have read the privacy statement and I don't see anything there that says that they sell their lists. They won't even send you thier own marketing emails if...

Not sure, but I think a paren may be missing. Could you also format your code so that it is easier to read. White space is your friend.

GSquared (7/21/2009)

---

Lynn Pettis (7/21/2009)

---

GSquared (7/21/2009)

---

... Made the mistake of buying season 1 and 2 of Battlestar Galactica. Should have rented those. That was before my Netflix...

Thank you for the feedback.

GSquared (7/21/2009)

---

... Made the mistake of buying season 1 and 2 of Battlestar Galactica. Should have rented those. That was before my Netflix addiction kicked in...

While your at it, please format the code so that it is easier to read as well. White space is a freind to the eyes.

Then I suggest you contact RedGate as specified in 2.2.

Personally, I've never received any emails from sites I didn't personally visit and request, including TechTarget.

Looks to me like someone (not necessarily you, Tara) followed the advice of DTA without reviewing what it suggested. That index just duplicates your table. If you need...

Well ., you are back in time to see The Thread break 7000....

Sounds like data growth to me. Possibly have page splits in some of your tables and indexes.

JohnSQLServerCentral (7/21/2009)

---

I'm getting a little overwhelmed with these unsolicited emails from techtargetlists.com. I repeatedly unsubscribed over the past few weeks, but it appears that you keep adding new lists...

Okay, help us help you. Read the first article I reference below in my signature block.

Provide us with the DDL for the tables, sample data for the tables, expected...