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

Interviewing for a job is a lot like going out on a first date. The goal shouldn't be to say all the right things that land you the job, the...

Master Luke didn't have a day job, a family, a commute, or any of the other things that compete for the limited time that most of us have. Also, most...

There have been times in the past when I've gone to an interview because the job description looked good or a recruiter talked it up as a good opportunity, and...