Hello everyone,

I have a S0 level Azure Sql database. On my pc, i have also sql express installed which has a stored procedure below;

Insert into [azur].[i-barman-sales].[dbo].[CocktailSales] ([machine_id],[Beverage_Name],[date],[kayt_id]) select [machine_id],[Beverage_Name],[date],[kayt_id] from [ibarman].[dbo].[kaytlar] where Beverage_Type='BEVERAGE' and sent='false'

update ibarman.dbo.kaytlar set sent='true'

I have a linked server on my sqlexpress database and with this sql insert query i am trying to copy my data to sql azure database but its not working good. Its taking longer than 10 min to insert only one column. I have about 500 columns to insert everyday and i could not find the solution. Do i have a problem with the query or do i need to make some settings on azure server ?

Thanks for your help
Ates