Forum Replies Created

Viewing 15 posts - 26,356 through 26,370 (of 49,552 total)

  • RE: Alternative to DBCC INPUTBUFFER/sys.dm_exec_sql_text? (new sp_who proc)

    <grrrr> 3 year old thread.

    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

    May 3, 2011 at 7:24 am

    #1319055

  • RE: Is this a good backup strategy?

    Raymond van Laake (5/3/2011)

    If disaster happens at 12:45, I have to restore the last full backup, then the last differential backup, then the last transaction log backups, right?

    Last 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

    May 3, 2011 at 7:05 am

    #1319035

  • RE: Waits issues

    Eddie Wuerch (5/2/2011)

    Looks like you're rebuilding an index, or performing other index-modification work. You'll get lots of page latching on metadata pages (mostly the GAM) as the process allocates new...

    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

    May 3, 2011 at 7:04 am

    #1319032

  • RE: The multi-part identifier "#StagingA.Number " could not be bound.

    Because the table #StagingA is defined nowhere in your query.

    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

    May 3, 2011 at 6:39 am

    #1319006

  • RE: hash join

    If the optimiser has decided on a hash join, it's because it's the cheapest join for the number of rows involved..

    Merge doesn't parallel well (iirc) and your query is running...

    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

    May 3, 2011 at 6:21 am

    #1319002

  • RE: Index creation in a huge table

    Run CheckDB (not checkTable) with the options I specified, NOT with physical_only. There's corruption and we need a full list of everything damaged before we can plan a solution.

    What recovery...

    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

    May 3, 2011 at 6:19 am

    #1319001

  • RE: Index creation in a huge table

    Error 5242: An inconsistency was detected during an internal operation in database <database name> on page <Page Number>. Please contact technical support.

    Have you run that checkDB as asked?

    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

    May 3, 2011 at 5:46 am

    #1318983

  • RE: hash join

    Hash joins are the best join type for really huge resultsets. They parallel the best of any of the join types.

    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

    May 3, 2011 at 5:43 am

    #1318980

  • RE: Urgent plz Problem with with(Nolock)

    Nolock allows duplicate reads if the underlying table is changing. That's one of the risks you accept by chosing to use Nolock.

    If you want consistent data without blocking, consider using...

    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

    May 3, 2011 at 4:32 am

    #1318961

  • RE: Index creation in a huge table

    That error can indicate corruption. Please run the following and post any results.

    DBCC CheckDB(<Database name>) WITH No_INFOMSGS, ALL_ERRORMSGS

    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

    May 3, 2011 at 4:31 am

    #1318958

  • RE: CHECKDB hanging after a "logical consistency-based I/O error: incorrect checksum" error

    In full recovery you could restore single files. In simple, no.

    Can you restore the backup to a dev/test server and run checkDB on it? If it's also corrupt, there's big...

    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

    May 3, 2011 at 4:29 am

    #1318956

  • RE: CHECKDB hanging after a "logical consistency-based I/O error: incorrect checksum" error

    Wait. If you need the results from checkDB, then you must wait for them.

    Is the backup clean or does it also contain the corruption?

    Can you restore the backup (assuming 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

    May 3, 2011 at 3:39 am

    #1318944

  • RE: hash join

    The indexes probably aren't covering. With no filter conditions, SQL has to scan either the index or the table. I'll only scan the indexes if they are covering (otherwise too...

    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

    May 3, 2011 at 3:37 am

    #1318943

  • RE: Index Rebuilding

    SQL needs space for the new index.

    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

    May 3, 2011 at 2:48 am

    #1318930

  • RE: Sudden Increase in Database Size

    Did an index rebuild job run around that time?

    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

    May 3, 2011 at 2:25 am

    #1318924

Viewing 15 posts - 26,356 through 26,370 (of 49,552 total)