However, in order to be able to insert data with hard coded ids for easiest testing, I need to set the IDENTITY_INSERT property to ON on each relevant table before inserting any data. How to reproduce ...

2) Insert new rows into empty unindexed tables: as shown above, the result is high performance bulk inserts. 3) use partitioned tables: either Data Partitioning or Distributed Partitioned Views ...