Forum Replies Created

Viewing 15 posts - 17,236 through 17,250 (of 49,552 total)

  • RE: Tran log does not get truncated in simple recovery

    Jeff Kelly-310227 (8/10/2012)

    The quick (hack/non proper way) way to solve this in the past for me has been to flip to full, backup db to nul, backup log to nul,...

    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, 2012 at 12:13 pm

    #1524599

  • RE: much worse execution plan calling stored procedure vs. query window

    Could you post the plans please (as .sqlplan files)?

    It's almost certainly a form of parameter sniffing (the optimiser can sniff the parameter values in the procedure, but it cannot...

    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, 2012 at 11:55 am

    #1524590

  • RE: Index Fragmentation and Performance

    pooyan_pdm (8/8/2012)

    And about the update I don't know what you think of a index key update but it' effects on page splits and fragmentation is the same as another...

    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, 2012 at 11:44 am

    #1524581

  • RE: How to shrink data file in sql server 2005

    Monte Kottman (8/10/2012)

    I think there is a bit of confusion between Shrink Database and Shrink Files.

    Shrink Database reorganizes the tables, indexes et al., and is VERY BAD for organization as...

    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, 2012 at 11:41 am

    #1524577

  • RE: Tran log does not get truncated in simple recovery

    Jeff Kelly-310227 (8/10/2012)

    in those cases, when i really don't care about restore ability at all I backup to nul 🙂

    backup database/log x to disk = 'NUL'

    Rather just switch to simple...

    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, 2012 at 11:33 am

    #1524574

  • RE: Tran log does not get truncated in simple recovery

    There is never any need to switch to full recovery to manage the log. All switching to full does is add extra requirements before the log can be reused 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

    August 10, 2012 at 11:31 am

    #1524571

  • RE: AppDomain 12 (mssqlsystemresource.dbo[runtime].11) is marked for unload due to memory pressure.

    32 bit or 64 bit SQL?

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

    #1524450

  • RE: Tempdb log file location and Filegroup optimizations

    GSquared (8/10/2012)

    All I asserted is that multiple I/O channels is best, if tempdb optimization is needed. I don't get why that's being disagreed with.

    Late, and I have not read...

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

    #1524443

  • RE: Log file shrinking

    Ratheesh.K.Nair (8/10/2012)

    As far as i know chunks less than 64MB = 4 VLFs so for first 10MB it will create 4VLF and if i add 40MB what will happen? will...

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

    #1524400

  • RE: Log file shrinking

    VLFs, once created, are never expanded or shrunk in any way.

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

    #1524388

  • RE: Memory utilization issue

    Chapters 3 and 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

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

    #1524370

  • RE: Log file shrinking

    A log file must always have at least 2 VLFs. Also, log records can never be moved, so a log cannot be shrunk past the last active VLF in 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

    August 10, 2012 at 5:58 am

    #1524368

  • RE: Sys.Table error

    ESAT ERKEC (8/9/2012)

    How can i merge production db and backup in sys.objects ?

    You can't merge a database and a backup

    If the backup is clean, restore it as another name 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

    August 10, 2012 at 5:56 am

    #1524366

  • RE: Sys.Table error

    Lynn Pettis (8/9/2012)

    ESAT ERKEC (8/9/2012)

    This is the solution but i am going to try it

    http://sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Using-the-SQL-2005-Dedicated-Admin-Connection-to-fix-Msg-8992-corrupt-system-tables.aspx

    Why wouldn't a restore of the database solve the problem? As long as the corruption...

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

    #1524364

  • RE: Update index stats on 1 table fixed performance problem?

    Lowell (8/9/2012)

    I thought sysindexes is deprecated.

    and that made sys.sysindexes the replacement?

    sysindexes (or fully qualified sys.sysindexes) is deprecated.

    The replacement is sys.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

    August 10, 2012 at 5:51 am

    #1524362

Viewing 15 posts - 17,236 through 17,250 (of 49,552 total)