Tag: OPENDATASOURCE

Pro Members SQL Server Standard Members

Tips for using linked servers in SQL Server 2019

by

Tips for using linked servers in SQL Server 2019 Rewrite remote queries so, that the most work will be performed on the remote server, not the local server. You can run the remote query from Management Studio and take a look at the query plan to find out which parts of the remote query are performing on the remote server...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using linked servers in SQL Server 2017

by

Tips for using linked servers in SQL Server 2017 Ensure that the connection between the linked servers is fast. Ideally, the linked servers should be in the same subnet. Try to avoid using distribution transaction or minimize it using. Because distribution transactions incur more overhead than general transactions, avoid using distribution transactions, whenever possible. One of the first steps to...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Some tips for using linked servers in SQL Server 2016

by

Some tips for using linked servers in SQL Server 2016 Try to avoid the ad hoc queries that use the OPENROWSET or the OPENDATASOURCE functions to access remote data. Create a linked server and perform a linked server’s query instead of using an ad hoc query with OPENROWSET or OPENDATASOURCE functions. Using the linked server’s queries to access remote data...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Some tips for using SQL Server 2016 distributed queries

by

Some tips for using SQL Server 2016 distributed queries Try to avoid using distribution queries or minimize it using. Because distribution transactions incur more overhead than general transactions, avoid using distribution queries, whenever possible. The first steps to optimize distributed queries against a SQL Server 2016 linked server is rewriting queries so, that the most work will be performed on...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2014 Distributed Queries

by

Tips for using SQL Server 2014 Distributed Queries One of the first steps to optimize distributed queries against a SQL Server 2014 linked server is rewriting queries so, that the most work will be performed on the remote server, not the local server. You can run the remote query from Management Studio and take a look at the query plan...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →