Forum Replies Created

Viewing 15 posts - 20,146 through 20,160 (of 49,552 total)

  • RE: Reindexing issue on SQL Server 2005 Standard Edition

    L' Eomot Inversé (2/22/2012)

    Maybe another possible alternative is to disable the index and then rebuild it; some queries may time out (because the index isn't available) but nothing will have...

    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

    February 22, 2012 at 11:44 am

    #1450493

  • RE: Are the posted questions getting worse?

    Brick wall. And now I'm honouring promises and decisions that I didn't make. Wonderful.

    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

    February 22, 2012 at 11:36 am

    #1450483

  • RE: Reindexing issue on SQL Server 2005 Standard Edition

    Building an index is the same as rebuilding an index when it comes to locks take, it's creating/recreating the index and it's very much the same under the covers.

    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

    February 22, 2012 at 11:34 am

    #1450479

  • RE: Log-shipping .. interesting question

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1256152-1550-1.aspx

    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

    February 22, 2012 at 10:52 am

    #1450453

  • RE: T-log is failing

    Yes, but this is something better done while the DB is idle.

    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

    February 22, 2012 at 8:41 am

    #1450363

  • RE: Are the posted questions getting worse?

    Jack Corbett (2/22/2012)

    GilaMonster (2/22/2012)

    Question for those of you who have organised SQLSaturdays

    Would you have been irritated if your regional mentor or an organiser of another SQL Sat 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

    February 22, 2012 at 8:12 am

    #1450327

  • RE: Reindexing issue on SQL Server 2005 Standard Edition

    WayneS (2/22/2012)

    GilaMonster (2/22/2012)

    WayneS (2/22/2012)

    I've thought about running each index to be re-indexed through SQLCMD, and then aborting it after a period of time (say, 30 seconds). This would let some...

    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

    February 22, 2012 at 7:51 am

    #1450305

  • RE: Encrypt database backup set

    TDE or a 3rd party backup tool.

    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

    February 22, 2012 at 7:31 am

    #1450283

  • RE: Are the posted questions getting worse?

    Question for those of you who have organised SQLSaturdays

    Would you have been irritated if your regional mentor or an organiser of another SQL Sat in the same area had started...

    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

    February 22, 2012 at 7:30 am

    #1450280

  • RE: Finding TableNames and Column Names in storedProcedure.

    Did you try the DMV I suggested?

    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

    February 22, 2012 at 7:28 am

    #1450275

  • RE: Reindexing issue on SQL Server 2005 Standard Edition

    WayneS (2/22/2012)

    I've thought about running each index to be re-indexed through SQLCMD, and then aborting it after a period of time (say, 30 seconds). This would let some pages get...

    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

    February 22, 2012 at 7:17 am

    #1450264

  • RE: Index rebuilds/reorgs - identifying tables with LOBs

    That's why you should be using Ola's (or Michelle Ulfort) scripts as they do not rebuild everything (maint plans 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

    February 22, 2012 at 6:59 am

    #1450248

  • RE: SQL 2005 64 bit Consuming RAM Rapidly (Please Help)

    SQL will not page to disk when locked pages is enabled. Locked pages means DO NOT swap memory into the page file.

    Are you absolutely, 100% sure that it's SQL paging...

    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

    February 22, 2012 at 6:58 am

    #1450244

  • RE: Transaction log backup, tempdb negative space?

    If TempDB is reaching 20GB then it needs to be 20GB for the workload on the server. Your options are to increase drive space, add a second tempDB file 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

    February 22, 2012 at 6:47 am

    #1450235

  • RE: taking more wait time

    What that little information, I can't offer you any help, any advice.

    For general slow query troubleshooting, try these

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    February 22, 2012 at 6:45 am

    #1450232

Viewing 15 posts - 20,146 through 20,160 (of 49,552 total)