Forum Replies Created

Viewing 15 posts - 2,731 through 2,745 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (8/5/2011)

    Craig Farrell (8/5/2011)

    A moment of Friday Humor...

    Time to optimize, perhaps?

    What the heck is this supposed to to? :w00t:

    155 million row update on a very wide table (which has been...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 5, 2011 at 12:50 pm

    #1364603

  • RE: Are the posted questions getting worse?

    A moment of Friday Humor...

    Time to optimize, perhaps?

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 5, 2011 at 12:20 pm

    #1364579

  • RE: Are the posted questions getting worse?

    george sibbald (8/4/2011)

    GilaMonster (8/4/2011)

    george sibbald (8/4/2011)

    Craig Farrell (8/4/2011)

    RE: Airplanes and idiots:

    It's been proven that you can *waltz* through American security even after 9/11 with:

    ...- 2 lbs of C4 ( shaped...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 4, 2011 at 5:16 pm

    #1364054

  • RE: Are the posted questions getting worse?

    RE: Airplanes and idiots:

    It's been proven that you can *waltz* through American security even after 9/11 with:

    - A katana

    - Machete

    - Enough gunpowder to press your own 100 round magazine. ...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 4, 2011 at 2:35 pm

    #1363992

  • RE: SQLServerCentral.com Best Practices Clinic: Part 5

    Ninja's_RGR'us (8/3/2011)

    Ninja's_RGR'us (8/2/2011)

    UPDATE dbo.AnalysisLog SET @Count = Count = Count + 1 WHERE ...

    Nevermind that part, I had missed the fact that there's 1 row per date where there's action...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 4, 2011 at 11:46 am

    #1363855

  • RE: SQLServerCentral.com Best Practices Clinic: Part 5

    bradmcgehee@hotmail.com (8/2/2011)

    I am providing most of the information requested, except the XML execution plans. You will have to work with the graphical execution plans.

    Why not? Not that I can't...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 2, 2011 at 5:10 pm

    #1362762

  • RE: What is faster, MAX() with GROUP BY, OR CTE with ROW_NUMBER()?

    Pagan DBA (8/2/2011)

    As an aside, I'm sorry but BIT(1) = 1/0 is my preferred choice to VARCHAR(1) = Y/N. This is because in spite of my efforts, I have always...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 2, 2011 at 2:44 pm

    #1362651

  • RE: What is faster, MAX() with GROUP BY, OR CTE with ROW_NUMBER()?

    Row_Number() is rarely faster, and usually only due to bad indexing/heaps, or because the data is incredibly limited that it has to number before moving forward. On large data...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 1, 2011 at 4:06 pm

    #1361879

  • RE: Except vs. Left Join vs. Not Exists

    I wanted to thank everyone (particularly Paul) for helping me find, or at least learn what to go research, in regards to my confusion. I'm sorry I haven't been...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    August 1, 2011 at 12:06 pm

    #1361756

  • RE: Except vs. Left Join vs. Not Exists

    Eugene Elutin (7/27/2011)

    Are you always using MAXDOP 1 in your queries?

    You don't trust MS at all are you? 😀

    Not for benchmark tests, no. Besides, if you'll see my...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    July 27, 2011 at 3:05 pm

    #1359699

  • RE: Are the posted questions getting worse?

    john.arnott (7/26/2011)

    Tom.Thomson (7/26/2011)

    Grant Fritchey (7/26/2011)

    Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really scary...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    July 26, 2011 at 6:24 pm

    #1358907

  • RE: Design suggestions for Large SQL 2008 table (several billion+ rows)

    To simplify and maybe help you narrow down what OPC is discussing here, are you joining that PK into other tables? If so, that's going to hurt, and you...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    July 26, 2011 at 3:54 pm

    #1358875

  • RE: Are the posted questions getting worse?

    Chad Crawford (7/26/2011)

    <Darth Vader>: Luke!

    <Luke>: Yes father?

    <Darth Vader>: I know what you're getting for your birthday.

    <Luke>: But father, how could you know what I'm getting...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    July 26, 2011 at 3:32 pm

    #1358872

  • RE: Max degree of parallelism

    SQLkiwi (7/26/2011)

    I do want to respond to the comments about CXPACKET though. Very few people understand what CXPACKET truly means (and I do not number storage engine experts among...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    July 26, 2011 at 2:18 pm

    #1358820

  • RE: Max degree of parallelism

    On a personal level, I'd probably start at serverwide MAXDOP 8 with a cost setting of ~10-15 and then monitor the heck out of it looking for the pain points....

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    July 26, 2011 at 11:59 am

    #1358712

Viewing 15 posts - 2,731 through 2,745 (of 5,678 total)