Forum Replies Created

Viewing 15 posts - 33,811 through 33,825 (of 49,552 total)

  • RE: Database set to Full Recovery Model, but very small Transaction Log file

    Neil Thomas (2/25/2010)

    It's supposed to have been backed up as part of a system backup (hence somebodies decision not to take SQL backups) but that hasn't happened for a while.

    A...

    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 25, 2010 at 12:19 pm

    #1125162

  • RE: Need SQL Statement To Increment A Column Sequen. In A Group

    Switch it to compatibility mode 90?

    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 25, 2010 at 12:17 pm

    #1125161

  • RE: Need SQL Statement To Increment A Column Sequen. In A Group

    SELECT Department, ROW_NUMBER() OVER (Partition By Department Order By department) AS DeptSeq

    FROM

    Departments

    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 25, 2010 at 10:40 am

    #1125109

  • RE: SQL Guru Help: Does “Clustered Index Scan” scan the intermediate pages? Why?

    Not by much, I really doubt it's a measurable amount. There aren't that many intermediate pages in an index.

    I would guess that reading the intermediates also lets 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

    February 25, 2010 at 9:11 am

    #1125050

  • RE: kINDLY HELP ME MY SQL2005 DB GOT CORRUPTED

    Jack Corbett (2/25/2010)

    I actually found a solution on another forum site that suggested making changes to the system tables. No way was I going to suggest that since I'd...

    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 25, 2010 at 7:44 am

    #1124990

  • RE: Database Corruption Problem with CheckDB results - How bad is it?

    Paul Randal (2/25/2010)

    I really need to get around to writing a really detailed, comprehensive guide to corruption - nothing out there right now.

    I wait with anticipation... 😀

    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 25, 2010 at 7:41 am

    #1124987

  • RE: SQL Guru Help: Does “Clustered Index Scan” scan the intermediate pages? Why?

    Gee, impatient are we....? This is a forum, not a chatroom. Asking a rather complex question and then bumping it after less than 4 hours is really not called for....

    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 25, 2010 at 7:40 am

    #1124986

  • RE: kINDLY HELP ME MY SQL2005 DB GOT CORRUPTED

    Jack Corbett (2/25/2010)

    GilaMonster (2/25/2010)

    Jack Corbett (2/25/2010)

    What does checkdb recommend for a repair level?

    None. Those errors are not repairable.

    Then hopefully there are good backups.

    I doubt there will be. This looks...

    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 25, 2010 at 7:35 am

    #1124982

  • RE: kINDLY HELP ME MY SQL2005 DB GOT CORRUPTED

    I can tell you how to fix this, but you are not going to like it.

    I am going to guess here that this is a database upgraded from SQL 2000....

    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 25, 2010 at 7:33 am

    #1124978

  • RE: kINDLY HELP ME MY SQL2005 DB GOT CORRUPTED

    Jack Corbett (2/25/2010)

    What does checkdb recommend for a repair level?

    None. Those errors are not repairable.

    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 25, 2010 at 7:31 am

    #1124976

  • RE: Switching recovery models

    Casper101 (2/25/2010)

    During my index rebuild, some DB's log files grow really big. I have been advised to switch the recovery model to BULK_LOGGED before the rebuild, and then back...

    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 25, 2010 at 7:28 am

    #1124973

  • RE: Database set to Full Recovery Model, but very small Transaction Log file

    BrainDonor (2/25/2010)

    A little bit of testing shows that it takes the recovery model from the 'model' db (oddly enough).

    Why oddly? That's what the model database is, a model for...

    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 25, 2010 at 7:25 am

    #1124970

  • RE: Database set to Full Recovery Model, but very small Transaction Log file

    Neil Thomas (2/25/2010)

    Hundreds of rows of data are written to one specific table in the database, but I can't work out why the transaction log isn't filling. Can anyone shed...

    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 25, 2010 at 7:23 am

    #1124967

  • RE: Database Corruption Problem with CheckDB results - How bad is it?

    Paul Randal (2/25/2010)

    For the page latch message - when the final PFS page at the end of the file is damaged (which could be the case here), I couldn't tell...

    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 25, 2010 at 7:19 am

    #1124959

  • RE: density values too high

    ananda.murugesan (2/24/2010)

    In SQL SERVER By default auto update enabled in this database, why agian create another Update statistics?

    Because sometimes autoupdate doesn't update often enough

    Could you tell me, Update statistics jobs,...

    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 25, 2010 at 12:20 am

    #1124771

Viewing 15 posts - 33,811 through 33,825 (of 49,552 total)