Forum Replies Created

Viewing 15 posts - 34,066 through 34,080 (of 49,552 total)

  • RE: EFFECT OF TRUNCATE TABLE ON TRANSACTION ROLLBACK

    Bill Jackewicz (2/11/2010)

    It did take 20-25% longer (~10hours) to rollback than the elapsed time prior to killing the query (~8 hours).

    That's normal.

    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 11, 2010 at 8:38 am

    #1117603

  • RE: Are the posted questions getting worse?

    I can't see anything catastrophically wrong. Not like the 'fixing of a suspect DB earlier this week'

    Yes, the index diagram is slightly incorrect (the root has a single page), the...

    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 11, 2010 at 4:28 am

    #1117509

  • RE: Rebuild log in SQL Server 2005 database

    First question: Why do you need to rebuild the transaction log? That's not something to do lightly.

    Take a look at this: http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

    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 11, 2010 at 3:31 am

    #1117476

  • RE: Process ID 'x' was killed by hostname XYZ, host process ID 'xxx'.

    The fact that DTA doesn't find anything, doesn't mean that there isn't opportunity for improvement. DTA is questionable at best.

    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 11, 2010 at 3:26 am

    #1117475

  • RE: Covering Index using Included Columns

    RichardBo (2/11/2010)

    What does SARG mean?

    Searchable ARGument. It means a predicate in the where clause that can be used for an index seek operation. As a very high level summary, that'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

    February 11, 2010 at 3:25 am

    #1117473

  • RE: Installing 2 instances of sql server

    Yes, it is possible. Same as installing two instances anywhere.

    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 11, 2010 at 2:32 am

    #1117457

  • RE: Process ID 'x' was killed by hostname XYZ, host process ID 'xxx'.

    Joy Smith San (2/11/2010)

    I have read enough abot performance tuning and have started accumulating the necessary data. But still can you just brief me the steps I need to do...

    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 11, 2010 at 2:29 am

    #1117455

  • RE: Process ID 'x' was killed by hostname XYZ, host process ID 'xxx'.

    Someone (who's using a computer with the name given in hostname XYZ) is running the KILL command and killing processes.

    Find the person and tell them to stop.

    That's likely not the...

    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 11, 2010 at 2:05 am

    #1117445

  • RE: Attach a suspect database

    imtiazm (2/11/2010)

    The database is still suspect , so i can put into emergency mode and access the data.

    It's highly unlikely that you're going to get all the data back....

    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 11, 2010 at 1:50 am

    #1117438

  • RE: Performance problem!

    That's a really vague question. There's nothing inherently wrong with nested loop joins and constant scans. Is it slow? Is there blocking? Are there timeouts?

    DTA indexes should be tested 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 11, 2010 at 1:49 am

    #1117437

  • RE: deadlock

    You don't need to enable traceflag 3605.

    1204 writes the deadlock graph into the error log

    1205 writes some of the deadlock search info into the error log.

    3605 redirects some output...

    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 11, 2010 at 1:28 am

    #1117427

  • RE: Are the posted questions getting worse?

    RBarryYoung (2/10/2010)

    1) Goto my blog site and download my presentation "TheTop Ten Reasons You Aren't already using Service Broker", or "Top 10 Fixes for your first Service Broker project". ...

    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 11, 2010 at 1:24 am

    #1117425

  • RE: 32 bit versus 64 bit

    Jeff Moden (2/10/2010)

    I'm not sure if they've fixed the problem yet or not but my understanding is that 64 bit versions cannot use JET drivers... that pretty much kills things...

    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 11, 2010 at 1:23 am

    #1117423

  • RE: EFFECT OF TRUNCATE TABLE ON TRANSACTION ROLLBACK

    ALZDBA (2/10/2010)

    If I'm correct, with sql2005 the db would be available far more earlier than with sql2000.

    Enterprise edition only.

    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 11, 2010 at 1:12 am

    #1117417

  • RE: EFFECT OF TRUNCATE TABLE ON TRANSACTION ROLLBACK

    Bill Jackewicz (2/10/2010)

    1.) While the ROLLBACK is being processed, will dropping the indices have any affect, good or bad?

    2.) What happens if I issue a TRUNCATE TABLE...

    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 10, 2010 at 11:35 am

    #1117042

Viewing 15 posts - 34,066 through 34,080 (of 49,552 total)