1) No. The primary key and clustering key are not necessarily directly related. The clustering index is the single most critical factor for performance. And it should...

Ed Wagner (8/17/2016)

---

Jeff Moden (8/17/2016)

---

But they have direct access to the audit table? That doesn't make sense to me...

SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

CAST(price AS varchar(20)),

'0', 'A'),

'1', 'B'),

'2', 'C'),

--...

...

You could. Or you could change the FK rules to "CASCADE" rather than "NO ACTION" -- at least temporarily -- then just try updating the id from 1 to...

I prefer to name procedures first by topic area as well. I was merely pointing out that it's more common to use verb_object.

Personally I despise a prefix that represents...

Jeff Moden (8/17/2016)

---

ScottPletcher (8/17/2016)

---

Jeff Moden (8/16/2016)

---

ScottPletcher (8/16/2016)

---

Jeff Moden (8/16/2016)

---

ScottPletcher (8/16/2016)

---

Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then...

Probably most common is verb_object, such as Get_UserName, or some such. I've never seen the "main" table name used as part of the proc name, and it seems like...

Jeff Moden (8/16/2016)

---

ScottPletcher (8/16/2016)

---

Jeff Moden (8/16/2016)

---

ScottPletcher (8/16/2016)

---

Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then INSERTs might not...

Jeff Moden (8/16/2016)

---

ScottPletcher (8/16/2016)

---

Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then INSERTs might not need logged. ...

Grant Fritchey (8/16/2016)

---

MyDoggieJessie (8/16/2016)

---

I've always been a little fuzzy on this one - So, is just executing sp_updatestats a safe bet after indexing? Realizing that rebuilildng indexes will only...

Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then INSERTs might not need logged. But verify that...

Ed Wagner (8/16/2016)

---

ScottPletcher (8/16/2016)

---

Ed Wagner (8/16/2016)

---

ScottPletcher (8/16/2016)

---

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even...

Ed Wagner (8/16/2016)

---

ScottPletcher (8/16/2016)

---

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never...

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the...

Jeff Moden (8/15/2016)

---

ScottPletcher (8/15/2016)

---

Jeff Moden (8/15/2016)

---

Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the original data lives...