> A leaked recording on Tuesday revealed the Trump administration’s plans to use AI to help rewrite a large chunk of the federal government’s computer systems.
That should work out great (from here for those wondering)
@ErikReasonableRatesDarling It does seem the most likely candidate explanation. Will you be able to run a controlled test to determine that as the cause?
Compilation replay, I mean. From memory, your example before did not use a forced plan
I think you're right - I came to this same conclusion yesterday after writing this. Fortunately, I've still got two copies of the database that have not had the table dropped & re-created, so we can check that out to confirm. Thanks for the TABLOCK hint - I'll check that out. Not surprisingly, an earlier version of this code did use truncate table, but it was changed due to an apparent bug in SQL 2019. — CarlDaniel7 hours ago
