Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 5,678 total)

  • RE: Small database with 1 million users

    Apologies if this was mentioned, I skimmed a bit after the first few posts...

    To add to the list of clarifications for us to help you, is this 300 -> 1...


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

    Bit slow for me as well, even pulling up a response page, and I'm trying to play catchup for the entire week. I think I'll just chalk it up...


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

    Exhaustion.


    - 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: Re: Ticket- MSSql server is in other than Active state

    catchmekiran (10/12/2012)


    This ticket was system generated. I also checked if it's clustered or not and it is not.

    Someone from app team called one of the dba and it was found...


    - 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 to Dynamically Change Oledb Source and Excel File in Excel Destination.

    avdhut.k (10/4/2012)


    Now,I want Sql source Query to be dynamically change based on the iteration of For Loop

    A mutable source is not available without 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: Innovation

    I find the idea of innovation to be interesting, and I'm primarily a developer, and I love to innovate and find new ways of performing some task. But generally,...


    - 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: Vendor Recommendations, need advice

    GilaMonster (10/12/2012)


    Evil Kraig F (10/12/2012)


    GilaMonster (10/12/2012)


    Doesn't sound like bad plans then, or at least not the type that can be fixed with a recompile. Considered gettign a consultant in?

    No joy...


    - 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: Vendor Recommendations, need advice

    GilaMonster (10/12/2012)


    Doesn't sound like bad plans then, or at least not the type that can be fixed with a recompile. Considered gettign a consultant in?

    No joy doing that with 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: Shrinking a database - convincing management not to do this

    Your best bet here is to provide external documentation and evidence (blogs, SQLTeam white papers, etc) as to what shrinking actually does to the speed if it's done over enthusiastically....


    - 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: Rebuliding Indexes

    GilaMonster (10/9/2012)


    Evil Kraig F (10/9/2012)


    YarHad (10/9/2012)


    GilaMonster (10/9/2012)


    Index rebuilds don't get written into the SQL Server error log. You could add a piece to your maintenance tasks to log that 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: Update records?

    I'll +1 Gail on this but most of my evidence is via her and a few others that I was privelidged to watch a discussion they had.

    In general, you won'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

  • RE: DBCC PAGE

    Dr.sql.com (10/10/2012)


    again, apologies if this seems trivial, just require some assistance.

    Arguing with DBCC Page is anything but trivial except for a limited number of people (<1000 at best, in 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

  • RE: Help reading Deadlock graph

    opc.three (10/6/2012)


    Just for the record an RPC event does not necessarily mean it was generated by a call via a Linked Server. All data clients have the option to generate...


    - 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: Execution Of EXE

    I'm sorry, but I'm afraid some details from this point forward will be a bit lacking from me, simply because I'm not an application coder.

    To the basics: An executable called...


    - 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: PIVOT - Maximum number of pivoted columns

    LOL, true enough.

    Even if you run into a soft ceiling in memory, it won't be hard to work around (though over a certain # of columns you DO have 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

Viewing 15 posts - 1,051 through 1,065 (of 5,678 total)