Forum Replies Created

Viewing 15 posts - 21,886 through 21,900 (of 49,552 total)

  • RE: Expensive Query and missing indexes

    That's not exactly readable...

    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    December 6, 2011 at 12:26 pm

    #1417616

  • RE: Transaction Log Issue -- Please Help

    Why does it matter?

    If the DB was a restored backup of a database on another server that was replicated, this can happen. If the database uses snapshot replication (or ever...

    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

    December 6, 2011 at 12:26 pm

    #1417615

  • RE: MS Certification

    NM

    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

    December 6, 2011 at 12:20 pm

    #1417612

  • RE: Are the posted questions getting worse?

    LutzM (12/6/2011)

    Changing subject: Does anyone know one of the DBAinSpace finalists?

    There's no name I recognize as one of the Threadizens....

    No one from here. I know Tim and I recognise 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

    December 6, 2011 at 12:16 pm

    #1417608

  • RE: SQL 2008 Logshipping, secondary database issue

    MyDoggieJessie (12/6/2011)

    You ONLY needed to copy and restore the last differential that ran before the next full backup, not all of them. Differentials are cumulative.

    Gail, I have to ask...

    Say...

    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

    December 6, 2011 at 12:15 pm

    #1417607

  • RE: Transaction Log Issue -- Please Help

    Until you get the replication issue resolved (and I've lost count of the number of people here that have had this problem), the log won't shrink and can't be reused...

    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

    December 6, 2011 at 12:14 pm

    #1417605

  • RE: Advantages of Keeping SS2000 Compatibility Mode

    Tom Carnahan (12/6/2011)

    Can anyone think of a reason to keep it in compatibility mode 80 other than not having to look for incompatible features that would have to be found...

    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

    December 6, 2011 at 8:25 am

    #1417418

  • RE: Cannot drop SQL table

    Yes.

    GilaMonster (12/5/2011)

    If you have no clean backups... (and if not, there's something seriously wrong with your maintenance routine)

    Script all objects, export all data, recreate the database

    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

    December 6, 2011 at 8:23 am

    #1417413

  • RE: Are the posted questions getting worse?

    Cadavre (12/6/2011)

    Can someone take over from me here please? I've had enough of trying to draw blood from a stone, maybe I'm phrasing things incorrectly?

    Abandon hope all yea who...

    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

    December 6, 2011 at 8:21 am

    #1417410

  • RE: .net error while opening the database

    First important question - do you have backups?

    Post the contents of the SQL error log, it'll show why the database went recovery_pending.

    To be clear, this is a severe problem...

    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

    December 6, 2011 at 8:17 am

    #1417404

  • RE: Transaction Log Issue -- Please Help

    Jeff Mayer (12/6/2011)

    I tried the option of switching the database to simple mode as recommended in the other post. However, that did not resolve the issue. I have never set...

    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

    December 6, 2011 at 7:58 am

    #1417388

  • RE: best practice or Standards for Maintanance task planing

    It doesn't matter. Either works.

    I prefer checkDB first, I don't want to waste time rebuilding indexes if the database is corrupt. I certainly don't want to back up a corrupt...

    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

    December 6, 2011 at 2:12 am

    #1417153

  • RE: Fragmentation using sys.dm_db_index_physical_stats

    MasterDB (12/6/2011)

    Heap in the sense there is no index created on that table.

    Heap in the sense that there's no clustered index. There can be nonclustered indexes on a heap, it's...

    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

    December 6, 2011 at 2:07 am

    #1417151

  • RE: index column order for a clustered primary key

    p.s. I checked with queries too. A filter on ColB does an index seek and a filter solely on ColA does a scan, so ColB is the leading column of...

    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

    December 6, 2011 at 2:06 am

    #1417149

  • RE: index column order for a clustered primary key

    There's actually nothing wrong here.... (though it certainly appears there is at first, second and 3rd glance)

    The index_column_id doesn't say that it gives the columns in the order that they...

    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

    December 6, 2011 at 2:00 am

    #1417148

Viewing 15 posts - 21,886 through 21,900 (of 49,552 total)