Bulk import performance is improved if the data being imported is sorted according to the clustered index on the table, if any. By default, the bulk insert operation assumes the data file is unordered. For optimized bulk import, SQL Server also validates that the imported data is sorted.. GeoPITS brings you the comprehensive details of Bulk insert improvements's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | Yes | Yes | Yes |
| Version v2017 | Yes | Yes | Yes | Yes | Yes |
| Version v2016 | |||||
| Version v2014 | |||||
| Version v2012 |
Bulk import performance is improved if the data being imported is sorted according to the clustered index on the table, if any. By default, the bulk insert operation assumes the data file is unordered. For optimized bulk import, SQL Server also validates that the imported data is sorted.
You can find more details about this version here
Back to all features