thanks Jeff i will check if that can be removed or not. i will compare both results and see if there is any difference in time taken to complete load

data is not in base table, after manipulation in temp table based on business logic we need to insert to a remote table. don't think replication in needed in this...

yes more than once. if it a base table I would have pull the data from remote server which is also not optimized but it give some performance benefit

thanks for your response that's a complete rewrite of current solution. anything we can tweak to make it faster?

thanks for your prompt response. So we can run multiple secondary's with different interval I guess LS uses LSN number to determine which it is applying. am I right?

My only...

account is sysadmin across all servers. Do you think still we need to grant permission explicitly ?

is there a way to extract the execution that was last created/used for a stored procedure.

I try to extract from sys.dm_exec_cached_plans but for some reason it doesnt show for all...

thanks i will try your scripts

trying to find a way tsql code that is not compatible on sql 2012. and also as lowell mentioned when underline objects are modified and dependent objects are not updated...

thanks for your reply.

How about an index, if i create a index on a large table consider 1 million records, it may take couple of hours to complete. What will...

assume a data load starts with select then insert and display results at the end,

Thanks for you reply that works perfect!

in case if we have 10 payments (empsal, empsal1..empsal9) and dates paiddate1 through 10 what we need to do?

not more than 50

thanks. i dont see a link i m missing something.

max would be two column per employee. its a report they want to view payments and dates of each employee in that format.