No, my point was to make sure it wasn't set ON by accident. 🙂

I will compare that on my system with 2 other methods of doing numbers and report back. Is that the only method you tried? Sounded like you had at...

Can you post EXACTLY what you are using for your various tests?

I don't see how we can be of any help without knowing what your auditing requirements actually are. That has to be what drives your decision tree, right?

My experience is that it is almost always better to just add this to an existing index (assuming said index isn't already a hugely-bloated DTA-created mess).

Review books online and online sources for NOT FOR REPLICATION.

Security of this type is in the eye of the beholder I think.

Personally, I would pay the cost and get Red-Gate's SQL Backup and be done with it. 🙂

briantallon (1/14/2015)

---

New to using VMs for SQL. We have SQL 2012 SE. Our main apps are AX 2012 and SP. I'm seeing some IO pressure on...

Start here: http://msdn.microsoft.com/en-us/library/hh510208.aspx

1) it really helps us help you if you provide create table script with sample data and expected output.

2) you can do this with CASE pretty straight-forwardly, and it would...

Very difficult for me to follow precisely without some sample data and expected results to work with, but have you tried EXISTS and/or NOT EXISTS?? Sounds like one or...

ndfs are just additional files.

ALWAYS have EQUAL SIZED AND GROWTH FACTOR tempdb files, no matter how many you have.

So you believe that adding a timestamp and non-clustered index to a table is more likely to break production than adding a trigger than inserts into an audit table? Yes,...

Eric M Russell (1/12/2015)

---

bantrim (1/12/2015)

---

I'm going to have to show my colleague yours and Kevin's posts since, to her, triggers are four-letter-words. We've gone back and forth since we...

bantrim (1/12/2015)

---

Jeff Moden (1/11/2015)

---

I can't speak for Kevin but I roll my own, as well. Two different types but both use carefully created, hardcoded triggers. Notice that I...