Forum Replies Created

Viewing 15 posts - 27,961 through 27,975 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (2/3/2011)

    GSquared (2/3/2011)

    GilaMonster (2/2/2011)

    Jason, Gus, Brandie, Wayne and Stefan. How do you want to be credited in tran log article? Blog link? twitter handle? Both? Neither? something else?

    Please let...

    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 3, 2011 at 9:12 am

    #1281979

  • RE: Using INDEX HINTS in SP to reduce KEY LOCKS ?

    Latches are not locks. Nolock (which quite honestly you shouldn't be using unless you're happy with the side effects) stops shared locks, nothing else.

    Latch_ex is not even related to tables...

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

    #1281937

  • RE: dbcc check db errors

    Markus (2/3/2011)

    Great link, however, if I follow the link and attempt to do it it won't work because the index is on a system table and when you try 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

    February 3, 2011 at 8:19 am

    #1281933

  • RE: dbcc check db errors

    Repair won't touch the system tables. Fortunately there a solution that might work.

    http://sqlinthewild.co.za/index.php/2009/08/24/stats-blob-corruptions/

    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 3, 2011 at 7:48 am

    #1281907

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (2/3/2011)

    Let see what happens in response to my last post http://www.sqlservercentral.com/Forums/FindPost1058024.aspx at time of writing , see if we can turn this thing around 🙂

    Errr, let me think......

    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 3, 2011 at 6:50 am

    #1281882

  • RE: Recover SQL server 2008 database

    And the messages in the error log please.

    Don't worry about the names of the files. That's hardly a concern at this point.

    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 3, 2011 at 6:48 am

    #1281881

  • RE: Trying to create new database from restore.

    That's the right syntax, almost.

    The WITH MOVE must reference the logical name of the file, the name that it's referred to in SQL, not the name of the file in...

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

    #1281879

  • RE: Are the posted questions getting worse?

    mazzz (2/3/2011)

    s/he's dissed another poster's spelling now. In the words of the people from Teh Interwebz: "wat?"

    Oooh, apparently I'm not worth $1. Hope my current client doesn't see that, I'm...

    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 3, 2011 at 5:22 am

    #1281835

  • RE: Recover SQL server 2008 database

    Shut down SQL, delete the log file, restart SQL.

    Once SQL starts, check the state of the database in question (select name, state_desc from sys.databases), and any errors in the error...

    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 3, 2011 at 5:21 am

    #1281834

  • RE: Set database to Read Only alters order of pk index?

    The technical reason is that once the DB is read only, there's no need to worry about pages changing underneath the query, so an allocation order scan can be 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

    February 3, 2011 at 5:19 am

    #1281830

  • RE: Using INDEX HINTS in SP to reduce KEY LOCKS ?

    Be careful of DTA. It over-recommends, it's not always right. Test any recommendation and don't hesitate to ignore any that don't help.

    If you have RID appearing anywhere it means 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

    February 3, 2011 at 4:11 am

    #1281806

  • RE: Are the posted questions getting worse?

    Tom Brown (2/3/2011)

    [There is a "Report" button I always wondered why then when phrases the like of which this pet troll uses appear directed at our well known 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

    February 3, 2011 at 4:09 am

    #1281802

  • RE: LDF file growth

    Great, now make sure that you're running those tran log backups regularly.

    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 3, 2011 at 3:07 am

    #1281780

  • RE: Recover SQL server 2008 database

    lordmwesh (2/3/2011)

    Log file 'G:\test\Training_log.LDF' does not match the primary file. It may be from a different database or the log may have been rebuilt previously. (Microsoft SQL Server, Error:...

    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 3, 2011 at 3:07 am

    #1281779

  • RE: Using INDEX HINTS in SP to reduce KEY LOCKS ?

    Optimiser? Database tuning adviser?

    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 3, 2011 at 3:05 am

    #1281778

Viewing 15 posts - 27,961 through 27,975 (of 49,552 total)