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

CirquedeSQLeil (3/1/2011)

---

Eric M Russell (3/1/2011)

---

CirquedeSQLeil (3/1/2011)

---

Koen Verbeeck (2/28/2011)

---

CirquedeSQLeil (2/28/2011)

---

Worst / strangest question was "how many of _______ can fit in a bus?" The interviewer wanted to argue with my...

CirquedeSQLeil (3/1/2011)

---

Koen Verbeeck (2/28/2011)

---

CirquedeSQLeil (2/28/2011)

---

Worst / strangest question was "how many of _______ can fit in a bus?" The interviewer wanted to argue with my answer - which I...

CirquedeSQLeil (2/28/2011)

---

Worst / strangest question was "how many of _______ can fit in a bus?" The interviewer wanted to argue with my answer - which I thought was somewhat...