So after the staging server has finsihed updating it's copy of the database, you do what with the synonymns on the production server? Point your queries to a different database?

Generally speaking, transaction logging is trivial during the normal day to day operations of a OLTP database, especially if the log files are on separate storage from data files.

If...

[Jim].[dba].[Murphy] (3/10/2011)

---

mmmm. Not sure about that. A log truncation could have bad side effects if any part of that database is used by others; rows being modified in...

Carl B. (3/9/2011)

---

It could be helpfull to avoid logging in scenario where you want to "UPGRADE" the data in a BD with numerous conversions script:

1- You take a full backup...

Steve Jones - SSC Editor (3/9/2011)

---

Mark W Johnson (3/9/2011)

---

I don't see my job as writing code so much as solving the user's problem through code; my job is to help...

This piece is a few years old, and it talks about how quality has become more important at many large software vendors. Looking back across the five years since the...

Those of us who were developing applications in FoxPro, MS Access, or some other ISAM platform back in the 80's and early 90's know the perils of a transactionally inconsistent...

Transaction logging usually isn't an issue unless you're inserting 100,000+ records one.. at.. a.. time.. in a loop, or the DBA allows the transaction log to grow until it fills...

Of course wether or not a security flaw or bug makes public headlines determines how it is triaged, however it doesn't mean that Microsoft is just sitting on it.

Jeff Moden (3/3/2011)

---

Telarian (3/3/2011)

---

Jeff Moden (3/3/2011)

---

Oh, be careful now. "It Depends". 🙂 Scalar and Multi-Line Table Valued Functions (mTVF) can very quickly turn code into some pretty nasty,...

SQLkiwi (3/3/2011)

---

Eric M Russell (3/3/2011)

---

When I need to join a resultset from a remote server, like from a linked server connection, neither a View or TVF are beneficial. I'll typically...

When I need to join a resultset from a remote server, like from a linked server connection, neither a View or TVF are beneficial. I'll typically execute a parameterized pass-through...

SQLkiwi (3/3/2011)

---

In 2005 or later, I...

Depending on the circumstance, a view can replace the functionality of a scalar or table valued function and do so more efficiently. I once developed a datawarehouse and reporting application...

amenjonathan (3/2/2011)

---

Some experience at my prior employer lends me to believe they may have thought you weren't planning on staying? My last employer hired two very overqualified people to fill...