azure sql database – Linked Servers and Application Intent

I’m attempting to improve performance of a set of views that we have on a local server, pulling data from an Azure database.

Our system provider advised us to use ApplicationIntent=ReadOnly, but can we optimise these queries further by using tempdb space on the remote server to create temporary tables, if read only is set?

I read this answer, which does help a little, but would appreciate any straightforward answers on this.

Please note, I’m not a DBA, so my knowledge is pretty limited. Thanks in advance.

Read more here: Source link