Forum Replies Created

Viewing 15 posts - 20,401 through 20,415 (of 49,552 total)

  • RE: Please critique our SQL Server 2005 Backup Maintenance Plan

    Grant Fritchey (2/10/2012)

    I just started working on an article on the backup header...

    Oh good. Saves me from writing one.

    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 10, 2012 at 8:06 am

    #1445585

  • RE: sp_configure 'Allow updates', 1 DOES NOT WORK

    Nope, system tables can't be modified in SQL 2008.

    The way to drop extended properties is with

    EXEC sp_dropextendedproperty.

    The details of what the property name is and the objects its...

    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 10, 2012 at 6:08 am

    #1445501

  • RE: Application error

    That depends on what data access library you are using.

    Once more, what's the error?

    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 10, 2012 at 5:48 am

    #1445490

  • RE: Sql Server profiler..

    Not sure I understand what you're asking.

    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 10, 2012 at 5:48 am

    #1445489

  • RE: Application error

    What's the error?

    And please tell me that you did not post a real password to a public site?

    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 10, 2012 at 5:00 am

    #1445467

  • RE: DBCC CheckDB

    Draelith (2/9/2012)

    It was giving me the little red squiggly lines...

    Edit -> Intellisense -> Refresh Local 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

    February 10, 2012 at 4:30 am

    #1445455

  • RE: What are the logical Reads what they really Mean!!!!

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1250154-391-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 10, 2012 at 4:27 am

    #1445454

  • RE: SQL Server Logical/Physical Reads!!!!

    Is there a question here?

    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 10, 2012 at 4:22 am

    #1445451

  • RE: Transaction log backup failed message

    Please post new questions in a new thread and include as much detail as possible. Thanks

    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 10, 2012 at 4:19 am

    #1445447

  • RE: SQL server memory....

    sqlzealot-81 (2/9/2012)

    GilaMonster (2/9/2012)

    I should also add that in the cases where there's other apps on the server (SSIS, IIS, etc) you'd probably want to reduce the max server memory..

    Okei, 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

    February 10, 2012 at 4:18 am

    #1445446

  • RE: A big INSERT INTO statement and rolling it back

    The log would have to be large enough to accommodate the log records for the insert. If the log was not big enough, it would have to grow. If it...

    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 9, 2012 at 11:00 pm

    #1445376

  • RE: Index consolidation techniques

    These might get you started

    http://www.sqlskills.com/BLOGS/KIMBERLY/post/RemovingDuplicateIndexes.aspx

    http://www.sqlskills.com/BLOGS/KIMBERLY/post/UnderstandingDuplicateIndexes.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 9, 2012 at 3:44 pm

    #1445340

  • RE: Managing Transactions question

    Jack Corbett (2/9/2012)

    The only comment I'd have is that your check for availability is outside the transaction, so in theory you could have another session create a conflicting...

    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 9, 2012 at 3:04 pm

    #1445329

  • RE: PERFORMANCE Tuning

    You cannot draw meaningful comparisons or conclusions with that little data.

    4 pages and 0 ms of CPU time. 10ms difference in elapsed time is well within the measuring inaccuracy...

    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 9, 2012 at 2:42 pm

    #1445316

  • RE: How long does it take to turn on Data Compression on a 300GB table

    Kim Killian-SiteDataView (2/9/2012)

    I'm going for the entire table and Index at the page level.

    Cluster and nonclustered? You've tested and ensured that the CPU overhead of page compression is acceptable and...

    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 9, 2012 at 2:36 pm

    #1445313

Viewing 15 posts - 20,401 through 20,415 (of 49,552 total)