Forum Replies Created

Viewing 15 posts - 3,241 through 3,255 (of 5,678 total)

  • RE: Index Rebuilding

    Incindium (5/4/2011)


    Would this be a case when it would make sense to DISABLE an index before rebuilding it?

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

    I've used this one before in some development testing but was curious it...


    - 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

  • RE: Are the posted questions getting worse?

    GSquared (5/4/2011)


    Craig Farrell (5/3/2011)


    Side topic, has anyone here looked for employee or resume submittals via SSC? If so, what was your quality of recipients? We're running into a...


    - 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

  • RE: Are the posted questions getting worse?

    Jack Corbett (5/4/2011)


    Craig Farrell (5/3/2011)


    Side topic, has anyone here looked for employee or resume submittals via SSC? If so, what was your quality of recipients? We're running into...


    - 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

  • RE: How do you vulgarize a DBA's job?

    GSquared (5/3/2011)


    Craig Farrell (5/2/2011)


    Brandie Tarvin (4/29/2011)


    GSquared (4/29/2011)


    I tell people that my job description is specifically designed to see how fast a person's eyes can glaze over. The entertainment starts...


    - 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

  • RE: Restore failed - insufficient free space on disk volume

    Steve Jones - SSC Editor (5/3/2011)


    Craig Farrell (5/3/2011)


    Steve, I've found that 99% of servers have their USBs locked down at the server side, if you can even access the...


    - 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

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/4/2011)


    Craig Farrell (5/3/2011)


    Side topic, has anyone here looked for employee or resume submittals via SSC? If so, what was your quality of recipients? We're running into...


    - 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

  • RE: SSIS 2005 is way too slow. Are there any other ETL good tools?

    Koen Verbeeck (5/4/2011)


    Maybe the problem isn't SSIS's fault.

    How is the package created? What connectors did you use?

    Did you do any transformations? Did you incorporate parallellism?

    SSIS 2008 is also a bit...


    - 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

  • RE: Stored proc eating bandwidth on server!

    nikhil8960 (5/3/2011)


    Thanks LutzM.. I found that we are using stored proc too often with various frequent calls. we have decided to use only default pass parameter for building the color...


    - 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

  • RE: Importing data performance

    crainlee2 (5/3/2011)


    Question, anyone:

    Is bulk insertion into a heap more efficient than bulk insertion into a clustered index?

    Depends on a few things.

    One is it will depend on if you're inserting...


    - 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

  • RE: Urgent plz Problem with with(Nolock)

    sqlbuddy123 (5/3/2011)


    BTW, What's the reason that you are using NOLOCK hint ?

    At a guess from the first post:

    table1 is trading table and so heavy amount of rows get inserted into...


    - 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

  • RE: Are the posted questions getting worse?

    Side topic, has anyone here looked for employee or resume submittals via SSC? If so, what was your quality of recipients? We're running into a dearth of reasonable...


    - 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

  • RE: package config and variables

    For variables, there's two settings.

    Design time and override. Design time is what you set them to when you first build the package. Override is what they're set to...


    - 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

  • RE: Are the posted questions getting worse?

    GilaMonster (5/3/2011)


    Tell me how they could do travel and expenses fairly (if it was even in the budget) when travel ranges from nothing (the people living in/near Seattle) to over...


    - 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

  • RE: Are the posted questions getting worse?

    GilaMonster (5/3/2011)


    Craig Farrell (5/3/2011)


    GilaMonster (5/3/2011)


    Thanks everyone

    Ironic that the session from 24HoP was one I wasn't considering submitting for summit

    Of course the real killer is are they paying for travel and...


    - 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

  • RE: Are the posted questions getting worse?

    GilaMonster (5/3/2011)


    Thanks everyone

    Ironic that the session from 24HoP was one I wasn't considering submitting for summit

    Of course the real killer is are they paying for travel and expenses since you're...


    - 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

Viewing 15 posts - 3,241 through 3,255 (of 5,678 total)