Forum Replies Created

Viewing 15 posts - 31,321 through 31,335 (of 49,552 total)

  • RE: Help on Table/Query tuning

    Post the view definition?

    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

    August 11, 2010 at 1:41 am

    #1205184

  • RE: SQL LOGFILE- how much is committed and uncommitted?

    iqtedar (8/10/2010)

    so Gail as per your statement size of log file and size of trn file should be the same?

    No, not at all. Where did I say that?

    I tested...

    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

    August 10, 2010 at 10:58 pm

    #1205131

  • RE: MAXDOP - How many CPU's does it use

    Leo.Miller (8/10/2010)

    Some DBAs feal this is better managed by increasing the Cost Threshold for Parallelism, typically to 30 seconds.

    Just one comment - cost threshold is not measured in seconds....

    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

    August 10, 2010 at 3:09 pm

    #1205060

  • RE: Are the posted questions getting worse?

    LutzM (8/10/2010)

    You're not talking about Elephant or Zebra biltong, are you?

    No, just beef to start with, wouldn't want to scare the poor Americans :-D. Kudu biltong is awesome, if 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

    August 10, 2010 at 3:03 pm

    #1205058

  • RE: SQL LOGFILE- how much is committed and uncommitted?

    Log backups back up everything in the log (active and inactive portions) and then mark the inactive portions of the log as reusable. Inactive meaning there's no uncommitted transactions, all...

    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

    August 10, 2010 at 2:34 pm

    #1205041

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/10/2010)

    GilaMonster (8/10/2010)

    Jack Corbett (8/10/2010)

    If you are going to use maple syrup please at least make it REAL maple syrup, not Mrs. Butterworth's or something else like that....

    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

    August 10, 2010 at 2:19 pm

    #1205036

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/10/2010)

    If you are going to use maple syrup please at least make it REAL maple syrup, not Mrs. Butterworth's or something else like that.

    For those who...

    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

    August 10, 2010 at 1:54 pm

    #1205020

  • RE: Composite clustered index ordering when inserting

    Grant Fritchey (8/10/2010)

    Hmmm... But I thought that the reorganise was pretty light in it's touch, just eliminating blank pages & such and relinking the lists? I would have thought rebuilding...

    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

    August 10, 2010 at 12:43 pm

    #1204982

  • RE: Composite clustered index ordering when inserting

    Grant Fritchey (8/10/2010)

    It's possible that rebuilding an index (but not defragging) could be longer due to page splits at the top of the key, but not a single page split.

    I...

    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

    August 10, 2010 at 12:30 pm

    #1204971

  • RE: Composite clustered index ordering when inserting

    Megistal (8/10/2010)

    Yes but from my understanding, time to perform a page split from a non clustered index <= time spent for a page split from a clustered index.

    If that split...

    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

    August 10, 2010 at 12:23 pm

    #1204963

  • RE: Composite clustered index ordering when inserting

    Maybe worth a read - http://www.sqlservercentral.com/articles/Indexing/68563/

    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

    August 10, 2010 at 12:17 pm

    #1204959

  • RE: Are the posted questions getting worse?

    Luke L (8/10/2010)

    I use Demerara in one of my beers to lighten the body, increase the fermentables (aka alcohol percentage) and to help build a more complex malt backbone....

    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

    August 10, 2010 at 11:52 am

    #1204941

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/10/2010)

    Binged a recipe for Candied Bacon, just need to figure out what Demerara sugar is.

    Soft brown sugar. Don't know what name it goes by in the USA. Fairly...

    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

    August 10, 2010 at 10:51 am

    #1204910

  • RE: View performance

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    August 10, 2010 at 10:07 am

    #1204887

  • RE: WA_sys indexes (Who, where, why???)

    Then someone has manually gone and added indexes matching to auto created stats. SQL will not create indexes automatically. The only thing it creates automatically are statistics and the WA_Sys_*...

    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

    August 10, 2010 at 6:16 am

    #1204694

Viewing 15 posts - 31,321 through 31,335 (of 49,552 total)