Forum Replies Created

Viewing 15 posts - 35,941 through 35,955 (of 49,552 total)

  • RE: Deadlock error in high cuncurrency env

    Can you post the entire deadlock graph please?

    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

    November 11, 2009 at 6:25 am

    #1077744

  • RE: Introduction to Indexes: Part 2 – The clustered index

    Esalter (11/11/2009)

    I find it difficult to believe this article, especially the reference that all non clustered indexes use the clustered index as their lowest level address

    Why do you find...

    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

    November 11, 2009 at 6:15 am

    #1077741

  • RE: Understanding some locks appearing in dead locks

    siddartha pal (11/11/2009)

    SELECT MAX(ID) FROM dbo.RequestStatus

    WHERE RequestID = @requestID AND (StatusID = 10 OR NextStatusID = 10)

    Just to double check, dbo.RequestStatus is a table?

    Does this deadlock happen often? Can...

    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

    November 11, 2009 at 5:51 am

    #1077735

  • RE: SSC Level List?

    Try a logarithmic y-axis. Might be clearer.

    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

    November 10, 2009 at 3:53 pm

    #1077580

  • RE: Transaction Log out of control

    Edit: Forum timeout.

    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

    November 10, 2009 at 3:42 pm

    #1077574

  • RE: Transaction Log out of control

    dan-404057 (11/10/2009)

    I have a database set for Full Recovery, which I run Snapshot Replication on for DW purposes once per day. (The log_reuse_wait field = 6).

    Any transactional replication?

    What does...

    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

    November 10, 2009 at 3:41 pm

    #1077571

  • RE: Slow execution time on query who perfoms Updates

    |--| (11/10/2009)

    By the way, you would be surprise of who I am and my experience.

    Do tell.

    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

    November 10, 2009 at 3:37 pm

    #1077569

  • RE: Slow execution time on query who perfoms Updates

    |--| (11/9/2009)

    Everything inside MS-SQL cache, should and must be actual execution plans or not? if s there, means it ran or it is running now.

    Estimated and actual are,...

    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

    November 10, 2009 at 3:32 pm

    #1077566

  • RE: qouestion about Index

    For that particular query, quick guess would be a composite index on

    DocID, DocDate, docSubject, docNo (in that order)

    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

    November 10, 2009 at 2:34 pm

    #1077542

  • RE: A Bad Litmus Test

    Grant Fritchey (11/9/2009)

    I realize I'm not terribly well educated... but I didn't recognize a single name on that list. I must not know what I'm doing. I'd better go tell...

    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

    November 10, 2009 at 2:16 pm

    #1077521

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (11/10/2009)

    I thought sledgehammer, but those flying pieces of ADSL modem are dangerous. Now if you can redirect those down the block.......

    No sledgehammer, I need this modem....

    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

    November 10, 2009 at 1:54 pm

    #1077502

  • RE: Index on Encrypted column

    TheSQLGuru (11/10/2009)

    1)

    You can index it, but it's completely useless to do so.

    That is incorrect. While you cannot do an index SEEK, a 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

    November 10, 2009 at 1:53 pm

    #1077501

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/10/2009)

    Great to see you.

    Likewise. We must do this more often.

    I'm glad you got home OK. Your trip is just SO long.

    Tell me about it. That last flight...

    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

    November 10, 2009 at 1:48 pm

    #1077497

  • RE: Transaction Log out of control

    dan-404057 (11/10/2009)

    (The log_reuse_wait field = 6).

    What's log_reuse_wait_desc? I don't offhand know the codes.

    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

    November 10, 2009 at 1:39 pm

    #1077492

  • RE: why my differential backup files are HUGE?

    Michael Valentine Jones (11/10/2009)

    A better daily maintenance would be: 1. Update statistics, 2. Integrity check, 3. Full backup.

    And an occasional index rebuild, doing all the indexes or targeted to 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

    November 10, 2009 at 1:39 pm

    #1077491

Viewing 15 posts - 35,941 through 35,955 (of 49,552 total)