J Livingston SQL (5/8/2016)

---

Rod did you run the test script I posted?

1 Million row table

-- update 6 columns on 100 000 rows

--run 10 iterations of update with trigger on

--then disable...

Oh OK, thank you, Jeff.

Spiff (5/6/2016)

---

SSRS caches report data as a .DATA file in the solution folder.

Either run the report again and click the little "Refresh" icon - this should force SSRS to rerun...

pietlinden (5/5/2016)

---

What happens when you run the stored procedure inside SMS, not SSRS? Is there a chance that you're connecting to a different server that has a different copy...

Jeff Moden (5/5/2016)

---

Wayne West (5/5/2016)

---

Good points. My biggest table has 66 columns (all the other active tables have a very small column count), but even when I was inserting...

:unsure:

Its been over a week, I believe, since I created this thread. I want to thank you all for your feedback. I still don't have the requirements, as some of...

jeff.mason (5/2/2016)

---

Oh, you don't want to do that, especially in a system with MARS involved. That would cause multiple recordsets potentially. You probably want to make a log table...

Eirikur Eiriksson (5/2/2016)

---

Rod at work (5/2/2016)

---

The subject line says it all. I'm testing something in an UPDATE trigger. Basically, I'd like to do a printf() type of thing. I created...

That's OK Jeff, you got to do your job first, I understand.

Jeff, your reply was very interesting. I'm saving that for when I have a discussion with my boss about this. I am especially interested in the statistics you gave for...

TheSQLGuru (4/27/2016)

---

I have come across a few clients over the years that had built their own "column-based" auditing. In every case the overhead of such systems (regardless of how they...

Jeff Moden (4/26/2016)

---

Rod at work (4/26/2016)

---

We've got an unusual request, and I think my managers are approaching this from a programming POV rather than a database POV. Here's how it...

I prefer being a generalist. I enjoy knowing as much as I can about as many different things as I can.

Thank you, rose and Jacob.