Forum Replies Created

Viewing 15 posts - 196 through 210 (of 2,356 total)

  • Reply To: AG listener error

    Are you trying to add a second listener?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 23, 2023 at 4:13 pm

    #4164228

  • Reply To: what's the performance difference between unique clustered index and primary key

    Snargables wrote:

    Sorry, guys. Let me tell u what brought this up. We have several load processes where we are truncating and reloading large tables. These table are used for one...

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 17, 2023 at 2:18 pm

    #4161977

  • Reply To: what's the performance difference between unique clustered index and primary key

    CreateIndexNonclustered wrote:

    There is no business rule that can redefine the relationship between entities. Two entities don't just change their mind one day and decide they are going to relate to...

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 17, 2023 at 1:46 pm

    #4161964

  • Reply To: what's the performance difference between unique clustered index and primary key

    ScottPletcher wrote:

    CreateIndexNonclustered wrote:

    It's 16 Gb. My laptop from 10-11 years ago had double that amount of ram. My phone from 2010ish with its 480x800 resolution screen had that amount of...

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 16, 2023 at 10:21 pm

    #4161680

  • Reply To: what's the performance difference between unique clustered index and primary key

    CreateIndexNonclustered wrote:

    Maybe you have an example, but I cannot think of a reason why you would need to change a primary key after a table has been created, while leaving...

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 16, 2023 at 9:06 pm

    #4161654

  • Reply To: what's the performance difference between unique clustered index and primary key

    CreateIndexNonclustered wrote:

    Michael L John wrote:

    CreateIndexNonclustered wrote:

    I mean you literally quoted all the constraints I mentioned on it I cannot possibly imagine how you failed to understand what I wrote.

    I read everything you...

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 16, 2023 at 6:51 pm

    #4161615

  • Reply To: what's the performance difference between unique clustered index and primary key

    CreateIndexNonclustered wrote:

    Let us work on your comprehension and failures in logic and reasoning then. 

    How about let's work on your ability to state things without inferring meaning?

    You stated "A clustered Primary...

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 16, 2023 at 6:47 pm

    #4161614

  • Reply To: what's the performance difference between unique clustered index and primary key

    CreateIndexNonclustered wrote:

    I mean you literally quoted all the constraints I mentioned on it I cannot possibly imagine how you failed to understand what I wrote.

    I read everything you wrote.  A...

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 16, 2023 at 6:12 pm

    #4161588

  • Reply To: what's the performance difference between unique clustered index and primary key

    Snargables wrote:

    ok, so that's what I thought. In fact often times I'm not even creating the primary key. I simply create 1 or many unique indexes because it was my...

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 16, 2023 at 6:05 pm

    #4161587

  • Reply To: what's the performance difference between unique clustered index and primary key

    A clustered Primary key is a unique clustered index.[/quote]

    No, they are not the same.  A primary key cannot contain a null.   A unique index can contain a single null.

    CreateIndexNonclustered wrote:

    [quote-0...

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 16, 2023 at 5:54 pm

    #4161572

  • Reply To: what's the performance difference between unique clustered index and primary key

    A clustered Primary key is a unique clustered index.[/quote]

    No, they are not the same.  A primary key cannot contain a null.   A unique index can contain a single null.

    CreateIndexNonclustered wrote:

    If...

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

    March 16, 2023 at 5:54 pm

    #4161571

    • Viewing 15 posts - 196 through 210 (of 2,356 total)