Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 5,685 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...

  • 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...

  • RE: Today's Random Word!

    Exhaustion.

  • 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...

  • 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...

  • 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,...

  • 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...

  • 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...

  • 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....

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

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