Forum Replies Created

Viewing 15 posts - 27,181 through 27,195 (of 49,552 total)

  • RE: Does Estimated Subtree Cost Provide (near)Accurate Measurement?

    Marvin Maralit (3/22/2011)

    This will be goin to be a pain in the neck 🙁

    Why?

    Performance tuning is all about tweaking then testing for effects. If you don't test, how do...

    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

    March 22, 2011 at 11:29 pm

    #1302273

  • RE: Are the posted questions getting worse?

    GSquared (3/22/2011)

    Get well soon (flu thing), and definitely consider that move you mentioned a while back. Change of environment alone will probably help.

    Flu was a 3-day wonder.

    As for move,...

    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

    March 22, 2011 at 3:00 pm

    #1302194

  • RE: Error in table 'sys.sysbinobjs' on master database

    And you don't have older backups?

    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

    March 22, 2011 at 2:59 pm

    #1302192

  • RE: Historical data retrived by DMV

    Not with 100% reliability. You could miss queries, you could get distorted stats because of compiles/recompiles/plans discarded from cache.

    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

    March 22, 2011 at 2:17 pm

    #1302172

  • RE: Are the posted questions getting worse?

    GSquared (3/22/2011)

    GilaMonster (3/22/2011)

    Craig Farrell (3/22/2011)

    Gail, I think I may have inherited your business users.

    Could you inherit the manager too please?

    I'm now completely prohibited from doing any work for them if...

    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

    March 22, 2011 at 2:05 pm

    #1302161

  • RE: Error in table 'sys.sysbinobjs' on master database

    Not sure why it's appearing and disappearing, have asked for a second opinion on that.

    Got a clean backup of master?

    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

    March 22, 2011 at 2:03 pm

    #1302160

  • RE: Historical data retrived by DMV

    The query stats is completely dependant on the plan cache. When something is thrown out of cache the stats disappear.

    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

    March 22, 2011 at 2:03 pm

    #1302158

  • RE: Are the posted questions getting worse?

    Craig Farrell (3/22/2011)

    Gail, I think I may have inherited your business users.

    Could you inherit the manager too please?

    I'm now completely prohibited from doing any work for them if not sitting...

    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

    March 22, 2011 at 1:57 pm

    #1302152

  • RE: Difference between Truncateonly and NoTruncate

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    March 22, 2011 at 12:28 pm

    #1302087

  • RE: Shrink Database in Simple Recovery Mode

    Sachin Nandanwar (3/22/2011)

    GilaMonster (3/22/2011)

    Sachin Nandanwar (3/22/2011)

    Do shrinking of database logged even though the recovery model is SIMPLE ?

    All data modifications are logged regardless of the recovery model.

    So when a checkpoint...

    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

    March 22, 2011 at 12:27 pm

    #1302086

  • RE: Difference between Truncateonly and NoTruncate

    Sachin Nandanwar (3/22/2011)

    But how does it help and what exactly happens if we use NoTruncate with backup command for tail log backup's if the log entries are by default done...

    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

    March 22, 2011 at 12:12 pm

    #1302068

  • RE: Shrink Database in Simple Recovery Mode

    Sachin Nandanwar (3/22/2011)

    Do shrinking of database logged even though the recovery model is SIMPLE ?

    All data modifications are logged regardless of the recovery model.

    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

    March 22, 2011 at 11:50 am

    #1302053

  • RE: Rebuild/Reorg Indexes

    Pei Zhu-415513 (3/22/2011)

    But if it failed, you wouldn't be certain if the database in production or the offline server corrupted.

    Correct. If it failed you'd have to check the actual prod...

    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

    March 22, 2011 at 11:40 am

    #1302044

  • RE: Difference between Truncateonly and NoTruncate

    What you're missing is that truncateonlyon a shrink is only a valid option when shrinking a data file. Hence all my comments about moving data pages around.

    See Books Online.

    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

    March 22, 2011 at 11:39 am

    #1302040

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/22/2011)

    This particular piece of advice, which doesn't have a whole lot to do with the OPs problem (other than the bit about shrinking the files after doing something...

    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

    March 22, 2011 at 11:34 am

    #1302034

Viewing 15 posts - 27,181 through 27,195 (of 49,552 total)