enable identity cache

Enable identity cache feature in SQL Server 2017 One type of contribution and appreciation of a developer (data warehouse) seems to be having a surplus efficiency in identifying surrogate keys. Go through on the dimension tables and facts to fetch the details on surrogate keys. Why more...