Eric M Russell

Forum Replies Created

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

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

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

I have confirmed with the ETL developers that they are using READ COMMITTED ISOLATION on both remote source database and target database.
The version of the source database server...

December 17, 2018 at 12:30 pm

#2016562

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

ScottPletcher - Monday, December 17, 2018 12:11 PM
None of those indexes match the name in the error message.
What is the DDL for...

December 17, 2018 at 12:25 pm

#2016560

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