It must be nice to have a team of developers on call. :hehe:

I work for a fairly small company (about 150 employees) and I *AM* the IT department. Support, development,...

sturner (8/16/2012)

---

Alex Gay (8/16/2012)

---

I wouldn't recommend C as a starting language, but once you can program it is always good to learn what your compiler is doing behind the scenes,...

Mike Austin-398977 (8/15/2012)

---

By your reasoning, all of us should be required to take a course in transmission repair before we're allowed to drive a car.

IMHO, the legacy the...

My background is programming, most of my career has been in application development. Over 30 some-odd years I've learned a wide array of languages and dialects, from C to Basic...

While I'm late to the party and missed answering yesterday 🙂 I knew foreign keys don't generate indexes, but my question is why the heck not?

Foreign keys are there...

Certifications are worthless.

A) The cynical side of me says it's a profit center for companies and nothing more.

B) The cynical side of me also says HR is looking for a...

You know, if you took out the transaction the answer would be exactly the same? How then is this a transaction? 🙂

Still say having SET XACT_ABORT OFF as the default...

L' Eomot Inversé (5/23/2012)

---

That's the whole point...

Daniel Bowlin (5/23/2012)

---

I agree with some of the other posts that express frustration that this is the default setting that seems rather contrary to an explicit transaction.

So the...

Having the default setting to OFF basically break transactions and is a *bug* in SQL Server.

Explicit transactions should be exactly that, explicit. This stupidity is exactly the kind of thing...

I *love* SQL...

Nakul Vachhrajani (3/18/2012)

---

I always insist that my team has the "replace tabs with spaces" switch in SSMS options checked and also run code through the "beautifer" option of "Untabify selection".

In...

Very, very helpful. Maybe Microsoft should have a set of tables like this one at the front of the BOL! 🙂

You know, the fact this was a trick question highlights a glaring flaw in T/SQL (or perhaps SQL in general?). Using single quotes for both strings and dates is a...

Passwords are a massively contentious issue.

The main problem with them is their nature is paradoxical. They have to remain secret yet they have to be known...

The problem with rapid changes...