Forum Replies Created

Viewing 15 posts - 21,091 through 21,105 (of 49,552 total)

  • RE: What is Prod,Dev and Test servers?

    Production - Where the live application's database runs

    Development - where development is done

    Testing - Where new development/modifications are tested before been moved to production. Also called QA or UAT.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 8:20 am

    #1432555

  • RE: SP_UpdateStats

    Divine Flame (1/12/2012)

    Thanks Gail, so it makes sense to run the maintenance in this order:

    1. sp_updatestats

    2. ALTER INDEX...REBUILD/REORGANIZE

    Thanks again 🙂

    No, it doesn't. Why update statistics that are about to be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 8:17 am

    #1432554

  • RE: SP_UpdateStats

    p.s. The maintenance plan 'Update Statistics' task doesn't use sp_updatestats. It runs an explicit UPDATE STATISTICS against every table, so no checks at all for whether or not even a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 8:17 am

    #1432553

  • RE: Question for the "experts"

    patrickmcginnis59 (1/12/2012)

    look at the reaction you got because you preferred "raiserror" for instance, one fellow flat out called you "wrong" and pretty much rejected you on a personal basis because...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 8:12 am

    #1432548

  • RE: SP_UpdateStats

    sp_update stats has threshold of rows that must have been changed since the last stats update for it to update them again. As Grant says in his article

    then, you run...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 8:06 am

    #1432540

  • RE: Question for the "experts"

    Edit: Brick wall.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 7:54 am

    #1432530

  • RE: ShrinkDatabase doesn't shrink the data file

    Cool. Post back when you can so that we can help further if necessary and make sure that the problem really is fixed.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 7:27 am

    #1432503

  • RE: Are the posted questions getting worse?

    GSquared (1/12/2012)

    I was actually looking at the discussions on my audit trails articles just yesterday. Posted those articles in '08. Wow! They definitely needed a lot of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 7:03 am

    #1432475

  • RE: ShrinkDatabase doesn't shrink the data file

    Cool. Will you post back tomorrow and let us know about the size of the table, the amount of free space in the database (sp_spaceused) and the like?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 6:59 am

    #1432471

  • RE: Question for the "experts"

    DeanORenO (1/12/2012)

    I like all the interpretations of my question but still no answer. I imagine if I asked the question what is 2 + 2, I would get people telling...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 6:57 am

    #1432469

  • RE: ShrinkDatabase doesn't shrink the data file

    Yup. Run it once and see if it does have the effect that you want (run it on the clustered index). If that does help then, depending how often you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 6:46 am

    #1432450

  • RE: Managing Transaction Logs

    SQLPhil (1/12/2012)

    It'll be nice to have the opportunity to turn round and inform the instructor for once! 😉

    😀

    Just be polite if you do. Speaking as a occasional trainer and presenter,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 6:43 am

    #1432446

  • RE: How to insert multiple rows into a table with identity column

    CGSJohnson (1/12/2012)

    Man, kind of abrasive, no, Mr. Celko?! I thought that this is supposed to be a supportive forum. I can understand your frustrations, but we can direct...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 6:42 am

    #1432443

  • RE: Urgent - SQL Server on Samsung GALAXY Tab 10.1 ?

    SQL Server Compact Edition should run on any Windows OS device (windows phone or any tablet with windows on it), I highly doubt we'll ever see SQL Server running on...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 6:37 am

    #1432434

  • RE: Are the posted questions getting worse?

    Bex (1/12/2012)

    From someone who is a lurker on this site, I take the attitude that if I ask for free help and I don't like the reponses I am getting,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 12, 2012 at 6:28 am

    #1432421

Viewing 15 posts - 21,091 through 21,105 (of 49,552 total)