Forum Replies Created

Viewing 15 posts - 11,266 through 11,280 (of 49,552 total)

  • RE: Recovery senarios

    jonysuise (10/18/2013)

    Thanks GilaMonster, my post is of course applicable only during extreme emergencies. 😀

    Except it's worse advice for extreme emergencies. You're advocating taking actions that can have consequences without any...

    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

    October 18, 2013 at 1:19 pm

    #1659845

  • RE: Recovery senarios

    jonysuise (10/18/2013)

    If you run out of space and sql server becomes unresponsive, switch the database’s recovery model to simple . This empties out the transaction log, and then run...

    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

    October 18, 2013 at 12:55 pm

    #1659836

  • RE: SQL Server-Table having 40 Billion Records

    Why are you retrieving hundreds of millions of rows? What are you going to do with them?

    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

    October 18, 2013 at 8:31 am

    #1659739

  • RE: Recovery senarios

    I certainly hope you don't run the log backups without truncating the log, if you really do, you'll be running out of disk space very shortly. Log backups are supposed...

    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

    October 18, 2013 at 8:27 am

    #1659736

  • RE: Are the posted questions getting worse?

    Koen, you are awesome. 🙂

    Koen Verbeeck (10/18/2013)

    hoseam (10/18/2013)

    I don't have a backup

    Sorry to hear that.

    Let this be an incentive to implement a backup plan.

    :hehe:

    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

    October 18, 2013 at 8:20 am

    #1659732

  • RE: Log space issue

    The same command you specified in your initial post works fine. Monitor on a regular basis for a couple of weeks, see how big the log needs to be, then...

    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

    October 18, 2013 at 8:18 am

    #1659731

  • RE: How to undo Drop Table Statement

    Fetch your latest backup, restore it as a new database, generate the table definition, execute it on the original database, copy the data over.

    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

    October 18, 2013 at 6:23 am

    #1659670

  • RE: Log space issue

    Monitor the log usage for a couple of weeks (especially after maintenance). See from that how large the log needs to be to support the app. Shrink the log to...

    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

    October 18, 2013 at 4:45 am

    #1659638

  • RE: BIG Execution plan from DELETE !!

    3)

    Show me a database with integrity enforced by the application, I'll show you bad data in 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

    October 18, 2013 at 4:41 am

    #1659634

  • RE: BIG Execution plan from DELETE !!

    Foreign key checks, to see if any rows reference this one and hence this one can't be deleted.

    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

    October 17, 2013 at 9:43 pm

    #1659549

  • RE: Are the posted questions getting worse?

    rodjkidd (10/17/2013)

    There were maybe six people in cloaks, our very own Wayne was one.

    Paul brimmel, Robert Davis and Argines fernandez also saw.

    Jason, Wayne, Argenis, Denny are the ones I know.

    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

    October 17, 2013 at 9:41 pm

    #1659548

  • RE: Are the posted questions getting worse?

    I wasn't around for the flash mob, but that didn't stop Argenis and I having a repeat performance a little later

    https://plus.google.com/photos?pid=5935932615867871922&oid=114437370872037465059

    If the URL doesn't work, I'll upload it separately.

    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

    October 17, 2013 at 9:40 pm

    #1659547

  • RE: Interesting DBCC CHECKDB Error - found 1 allocation errors and 0 consistency errors not associated with any single object.

    CapnHector (10/16/2013)

    EDIT: After looking at it some more it really looks like this IAM page is not tracking any allocated space since there are no single page allocations 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

    October 17, 2013 at 12:21 pm

    #1659452

  • RE: In SQL 2008 R2, does Database Mirroring allow you to persist a compressed object to the target Mirror?

    A mirror is an exact copy of the principal database in very 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

    October 17, 2013 at 12:19 pm

    #1659450

  • RE: Interesting DBCC CHECKDB Error - found 1 allocation errors and 0 consistency errors not associated with any single object.

    CapnHector (10/16/2013)

    What is perplexing me on the error message is that object ID 0 and index ID -1 make no sense as the objects do not exist (unless they are...

    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

    October 17, 2013 at 9:12 am

    #1659374

Viewing 15 posts - 11,266 through 11,280 (of 49,552 total)