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?

Yes, agreed.

But the OP is planning a move to an RDBMS that doesn't have a filestream option to my knowledge.

Since the OP is planning a move to RDS (which just...

You have to export to "regular" files, and then import those files from the filesystem into your database of choice (though I'd recommend at least considering storing files w/ operating...

See msdb.dbo.log_shipping_monitor_history_detail & msdb.dbo.log_shipping_monitor_error_detail

You'd probably have to close and re-open SSMS for that to work.

But why? What are you trying to do that would require setting this programmatically. You may be trying to...