Forum Replies Created

Viewing 15 posts - 36,526 through 36,540 (of 49,552 total)

  • RE: Sa

    Schadenfreude-Mei (9/8/2009)

    If you have forgotten the SA password and dont have any other SysAdmins, I'm not sure what you can do, other then rebuild. Its not a large production system...

    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

    September 8, 2009 at 6:37 am

    #1050454

  • RE: restoring a database page. whats the process

    Paul White (9/8/2009)

    I thought you were asking what to do if you received the DBCC message after restoring the database from the backups."

    You know, I've had that once, and 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

    September 8, 2009 at 6:36 am

    #1050452

  • RE: Table Fragmenting and I cant figure out why.

    MrT-SQL (9/8/2009)

    In answer to your question Gail, no it is not turned on. Sorry for the delay in getting back to you.

    Is there a shrink job? A shrink operation...

    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

    September 8, 2009 at 5:41 am

    #1050421

  • RE: Sa

    Is the SQL service running? The error suggests that it is 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

    September 8, 2009 at 5:25 am

    #1050409

  • RE: Trying to attach MDF from 2000 to 2008. Corrupt LDF message

    That technique is valid on SQL 2000 only. It cannot be done on 2005 or 2008 since the system tables are not updatable any longer and sysdatabases is not 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

    September 8, 2009 at 5:20 am

    #1050406

  • RE: Table Fragmenting and I cant figure out why.

    sureshr69 (9/8/2009)

    Basically any index with fillfactor 0 or 100 makes no difference. In such case every new record insert will create a new page.

    Huh?

    An insert into a full...

    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

    September 8, 2009 at 5:17 am

    #1050403

  • RE: restoring a database page. whats the process

    Paul White (9/8/2009)

    GilaMonster (9/8/2009)

    Yes, there's a slim chance and there's nothing wrong with doing a checktable after each log restore but to say "you know that the corruption occurs somewhere...

    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

    September 8, 2009 at 5:16 am

    #1050401

  • RE: Table Fragmenting and I cant figure out why.

    Is autoshrink on? Is there a manual shrink operation occurring?

    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

    September 8, 2009 at 4:10 am

    #1050383

  • RE: restoring a database page. whats the process

    Paul White (9/8/2009)

    So, you are saying there are absolutely no circumstances where SQL Server can directly cause page corruption in its files? The word 'usually' suggests not - 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

    September 8, 2009 at 3:56 am

    #1050377

  • RE: Are the posted questions getting worse?

    Only in South Africa - http://pigeonrace2009.co.za/pigeon-race-2009

    My money's on the pigeon.

    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

    September 8, 2009 at 3:41 am

    #1050368

  • RE: restoring a database page. whats the process

    Paul White (9/8/2009)

    GilaMonster (9/8/2009)

    Paul White (9/8/2009)

    If no errors are reported after a stage, you know that the corruption occurs somewhere in the following log restores.

    Log backups generally will only have...

    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

    September 8, 2009 at 3:12 am

    #1050360

  • RE: Unique Index Causing Slow Read Performance

    ben.mcintyre (9/8/2009)

    I badly need my views here. Due to the size of the data chunks I'm dealing with I have to wrap them in views to stay sane. ...

    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

    September 8, 2009 at 3:03 am

    #1050356

  • RE: Viewing Execution Plan

    Highlight the query and click the 'Display estimated execution plan' button on the toolbar, or select 'Display estimated execution plan' from the query menu, or press Ctrl-L

    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

    September 8, 2009 at 2:58 am

    #1050350

  • RE: restoring a database page. whats the process

    Paul White (9/8/2009)

    If no errors are reported after a stage, you know that the corruption occurs somewhere in the following log restores.

    Log backups generally will only have corruption in them...

    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

    September 8, 2009 at 2:54 am

    #1050347

  • RE: restoring a database page. whats the process

    All restores (single page, file or full) have to start from a full backup. For full details of restoring a page, see http://msdn.microsoft.com/en-us/library/ms186858(SQL.90).aspx and http://msdn.microsoft.com/en-us/library/ms175168%28SQL.90%29.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

    September 8, 2009 at 1:03 am

    #1050329

Viewing 15 posts - 36,526 through 36,540 (of 49,552 total)