Rather than testing your code on 300 million rows, here's some code that generates a million rows of test data. This particular code also has what I call a...

Harveysburger (3/27/2008)

---

BAM! Jeff has spoken

gotta say although it's not the most popular answer your arguments are strong

thanks for the input, I will meditate on that for a while and see...

John Rowan (3/27/2008)

---

Wow, that was great Jeff...thanks. I'll have to admit, I've been just watching this thread waiting for a solid explanation of the benefits of any of the...

erdem (2/28/2008)

---

Hello Again,

How can I prevent duplicate values on a row without using Primary keys?

For example you can easily see that Sales price2 and sales price3 are same.How can I...

Madhu... a little feedback on what you end up doing would be much appreciated.

Glad you got it resolved... what did you do?

Sergei Zarembo (3/26/2008)

---

Jeff,

i agree in this simple replace it would be an overkill. But replace pattern can change by the minute. Wouldn't it be more convenient to have one [or...

Heh... no, you're right, Matt. I was just anticipating the next possible question (I should probably get out of the habit) which usually turns up as either "How would...

The popular answer on this and many of the other threads is scenario 3 and some for scenario 2. Just my humble opinion, but I think they might all...

Todd Engen (3/26/2008)

---

Jeff,

Try changing "DROP" to "DELETE", or set a WHERE clause with EventClass = 47 for Object : Deleted events.

Opening the traces in Profiler will resolve the EventClass to...

See? Now, I get that... thanks, Wayne. Why couldn't someone say something like that instead of thinking that I was trying to give them an eWedgie? :P...

Yep... on the small stuff for sure.

Just a note, though... CPU time makes all the difference in the world to me... most of the 8 hour jobs at work that...

I think so... here's the command I'm...

Heh, yeaup... thought I'd let that one go 😛

To put it a bit differently than Matt... INSERT triggers fire only once per INSERT statement no matter if one row or thousands of rows are affected. Same is...