GilaMonster (3/19/2012)

---

The RowLock (or pageLock) hints just say what the locks should start as, nothing more. In this case they'll start as row, but once past the 5000 or so...

I also agree, spot on!

ma-516002 (12/13/2011)

---

Interesting question, but the code itself is valid. The answer you classified as correct depends on the actual data. It appears reasonable to imply that c.IsInsuranceLength is set to...

katesl (12/10/2011)

---

I worked at a university as a data analyst using statistical software in 1983-- yes, 1983. I struggled to manage data relationships using SPSS. Then I was...

I would not like to have my duties spelled out exactly because I like different challenges as long as it's within my area of expertise, if I were asked to...

Ouch, you got me, I assumed implicit conversion without thinking it through. Thanks for the question.

"Life's too short to live with a crappy job for a long time, no matter how much they pay you."

Well that's just the best thing I've read in a long...

I think this editorial was pretty awesome, thanks :).

So what's the quickest/easiest way to learn about (SQL) Azure?

Very interesting editorial, thanks.

This is something I have thought a lot about, and I think many other have too. I once worked as a team manager once but that was...

Interesting question, thanks!

Are you sure you don't need two? 😉

Great editorial!

Us IT-people (developers, sysadmins, support staff, etc) are usually at the mercy of some kind of manager and bureaucracy. And since managers are also humans, they can also be...

murray-906152 (7/19/2011)

---

I think that this question is ambiguous and should be withdrawn.

There is NO query returning zero rows in the question.

There is one insert statement yielding five rows affected.

You might...

majorbloodnock (7/19/2011)

---

andreas.agren (7/19/2011)

---

Adapt to the dress code? Watch before you form alliances? Sounds a lot like prison to me. I agree that one should adapt to the work place but...