Query to compare indexes between two tables

(Kenneth Fisher) We have a set of databases at my office that use the load and swap method of loading data with minimal effect on the users. In case you haven’t heard of this before if you have a table that is modified during a batch process only (no user writes at all) then you can make two copies

Read More - Register for Free Membership