Minimal Logging with INSERT…SELECT into Empty Clustered Tables
SQL Performance
MAY 16, 2019
For SQL Server 2014 and later, the uniquifier is correctly omitted for unique indexes, but the one extra byte for the internal bit flag is retained. The following script should be run on a development SQL Server instance in a new test database set to use the SIMPLE or BULK_LOGGED recovery model. spt_values AS SV ; Plan Caching.
Let's personalize your content