First published on MSDN on Jul 06, 2016
Authored by Sanjay Mishra
Sanjay Mishra, with Arvind Shyamsundar
Reviewed By: Sunil Agarw...
Updated Oct 28, 2022
Version 4.0
Blog Post
Can we do this on the secondary replica where we are inserting data into a temporary table as part of a transaction? Our processes takes a lot of time to dump the data into temporary table as it is selected from complex joins done on the tables in the AG database on the secondary replica.