marcia.j.wilson (5/7/2015)

---

Eric M Russell (2/10/2012)

---

Another scenario is where the developer includes un-needed table joins and returns additional columns that are never referenced by the application or reporting tool. I've even...

Gary Varga (5/8/2015)

---

I have seen this in a large number of places with the belief that it was just better...

Bradley Deem (5/7/2015)

---

Sorry, Oracle terminology. In SQL Server this would be Snapshot. Regardless, use technology to allow you to rollback to the point in time...

Creating objects is straightforward, but I've found the most problematic DDL deployment scripts are those that alter tables. However, INFORMATION_SCHEMA and SYS tables can be leveraged to determine to current...

Yet Another DBA (5/6/2015)

---

Been writing my release scripts like this for years. Like you I didnt know there was a specific term for it.

As one co-worker said: "write it like...

djackson 22568 (5/6/2015)

---

Eric M Russell (5/1/2015)

---

djackson 22568 (5/1/2015)

---

...

I recall a discussion here regarding whether college is useful. This is an area where I think a good education is useful....

For slowly changing reference tables, something like States or ProductCategory, I prefer to maintain the entire collection of inserts bundled into one "idempotent" deployment script. When adding a new row,...

Steve Jones - SSC Editor (5/5/2015)

---

Eric M Russell (5/5/2015)

---

In most scenarios the auditing operation should be done asynchonously, if possible, for performance reasons. But you can't do that if the...

For me, proactive performance optimization is analyzing Estimated Excution Plans within the SSMS Query window, as I'm in the process of writing the stored procedure. Also, I'll querying Actual Execution...

If your auditing process is failing, then that should be a top priority for investigation, and in something like a financial transaction database, you may want to consider suspending operation...

In most scenarios the auditing operation should be done asynchonously, if possible, for performance reasons. But you can't do that if the auditing operation is bundled within batch transaction.

Another reason...

djackson 22568 (5/1/2015)

---

...

I recall a discussion here regarding whether college is useful. This is an area where I think a good education is useful. Understanding why things run...

Eirikur Eiriksson (5/1/2015)

---

Eric M Russell (5/1/2015)

---

Eirikur Eiriksson (5/1/2015)

---

Eric M Russell (5/1/2015)

---

Static code analysis doesn't know how many times the code is executed, how much data it accesses, or how it's...

Eirikur Eiriksson (5/1/2015)

---

Eric M Russell (5/1/2015)

---

Static code analysis doesn't know how many times the code is executed, how much data it accesses, or how it's impacted when running in parallel...

Eric M Russell (5/1/2015)

---

djackson 22568 (5/1/2015)

---

Commenting mainly to benefit from what others share...

We are implementing a major product that solves this issue by having a shadow of live, and all...