Forum Replies Created

Viewing 15 posts - 25,021 through 25,035 (of 49,552 total)

  • RE: Tables in database files - mdf, ndf

    Are they all in the same filegroup or are they in separate filegroups?

    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 8, 2011 at 12:15 pm

    #1350573

  • RE: Space Management - why won't DBCC Shrinkfile work?

    That said, are you sure you should be shrinking at all?

    Unless the log grew very large as a product of some unusual operation, the size that it is is 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 8, 2011 at 11:59 am

    #1350567

  • RE: Space Management - why won't DBCC Shrinkfile work?

    JamesMorrison (7/8/2011)

    If that still fails, detach the database, then rename the .LDF file.

    Then reattached the .MDF file, but remove the .LDF file from the process. Force SQL Server 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

    July 8, 2011 at 11:53 am

    #1350558

  • RE: Are the posted questions getting worse?

    Craig Farrell (7/8/2011)Saturday's article: Why some DBAs are Nincompoops. Sunday's article: Retraction of previous article with editing: Why ALL DBAs are Nincompoops.

    Monday's article: Why some clients need 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

    July 8, 2011 at 11:47 am

    #1350553

  • RE: Checkdb error

    Most common - problems with the IO subsystem. Could be drivers, firmware, filter drivers, switch, SAN controller, disks, etc

    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 8, 2011 at 10:41 am

    #1350505

  • RE: Are the posted questions getting worse?

    SQLRNNR (7/8/2011)

    GilaMonster (7/8/2011)

    Steve Jones - SSC Editor (7/8/2011)

    SQLRNNR (7/8/2011)

    SQLkiwi (7/8/2011)

    Steve Jones - SSC Editor (7/8/2011)

    Behave.

    Badly?

    Think much much worse than that 😀

    Umm, should I disable a few accounts today?

    Please. A week...

    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 8, 2011 at 10:25 am

    #1350497

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/8/2011)

    SQLRNNR (7/8/2011)

    SQLkiwi (7/8/2011)

    Steve Jones - SSC Editor (7/8/2011)

    Behave.

    Badly?

    Think much much worse than that 😀

    Umm, should I disable a few accounts today?

    Please. A week of not...

    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 8, 2011 at 10:20 am

    #1350491

  • RE: Database in Suspect Mode

    Short answer: Portions of the database file were zero'd out. Maybe due to the software, maybe due to a faulty IO subsystem. Can't be sure.

    I would suggest some diagnostics 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

    July 8, 2011 at 10:12 am

    #1350479

  • RE: Checkdb error

    Got a clean backup?

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

    #1350474

  • RE: database snapshot

    When you create the snapshot nothing happens (well, almost nothing). No data is copied to it.

    When a change is made in the source database, the old version of the page...

    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 8, 2011 at 9:10 am

    #1350406

  • RE: Shrinking Log file on a database which uses log shipping

    Log backups mark the space within the log as reusable. The restore on the secondary is irrelevant, it's the backup of the log that does that.

    Please read through this -...

    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 8, 2011 at 8:41 am

    #1350388

  • RE: Shrinking Log file on a database which uses log shipping

    Doesn't change a single thing that I said.

    Run the log backups all day. 15 min is a common frequency. Don't shrink on a regular basis. The log, if managed correctly,...

    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 8, 2011 at 8:37 am

    #1350384

  • RE: Reorganize Very Large Index

    Reorganise, yes, rebuild, no

    However if it's very fragmented reorganise may not work well, may take huge amounts of time or log. Can you do an online rebuild?

    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 8, 2011 at 7:56 am

    #1350364

  • RE: DISABLE - TRUNCATE - REBUILD vs DROP - TRUNCATE - CREATE for Indexes

    The same.

    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 8, 2011 at 7:45 am

    #1350357

  • RE: Shrinking Log file on a database which uses log shipping

    Shrinking should be done in exceptional circumstances, not on a regular basis. All that regular shrinks will do is hinder overall performance as the log will have to grow...

    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 8, 2011 at 7:45 am

    #1350356

Viewing 15 posts - 25,021 through 25,035 (of 49,552 total)