Fri.Apr 05, 2019

article thumbnail

IGNORE_DUP_KEY slower on clustered indexes

SQL Performance

The IGNORE_DUP_KEY option for unique indexes specifies how SQL Server responds to an attempt to INSERT duplicate values: It only applies to tables (not views) and only to inserts. Any insert portion of a MERGE statement ignores any IGNORE_DUP_KEY index setting. When IGNORE_DUP_KEY is OFF , the first duplicate encountered results in an error , and none of the new rows are inserted.

Storage 53
article thumbnail

Stuff The Internet Says On Scalability For April 5th, 2019

High Scalability

Wake up! It's HighScalability time: SHUTDOWN ABORT the last Oracle database running Amazon Fulfillment! pic.twitter.com/DorqTua2Lt. — John Darrow (@jdarrow) March 29, 2019. How unhappy do you have to be as a customer to take so much joy in end-of-lifing a product? Do you like this sort of Stuff? I'd greatly appreciate your support on Patreon. I wrote Explain the Cloud Like I'm 10 for people who need to understand the cloud.