Forum Replies Created

Viewing 15 posts - 2,821 through 2,835 (of 14,953 total)

  • RE: Are the posted questions getting worse?

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

    GSquared (11/16/2011)

    Roy Ernest (11/16/2011)

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

    L' Eomot Inversé (11/16/2011)

    But it was Remi who said it, and in the thread, and the combination of those two factors seems to me to...

    - 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

    November 16, 2011 at 2:37 pm

    #1408897

  • RE: How do I view the TSQL associated with the History Cleanup task

    If you can't get it another way, run a trace and run the task. Get the SQL out of the trace.

    But you should be able to open up the...

    - 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

    November 16, 2011 at 12:19 pm

    #1408803

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

    Brandie Tarvin (11/16/2011)

    Dev (11/16/2011)

    Now I'm curious. Since when is the use of NOLOCK a best practice?

    This is cross-question. This is what I suggested to Ashu. 😀

    But what I...

    - 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

    November 16, 2011 at 12:07 pm

    #1408791

  • RE: Are the posted questions getting worse?

    Roy Ernest (11/16/2011)

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

    L' Eomot Inversé (11/16/2011)

    But it was Remi who said it, and in the thread, and the combination of those two factors seems to me to require the...

    - 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

    November 16, 2011 at 11:58 am

    #1408786

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

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

    - 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

    November 16, 2011 at 6:36 am

    #1408446

  • RE: Are the posted questions getting worse?

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

    Koen Verbeeck (11/15/2011)

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

    jcrawf02 (11/15/2011)

    Hey, I like the condensed version of The Thread...

    Same here.

    No offense if I forgot anything else. I didn't reread the whole 2 weeks either...

    - 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

    November 16, 2011 at 6:31 am

    #1408442

  • RE: Network Databases? Is it time to change?

    Steve Jones - SSC Editor (11/15/2011)

    PhilipC (11/14/2011)

    What makes you so strongly say not to backup a SQL database across the network out of interest?

    I've been doing this for a while...

    - 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

    November 15, 2011 at 7:09 pm

    #1408231

  • RE: The Industry Problem

    Steve Jones - SSC Editor (11/14/2011)

    Bill Stutters (11/14/2011)

    I think part of the problem with the lack of people going into CS majors is that the industry has done a very...

    - 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

    November 15, 2011 at 7:05 pm

    #1408230

  • RE: Are the posted questions getting worse?

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

    Brandie Tarvin (11/15/2011)

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

    Brandie Tarvin (11/11/2011)

    EEEK! I just sold another story. Happy happy.

    Now I have to write more.

    EDIT: Nevermind. I see you were quoting them for Grant. DOH....

    - 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

    November 15, 2011 at 7:44 am

    #1407891

  • RE: Network Databases? Is it time to change?

    I haven't tried a data file on a network share yet.

    On the other hand, data files on a SAN aren't really "local", but I have plenty of databases working that...

    - 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

    November 15, 2011 at 6:49 am

    #1407836

  • RE: Don't Criticize Code

    JJ B (11/14/2011)

    I thought this was a great editorial and appreciated the good reminder.

    I also think this is a walking advertisement for thoroughly documenting the "why" of code as much...

    - 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

    November 15, 2011 at 6:19 am

    #1407806

  • RE: Never offend a captive audience

    MisplacedChildhood (11/14/2011)

    Ian Elliott (11/7/2011)

    I don't want to go out of my way to offend people but it seems that these days people like to go out of their way to...

    - 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

    November 15, 2011 at 6:06 am

    #1407800

  • RE: Using "or" in a join? Whatsupwiththat?!

    I totally understand prioritizing that way.

    And I used to deal with financial services data going from mainframe flat-files into relational stores, then into analysis cubes, then back to flat files....

    - 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

    November 14, 2011 at 12:40 pm

    #1407485

  • RE: Don't Criticize Code

    majorbloodnock (11/14/2011)

    GSquared (11/14/2011)

    majorbloodnock (11/14/2011)

    GSquared (11/14/2011)

    majorbloodnock (11/14/2011)

    ... LOTS

    of

    text ...

    What you're talking about, though, isn't criticism ...

    If by "criticism" you mean badmouthing something with statements like...

    - 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

    November 14, 2011 at 12:33 pm

    #1407482

  • RE: Why is "Select *" bad in any SQL code?

    Greg Charles (11/14/2011)

    It's too bad nobody referenced BOL for this quote:

    "If a SELECT is used in an application or script that has logic dependent on the number of columns...

    - 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

    November 14, 2011 at 12:22 pm

    #1407478

Viewing 15 posts - 2,821 through 2,835 (of 14,953 total)