Forum Replies Created

Viewing 15 posts - 25,141 through 25,155 (of 49,552 total)

  • RE: Reduce size of mdf file.

    Ol'SureHand (7/5/2011)

    - What is this database Recovery Model? Is it (or can you change it to) SIMPLE? (ask first).

    If it isn't, you have a few other issues to sort...

    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

    July 6, 2011 at 3:31 am

    #1348809

  • RE: Can we take it to another level, please?

    Thank you for your understanding. I must admit when I read this I thought it was going to turn into another 'scream at Steve cause he doesn't do things 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

    July 6, 2011 at 2:22 am

    #1348794

  • RE: Rebuilding indexes on SQL Server 2005

    Please don't post the same question in multiple places. It just wastes people's time as they answer questions already answered.

    Replies to Mohan's question to this thread please: http://www.sqlservercentral.com/Forums/Topic1137066-146-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

    July 6, 2011 at 2:02 am

    #1348786

  • RE: dbcc to recover corrupt pages

    http://www.sqlskills.com/blogs/paul/category/CHECKDB-From-Every-Angle.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

    July 6, 2011 at 1:59 am

    #1348785

  • RE: Cannot take a database offline

    A database cannot be taken offline if there are still open connections to it. Either kill all connections to that DB first or use the ROLLBACK IMMEDIATE clause of ALTER...

    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

    July 6, 2011 at 1:39 am

    #1348779

  • RE: Data Corruption...

    You can run CheckDB with Repair_Allow_Data_Loss, but you will lose a fair amount of information in a number of tables including crmis_HitTracker and crmis_CreditLicenseHistroy, crm_EventLog, crm_UserProfile

    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

    July 6, 2011 at 1:26 am

    #1348775

  • RE: dbcc to recover corrupt pages

    No. Corrupt means unreadable, damaged, useless. DBCC CheckDB will deallocate those pages. There's no way to recover something that's been overwritten with garbage (common 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

    July 6, 2011 at 1:22 am

    #1348774

  • RE: Recovery Mode Change

    anil_kumar32 (7/6/2011)

    The advantage which comes Bulk logged recovery model is log fie size grow much slower than Full recovery model.

    The only time the log grows slower in bulk-logged is when...

    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

    July 6, 2011 at 1:19 am

    #1348771

  • RE: Resourcedb vs systems databases

    anil_kumar32 (7/5/2011)

    System databases for SQL Server 2005 includes master tempdb, msdb and model databases.you might have noticed that there is no resource databse in SQL Server 2005 as all 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

    July 6, 2011 at 1:18 am

    #1348770

  • RE: What happens to SQL Server when we shut down/Start Windows..?

    Sure. Completely safe. So is just shutting down windows without first stopping SQL. SQL will recover, it guarantees that.

    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

    July 6, 2011 at 1:01 am

    #1348763

  • RE: Reset Identity Key without using CHECKIDENT

    Pedantic....

    😉 😀

    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

    July 5, 2011 at 4:51 pm

    #1348670

  • RE: Reset Identity Key without using CHECKIDENT

    Truncate instead of delete will set the identity back to 0.

    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

    July 5, 2011 at 4:35 pm

    #1348659

  • RE: Can we take it to another level, please?

    Ninja's_RGR'us (7/5/2011)

    Deys?

    Wow, I never noticed that in reverse his name spells DIES. Maybe that's our version of the anti-christ (nor trying to start a religious war or anything!).

    Never seen...

    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

    July 5, 2011 at 4:34 pm

    #1348657

  • RE: Can we take it to another level, please?

    Winston Daley-344648 (7/5/2011)

    Perhaps what you're looking at is the point in your evolution as an SQL DBA where you need to move from "learning by asking/reading" and start moving towards...

    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

    July 5, 2011 at 4:28 pm

    #1348653

  • RE: Can we take it to another level, please?

    Craig Farrell (7/5/2011)

    [ There always seems to be one of those jokers hiding in the forum behind every high end article I've seen so far.

    And half the QotD discussions 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

    July 5, 2011 at 3:53 pm

    #1348633

Viewing 15 posts - 25,141 through 25,155 (of 49,552 total)