Forum Replies Created

Viewing 15 posts - 15,766 through 15,780 (of 49,552 total)

  • RE: Multiple Instances vs. Multiple DBs on one instance

    It depends. There are good reasons for each alternative and not enough information to say which is better.

    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

    November 7, 2012 at 11:52 pm

    #1557008

  • RE: Include column VS Index Size

    Include columns will increase the size of nonclustered indexes.

    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

    November 7, 2012 at 11:50 pm

    #1557007

  • RE: which one is right?

    sqldba_newbie (11/7/2012)

    The locks are heldup for longer durations, how do i handle that?

    Longer duration than what?

    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

    November 7, 2012 at 11:49 pm

    #1557006

  • RE: Index Rebuilds Still Leave Fragmentation

    Please note: 4 year old thread.

    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

    November 7, 2012 at 11:46 pm

    #1557004

  • RE: Wait Types concern

    Start by posting the query, the index definitions and the execution plan, so that we can see what's happening.

    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

    November 7, 2012 at 9:28 am

    #1556843

  • RE: Database Log File Full - Emergency Work-Around Script

    Lee Crain (11/7/2012)

    Log file full, database in read-only, suspect mode,

    A full log does not send a database suspect.

    If the log file and its disk drive were both full, would the...

    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

    November 7, 2012 at 9:20 am

    #1556840

  • RE: Session CPU Wait times

    What session ids, what wait types?

    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

    November 7, 2012 at 9:10 am

    #1556835

  • RE: Emergency state

    What is the state of the database? (state_desc in sys.databases)

    What happened to cause this?

    What errors are there in the error log?

    Do you have backups?

    Do not detach the DB. Do not...

    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

    November 7, 2012 at 1:35 am

    #1556663

  • RE: Database Log File Full - Emergency Work-Around Script

    Lee Crain (11/6/2012)

    I'm doing my best to recreate a script I read written by Gila Monster (Gail Shaw) when she was recently assisting a DBA who had a database in...

    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

    November 7, 2012 at 12:00 am

    #1556650

  • RE: Blocked Queries

    Yup. There are plenty of waits other than lock waits

    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

    November 6, 2012 at 11:55 pm

    #1556648

  • RE: Rebuild index

    GilaMonster (11/6/2012)

    Unless you have a really good reason otherwise, just look at the fragmentation of the leaf level of the index.

    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

    November 6, 2012 at 7:22 pm

    #1556618

  • RE: Rebuild index

    You're getting different values because sampled only shows the leaf level, detailed shows all levels and the filters you have do not filter out the non-leaf levels, they only filter...

    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

    November 6, 2012 at 6:09 pm

    #1556613

  • RE: Rebuild index

    Doesn't matter whether you use detailed or sampled, but unless you have a really good reason, just look at the fragmentation of the leaf level.

    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

    November 6, 2012 at 5:14 pm

    #1556609

  • RE: Reg: Interview Questions

    So, what do you have so far?

    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

    November 6, 2012 at 5:01 pm

    #1556607

  • RE: Rebuild index

    Unless you have a really good reason otherwise, just look at the fragmentation of the leaf level of the index.

    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

    November 6, 2012 at 4:56 pm

    #1556606

Viewing 15 posts - 15,766 through 15,780 (of 49,552 total)