Eric M Russell

Forum Replies Created

Viewing 15 posts - 676 through 690 (of 6,034 total)

RE: Error: Cannot insert duplicate key row in... a non-unique index?!

Jeff Moden - Tuesday, December 18, 2018 7:17 PM
What does the warning triangle have to say?
It's warning about cardinality...

December 19, 2018 at 6:26 am

#2016815
RE: Error: Cannot insert duplicate key row in... a non-unique index?!

ScottPletcher - Tuesday, December 18, 2018 3:42 PM
That's logical since it's changing one of the keys.
Otoh, why are you specifying a...

December 18, 2018 at 3:54 pm

#2016762
RE: Error: Cannot insert duplicate key row in... a non-unique index?!

Here is a portion of the execution plan:

December 18, 2018 at 3:42 pm

#2016761
RE: Error: Cannot insert duplicate key row in... a non-unique index?!

After examining Query Store, I have determined the following update statement is the source for the sample error above. It's performing an UPDATE/JOIN between a staging table and the production...

December 18, 2018 at 3:37 pm

#2016759
RE: Error: Cannot insert duplicate key row in... a non-unique index?!

OK, here I will restate the problem, this time with less obfuscation, except for the actual data values involved.
Here is a sample error.
Cannot insert duplicate key...

December 18, 2018 at 3:32 pm

#2016758
RE: Error: Cannot insert duplicate key row in... a non-unique index?!

Jeffrey Williams 3188 - Tuesday, December 18, 2018 2:56 PM
Just curious - but is it possible the PAGE compression on the index...

December 18, 2018 at 3:20 pm

#2016754
RE: Entity-Attribute-Value is evil ? how to avoid...

Jeff Moden - Tuesday, December 18, 2018 11:49 AM
Eric M Russell - Tuesday, December 18, 2018 10:04...

December 18, 2018 at 12:13 pm

#2016720
RE: Error: Cannot insert duplicate key row in... a non-unique index?!

frederico_fonseca - Tuesday, December 18, 2018 11:18 AM
can you also post the DDL for index I
December 18, 2018 at 11:54 am

#2016716

RE: Error: Cannot insert duplicate key row in... a non-unique index?!

RAThor - Tuesday, December 18, 2018 7:35 AM
Eric M Russell - Monday, December 17, 2018 12:05 PM

December 18, 2018 at 10:26 am

#2016695

RE: Entity-Attribute-Value is evil ? how to avoid...

I don't think we should shape and force a RDMS like SQL Server to act something like a EAV or document database. We've got more data storage options inside SQL...

December 18, 2018 at 10:04 am

#2016688

RE: Entity-Attribute-Value is evil ? how to avoid...

Jeff Moden - Tuesday, December 18, 2018 8:00 AM
Eric M Russell - Tuesday, December 18, 2018 7:45...

December 18, 2018 at 9:55 am

#2016687

RE: Entity-Attribute-Value is evil ? how to avoid...

Entity-Attribute-Value tables are good for modeling operational configuration data; things like configuration strings, thresholds, and client implementation settings. The benefit is that it allows the application developers to easily create...

December 18, 2018 at 7:45 am

#2016665

RE: Error: Cannot insert duplicate key row in... a non-unique index?!

I'm going to look into setting up a trace to capture the insert statements tonight, hoping to get the execution plan and other session settings like isolation level. They...

December 17, 2018 at 1:20 pm

#2016578

RE: Error: Cannot insert duplicate key row in... a non-unique index?!

ScottPletcher - Monday, December 17, 2018 12:57 PM
Eric M Russell - Monday, December 17, 2018 12:50 PM

December 17, 2018 at 1:10 pm

#2016576

RE: Error: Cannot insert duplicate key row in... a non-unique index?!

I'm not on the ETL team, so I can't vouch for the specifics of why the table / indexes were modeled the way they are. However, it appears the index...

December 17, 2018 at 12:50 pm

#2016570

Viewing 15 posts - 676 through 690 (of 6,034 total)
Prev
1
2
3
…
45
46
47
…
401
402
403
Next