It's normal to do contract-to-hire these days.

Some companies are calling it a "working interview" in the hope that the new name will confuse people (I guess).

Either way, it's the usual...

I pretty much break it down on what has a 1:1 relationship to the object, persists, and helps to identify the specific object.

So, with a student, I wouldn't include address,...

There's some good data here: http://msdn.microsoft.com/en-us/library/bb933993.aspx

All of us are bots. Aren't you?

Edit: But...

Found this:

On: http://msdn.microsoft.com/en-us/library/ms187093.aspx

Page title: modify() Method (xml Data Type)

I don't know...

Chad Crawford (11/17/2011)

---

Wahoo! Just passed the MS 70-453 test, making me a MCITP for SQL 2008 just in time for 2012 to come out. 😀

Very happy - Passing...

What error do you get when it fails?

If you're on SQL 2008 (as per forum), convert/cast to DATE datatype.

Matt Miller (#4) (11/17/2011)

---

GSquared (11/17/2011)

---

If all uses of the data are fault tollerant because they do not ever rely on specific values, then the incorrect data from NoLock issues is...

Oh trust me, I've had my goof-up posts. Gail and Paul are the ones who catch me on it now and again. Those two are a good safety...

GilaMonster (11/17/2011)

---

Dev (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

Tom Brown (11/17/2011)

---

It has to be oversized, have you seen his list of qualifications - not sure I understand most of them but I'd...

Tom Brown (11/17/2011)

---

It has to be oversized, have you seen his list of qualifications - not sure I understand most of them but I'd like to be a qualified...

p-nut (11/17/2011)

---

Ok, as it turns out she believes the reason is 2-fold. Her words: The first is that the nature of our data does not leave open transactions. ...

RTaylor2208 (11/15/2011)

---

As mention above use with caution.

It all depends on what your database is used for. The organisation I currently work for read performance is paramount and every attention...

Ninja's_RGR'us (11/16/2011)

---

GSquared (11/16/2011)

---

Ninja's_RGR'us (11/14/2011)

---

GSquared (11/14/2011)

---

Tom Brown (11/14/2011)

---

OK I've read and inwardly digested the link. :blush:

Seems like SNAPSHOT Read committed is one way to go. However if I investigate...