Источник:
https://blogs.msdn.microsoft.com/axi...rver-20162017/
==============
There is a performance issue in SQL Server 2016 and SQL Server 2017 where the processor utilization will run very high for certain queries
https://support.microsoft.com/en-us/...mp-table-in-sq The queries that will experience this higher utilization are queries that insert many records into a table or temp table OUTSIDE of a transaction. Not starting your own BEGIN/COMMIT transaction...
Источник:
https://blogs.msdn.microsoft.com/axi...rver-20162017/