Forum Replies Created

Viewing 15 posts - 3,481 through 3,495 (of 5,678 total)

  • RE: How do I rebuild or defrag the index that is auto created for tables containing image columns

    Micah Ritchie (4/5/2011)


    I've been looking into some possible index violations on a table. Unfortunately the errors we get from the software don't tell us much. After talking 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: Restore database txtPost_CommentEmoticon(':-)');

    Depends. are your backups on separate *physical* spindles from everything else, it wouldn't be too bad. I'd usually copy, then work.


    - 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: SQL Server running incredibly slow since Friday...

    UMG Developer (4/5/2011)


    Jeff Moden (4/5/2011)


    forsqlserver (4/4/2011)


    Looping Myself...

    Please explain.

    My guess is they are used to being added for immediate notifications when replying to a thread, so they added a reply 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 (4/5/2011)


    Craig Farrell (4/5/2011)


    On another topic. Anyone out there know of a site or something that will help me compute what the storage length is for different numeric/decimal combinations?...


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

    CirquedeSQLeil (4/5/2011)


    GilaMonster (4/5/2011)


    I'm not sure I really want to get involved in this one (old friend), let's see if he does the prereq reading.

    He's got something using virtual memory (specifically...


    - 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 (4/5/2011)


    I'm not sure I really want to get involved in this one (old friend), let's see if he does the prereq reading.

    Heh, I'm sure I don't want 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?

    CirquedeSQLeil (4/5/2011)


    Craig Farrell (4/5/2011)


    SQLDCH (4/5/2011)


    CirquedeSQLeil (4/5/2011)


    Can anybody else lend a hand here?

    Aye, we're doing our best =)

    Going for sainthood, you two? I'm not sure there's much I could add...


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

    SQLDCH (4/5/2011)


    CirquedeSQLeil (4/5/2011)


    Can anybody else lend a hand here?

    Aye, we're doing our best =)

    Going for sainthood, you two? I'm not sure there's much I could add to that, except...


    - 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: Flat File Destination Issue

    copett86 (4/4/2011)


    I have a DataReader Source using ODBC driver(ADO.NET) for a connection that links to an outbound flat file destination. I use to have a data conversion step, but took...


    - 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: SQL Server running incredibly slow since Friday...

    Nah, 0 is fine, unless you have known issues or you're sharing the box across multiple instances, then you might want finer controls. Hyperthreading on the other hand has...


    - 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: SQL Server running incredibly slow since Friday...

    MyDoggieJessie (4/4/2011)


    RESOURCE_SEMAPHORE - Any ideas on how to pinpoint this the root cause of this? Currently it's at:

    wait_typewait_time_spctrunning_pct

    RESOURCE_SEMAPHORE111023.0919.9358.16

    Offhand, no. I'd have to research and probably bombard you with...


    - 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: SQL Server running incredibly slow since Friday...

    MyDoggieJessie (4/4/2011)


    We recently stopped the reports that were running using the linked servers and then started some of them again in a manual process...

    I have an "okay" understanding of waits...


    - 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: SQL Server running incredibly slow since Friday...

    MyDoggieJessie (4/4/2011)


    I don't mean to ask an overly stupid question but how did you get 13.5 hrs from this?

    49971.02 / 60 (seconds) / 60 (minutes).

    That's the wait time across every...


    - 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: The Value of Data

    jeff.mach (4/4/2011)


    I can see paying for an authoritative, credible information source if the information was important enough to me. But I find it odd that both the NYT and 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: SQL Server running incredibly slow since Friday...

    MyDoggieJessie (4/4/2011)


    Not sure how to paste in an image here but will copy and paste the results from your query below so you can paste it into excel or something:

    Even...


    - 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,481 through 3,495 (of 5,678 total)