Forum Replies Created

Viewing 15 posts - 2,806 through 2,820 (of 14,953 total)

  • RE: What about contract to hire

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Any good reading/tips on exactly how to break out information?

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Save a file inside SQL Server or outside?

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

    p-nut (11/17/2011)


    Is there a reason this OP has posted this 3 times and we all seem to keep replying to it? 🙂

    Jared

    All of us are bots. Aren't you?

    Edit: But...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: XQeury modify() fails when update a decimal value that is null

    Found this:

    An error is returned if the modify() method is called on a null value or results in a null value.

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

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

    I don't know...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: XQeury modify() fails when update a decimal value that is null

    What error do you get when it fails?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Comparing dates

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: What is the use of Table Hint in SQL like NOLOCK, READUNCOMMITTED

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

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

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 15 posts - 2,806 through 2,820 (of 14,953 total)