Forum Replies Created

Viewing 15 posts - 331 through 345 (of 543 total)

  • RE: GUIDs as clustered index

    Thanks all. Special thanks to Jeff & Scott for valuable inputs. Loads of pouring knowledge. Never thought, so much goes into the database design. I am going to test this...

    June 1, 2018 at 1:50 pm

    #1992716

  • RE: GUIDs as clustered index

    Jeff Moden - Thursday, May 31, 2018 11:31 AM

    vsamantha35 - Thursday, May 31, 2018 11:26 AM

    May 31, 2018 at 10:22 pm

    #1992592

  • RE: GUIDs as clustered index

    Jeff Moden - Thursday, May 31, 2018 9:17 AM

    vsamantha35 - Thursday, May 31, 2018 2:15 AM

    May 31, 2018 at 11:26 am

    #1992515

  • RE: GUIDs as clustered index

    frederico_fonseca - Thursday, May 31, 2018 3:58 AM

    Can you supply the DDL for the original tables, not the ones you have altered...

    May 31, 2018 at 4:10 am

    #1992439

  • RE: GUIDs as clustered index

    Jeff Moden - Wednesday, May 30, 2018 3:28 PM

    vsamantha35 - Wednesday, May 30, 2018 3:14 PM

    May 31, 2018 at 2:15 am

    #1992430

  • RE: GUIDs as clustered index

    Jeff Moden - Wednesday, May 30, 2018 3:01 PM

    vsamantha35 - Wednesday, May 30, 2018 5:43 AM

    May 30, 2018 at 3:14 pm

    #1992403

  • RE: GUIDs as clustered index

    sgmunson - Wednesday, May 30, 2018 10:48 AM

    vsamantha35 - Wednesday, May 30, 2018 5:43 AM

    May 30, 2018 at 3:03 pm

    #1992399

  • RE: GUIDs as clustered index

    frederico_fonseca - Wednesday, May 30, 2018 7:31 AM

    If your worry is just the index fragmentation you probably can avoid it if you...

    May 30, 2018 at 3:01 pm

    #1992398

  • RE: Extended event help

    Jack Corbett - Friday, May 25, 2018 8:55 AM

    TABLOCK is an option on BULK INSERT so find out if they...

    May 25, 2018 at 9:13 pm

    #1992043

  • RE: How to fix this deadlock?

    Sergiy - Tuesday, May 22, 2018 12:55 PM

    I cannot see object Common.Changesets mentioned anywhere in the query quoted in the XML.Did you...

    May 22, 2018 at 8:55 pm

    #1991535

  • RE: How to fix this deadlock?

    Lynn Pettis - Tuesday, May 22, 2018 10:27 AM

    You have all the information available to solve this problem, we don't.  All you...

    May 22, 2018 at 11:07 am

    #1991468

  • RE: How to fix this deadlock?

    John Mitchell-245523 - Tuesday, May 22, 2018 10:00 AM

    vsamantha35 - Tuesday, May 22, 2018 9:55 AM

    May 22, 2018 at 10:12 am

    #1991458

  • RE: How to fix this deadlock?

    Lynn Pettis - Tuesday, May 22, 2018 9:52 AM

    Sue_H - Tuesday, May 22, 2018 8:52 AM

    May 22, 2018 at 9:58 am

    #1991448

  • RE: How to fix this deadlock?

    John Mitchell-245523 - Tuesday, May 22, 2018 9:41 AM

    Like I said, this is something you need to do yourself.  It's too tiresome...

    May 22, 2018 at 9:55 am

    #1991445

  • RE: How to fix this deadlock?

    pasting the contents of deadlock.xml

    <deadlock>
    <victim-list>
      <victimProcess id="processbb030df848" />
    </victim-list>
    <process-list>
      <process id="processbb030df848" taskpriority="0" logused="19068" waitresource="OBJECT: 9:1573580644:1 " waittime="1952"...

    May 22, 2018 at 9:26 am

    #1991434

Viewing 15 posts - 331 through 345 (of 543 total)