Jeff Moden (12/30/2016)

---

TheSQLGuru (12/30/2016)

---

Jeff: "Another potentially very serious problem with all of this is the idea that a lot of the rows will suffer a lot of updates. "

...

Jeff: "Another potentially very serious problem with all of this is the idea that a lot of the rows will suffer a lot of updates. "

That actually...

lmarkum (12/28/2016)

---

TheSQLGuru (12/28/2016)

---

Sorry to tell you this, but that code is just horrible.

1) Why is it passing in datetime values as varchars?? You simply MUST make ALL of those datetimes...

Indianrock (12/27/2016)

---

I was reading about these but wondered how they would help when 99% of your sql is ORM-generated? We're able to identify our problem queries, it's just...

Sorry to tell you this, but that code is just horrible.

1) Why is it passing in datetime values as varchars?? You simply MUST make ALL of those datetimes datatypes. Period.

2)...

I didn't dig into your code closely, but two things:

1) Auditing should always be three separate triggers IMHO. Each is then coded to do just what it needs to do....

To the OP: You state "does not cause much system load". I challenge you to actually do a benchmark to prove that assertion. You may be surprised by the results.

To...

I will add a suggestion that you always use 1/1/1753 07:00 as the basedate. That way there is no need to worry about which date is larger. 🙂

1) BLOCKING is a normal part of transactional processing in SQL Server. It is not something that can be avoided. LONG-TERM blocking is another issue, and is often the result...

Some of the versions of Visio can do ERDs by reverse engineering an existing database. I know they removed the functionality from some versions though so be sure to check...

sgmunson (12/21/2016)

---

whenriksen (12/21/2016)

---

Here you just scare...

The problem Joe is that your so-called "education" is both 30-years old (and thus missing out on new constructs) and MUCH WORSE totally FUBAR in many cases when it comes...

I have had good success at with ISVs and development groups convincing them they need a different/better mousetrap by showing them before and after versions of their code that is...

In addition to what Jeff said, you REALLY need to know your application's data and data access patterns to determine the optimal indexing strategy. There are certainly valid scenarios for...

Solomon Rutzky (12/15/2016)

---

And I just thought of another variation of what I proposed above, taking into account that the goal is to replace the offending card numbers and transaction IDs...