Forum Replies Created

Viewing 15 posts - 44,401 through 44,415 (of 49,552 total)

  • RE: Huge Dump files are created in LOG folder SUDDENLY

    You may want to contact Microsoft's customer support people on this. Stack dumps shouldn't be occurring at all, much less every couple min. They will have the tools to read...

    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 19, 2008 at 1:53 am

    #874046

  • RE: Query Optimise

    And please post in the appropriate forum next 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

    September 19, 2008 at 1:49 am

    #874045

  • RE: Truncate Log

    sqlservercenter (9/18/2008)

    detach it, when attach,ignore the log file,then it is ok.

    Especially if you're trying to corrupt the database.

    Log files aren't optional, deleting them should be an absolute last resort 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

    September 19, 2008 at 1:47 am

    #874044

  • RE: The index entry for row IDwas not found in index ID n, of table nnn, in database 'xx'

    Weird...

    Are there any entries in the sql error log or windows event log from the same 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

    September 19, 2008 at 1:46 am

    #874043

  • RE: Only one of the 16 processors is busy

    toparsi (9/18/2008)

    Thanks for all the replies...

    Gila Monster

    I could not answer as I came in a little late today. We are using MSMQ (microsoft message queuing) for batch processing.

    Ok,...

    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 19, 2008 at 1:45 am

    #874041

  • RE: Deadlock

    When you get a deadlock graph, post it here and I'm sure someone will help you with it.

    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 18, 2008 at 10:29 am

    #873763

  • RE: Deadlock

    What traceflag do you have on to get that output? (1205?)

    Try switching whichever that one is off and switching 1222 on. It gives very nice, very detailed output. There's nothing...

    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 18, 2008 at 10:20 am

    #873755

  • RE: DELETE statement is causing log size full

    The advantage is that the log backup will clear out of the log the entries for the delete that just finished, allowing the space to be reused on the next...

    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 18, 2008 at 10:13 am

    #873751

  • RE: How to get all activities on SQL server without using Profiler.

    Use the server-side trace functionality. It's what profiler uses behind the scenes and it uses a bunch of sp_trace procedures.

    You can get profiler to create a script for you...

    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 18, 2008 at 10:06 am

    #873744

  • RE: Worth Joining?

    They're a big, big organisation, their methodologies and ways of doing things are set and are not subject to change. As long as you don't mind been told exactly how...

    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 18, 2008 at 10:04 am

    #873741

  • RE: The index entry for row IDwas not found in index ID n, of table nnn, in database 'xx'

    Can you do an integrity check on that DB?

    DBCC CheckDB (< Database name > ) WITH NO_INFOMSGS

    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 18, 2008 at 9:55 am

    #873731

  • RE: DMV to show wiped table

    No DMV. You may be able to use a 3rd party log reader and read the info from the tran log, but that's not an ideal situation as the transaction...

    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 18, 2008 at 9:48 am

    #873717

  • RE: 70-445 Questions and answers

    Transcender and MeasureUp are both good. Not cheap though.

    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 18, 2008 at 9:45 am

    #873716

  • RE: Active/Active cluster setup in s2k5

    No idea. I never install client tools on a server.

    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 18, 2008 at 9:44 am

    #873714

  • RE: DELETE statement is causing log size full

    maheshgilla (9/18/2008)

    Gail Shaw-As it in Production, database is in Full recovery model, we can change it to Simpel while deleting. As you said Second option how can I delete 500,000...

    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 18, 2008 at 9:39 am

    #873708

Viewing 15 posts - 44,401 through 44,415 (of 49,552 total)