Forum Replies Created

Viewing 15 posts - 2,611 through 2,625 (of 5,678 total)

  • RE: 'PRIMARY' filegroup is full

    Krasavita (9/12/2011)


    Is it could be a case that my SQL Server is running out of available process memory. How can I check how much memory is allocated to the SQL...


    - 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: A design question

    There's one concern with de-normalizing the structure for your boss in regards to views, which I didn't see mentioned (sorry if someone brought this up).

    We need to determine why 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?

    Ninja's_RGR'us (9/12/2011)


    Yes I have been rude. I've also apologized, edit and excused myself many times.

    Not something Joe's been doing AFAIK.

    Also while far from perfect, I don't think I have...


    - 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: Today's Random Word!

    eccentricDBA (9/12/2011)


    Revenant (9/12/2011)


    SQLRNNR (9/12/2011)


    flame

    old

    retirement

    Old flame's retirement home.


    - 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: Today's Random Word!

    bcsims 90437 (9/9/2011)


    Revenant (9/9/2011)


    bopeavy (9/9/2011)


    FRIDAY!

    Beer(s)!

    Cheers!

    ~...where everybody knows your naaaammmmeee....~

    (and now it's stuck in my head)


    - 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: What would you move (in your DB ) to a new Drive If Your DB Server Got One

    YSLGuru (9/8/2011)


    I can however put the table itself and or its indexes on a separate File/Filegroup that is on the new drive since that would not alter/change the structure of...


    - 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: What would you move (in your DB ) to a new Drive If Your DB Server Got One

    Find the largest and hardest hit tables, and try to split them from join to join across two filegroups on the different drives. This way you can access two...


    - 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: pageiolatch_SH troubleshooting

    Couple of things here.

    Pages/sec are when you're resolving hard page faults, which since you mentioned your page file, seems to indicate that you're aware of that. However, yes, 350/sec...


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

    This Gentleman is looking for some ETL best practices and didn't quite get what I was trying to tell him. Perhaps another voice may be able to assist him...


    - 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: Data Warehouse best practices

    When is the process being run? Which one has more memory available? Are you transforming in the package or after drop to staging tables? Which one 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: A design question

    meichner (9/8/2011)


    Thank goodness you don't have to shoot me.

    Hehehe!

    Let me explain the relationships a little better.

    A Customer can have many Shipping/Billing addresses and many Shipping/Billing contacts.

    Not a problem...


    - 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 (9/8/2011)


    Side note, my dad (nearly 80) fell last night and broke his hip. Needs surgery. I'd appreciate prayers as his health is not good to begin...


    - 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: A design question

    meichner (9/7/2011)


    According to my boss, the design that I created is too complicated, but I think its fine. I was wondering if I could get some direction so that I...


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

    Roy Ernest (9/7/2011)


    Grant Fritchey (9/7/2011)


    You all know Gail is on right now? She's doing great:

    https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H

    I'm going on at 2300GMT or 7:00PM EDT

    https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H

    You'll get close to 2 out of 7 hours...


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

    Trey Staker (9/2/2011)


    Stefan Krzywicki (9/2/2011)

    We also have a Road Runner that builds nest on people's cars. The other day when I drove in there was a coyote chasing 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

Viewing 15 posts - 2,611 through 2,625 (of 5,678 total)