TheSQLGuru (1/12/2015)

---

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?...

If you had access to the transaction logs, then you could do log shipping replication. If you had an actual login account, then you could leverage SSIS.

Having to operate...

Steve Jones - SSC Editor (1/12/2015)

---

It is similar to a database, but the scale of data in most companies (overall), exceeds what a single RDBMS can handle. I'm not sure...

TheSQLGuru (1/12/2015)

---

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...

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 first met over...

bantrim (1/12/2015)

---

Eric M Russell (1/12/2015)

---

Using hash or checksum techniques to detect modifications to bulk numbers of records is inefficient (it has to read and hash all columns) and not reliable...

But how would any of this be a "poor man's" version of replication? Even SQL Server Standard Edition supports real replication, which may work better than anything you spend time...

Using hash or checksum techniques to detect modifications to bulk numbers of records is inefficient (it has to read and hash all columns) and not reliable (data changes but hash...

The "query governor cost limit" server option (and session override setting) has been around since at least v2000. You basically specify the maximum number of seconds, and then SQL Server...

It would be helpful if backup tools supported backing up and restoring server configurations (linked servers, maxdop, trace flags, etc.) Practically all SQL Server backup solutions are database centric. Maybe...

Occasionally automation means modifying the applications or developing a new table or stored procedure. But in my universe, Operations are part of IT and are capable of implementing their own...

There are probably a lot more multi-TB instances than there are multi-TB databases. I don't currently manage backups, but in our environment we have a 10 TB instance partitioned both...

Scott D. Jacobson (1/8/2015)

---

I for one would really like to know more about the reasons behind the outage. There was a Xen security advisory last September that caused huge ripples...

ScottPletcher (1/8/2015)

---

You could also GROUP directly on the CASE expression itself:

SELECT

CASE

WHEN message_text LIKE '%ThePartToGroupBy%' THEN '%ThePartToGroupBy%'

...

If it's not enterprise applications what are affected, then perhaps it's not that big of a deal. However, it does break my heart to think of all those millions of...