They are probably right. There is probably no value in that column (not to mention the ambiguous "ID" name) unless you are using an ORM or other tool/framework that insists...

What do you mean by "Update routine"? A stored procedure? A script? Or ORM or other C# code

If SQL code add something like

SELECT @@ROWCOUNT AS UpdatedCount

directly after...

• This reply was modified 1 month ago by  ratbak.

Just exclude first_name & last_name from the constraint -- per your new requirement, they are no longer part of the definition of unique.  e.g.,

CREATE UNIQUE INDEX ix_unique_email
ON...

4 versions of this post -- reply to https://www.sqlservercentral.com/forums/topic/between-datetime-statement-not-working-4 which seems to be the one being updated.

4 versions of this post -- reply to https://www.sqlservercentral.com/forums/topic/between-datetime-statement-not-working-4 which seems to be the one being updated.

4 versions of this post -- reply to https://www.sqlservercentral.com/forums/topic/between-datetime-statement-not-working-4 which seems to be the one being updated.

Just use UNION ALL between the two selects you're using for the inserts into the temp tables, and eliminate the rest.

Unintentional duplicate due to delay in save.

If it is truly indexed appropriately (and filtered indexes may be a part of that), then none of the other approaches may be needed to maintain performance at that level.

What...

@pitterson's response looked like it was ChatGPT-generated (especially given it was  a new user)

What is the transaction isolation level for the database? I haven't found yet the default used by Powershell.

From the wayback machine:

https://web.archive.org/web/20111212031052/http://beyondrelational.com/blogs/madhivanan/archive/2008/09/12/return-top-n-rows.aspx

would a MERGE perform better than an UPDATE/INSERT?

Probably not: https://www.sqlservercentral.com/articles/performance-of-the-sql-merge-vs-insertupdate

An actual execution plan (e.g., from https://www.brentozar.com/pastetheplan/) would probably help us.

Is the duplicate column an identity column or using a sequence? If so, are the current values behind the actual values in the database?