Michael L John

Forum Replies Created

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

Reply To: Capturing Data Changes

RonKyle wrote:
I recently added audit triggers that had some degree of complexity. To test the performance one of the developers issued a million inserts in a little over an hour--far...

March 27, 2023 at 2:24 pm

#4165541
Reply To: Passing parameters to query without TVFs
fregatepllada wrote:
SELECT * FROM is not a good practice.
Never?
fregatepllada wrote:
You could wrap multiple parameters into a single XML/JSON document and pass it as a SINGLE parameter into StoredProcedure
Using sp_xml_preparedocument? ...
March 27, 2023 at 2:11 pm

#4165536
Reply To: AG listener error

This article spells it out pretty well.
https://techcommunity.microsoft.com/t5/sql-server-blog/how-to-create-multiple-listeners-for-same-availability-group/ba-p/384028

March 23, 2023 at 5:58 pm

#4164265

Reply To: Help with calculating Percentages

PS_Richard wrote:

I'm having to add back in the ISNULL on the percentage calculations so that NULL fields are not displayed. SO example of an updated string is this.

March 23, 2023 at 4:18 pm

#4164229

Reply To: AG listener error

Are you trying to add a second listener?

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

March 16, 2023 at 5:54 pm

#4161571

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