By Nestor

2011-11-21 06:42:39 8 Comments

I can use the Management studio to connect directly to my Azure SQL database and execute this query:

select * from DB.dbo.DSeries where instrument='name1' 

and it works really fast. But if I create a linked server (called "WF") in my local server that connects to Azure and try to execute the same query,

select * from WF.DB.dbo.DSeries where instrument='name1' 

The query is really slow. Why could that be happening?


@SqlACID 2011-11-21 18:07:19

Try setting the "Collation Compatible" to True on the Linked Server definition.

If you set it to False, it will pull the entire table down and do the compare on the receiving end. Consider the scenario where the local server is case insensitive, and the remote server is case sensitive, the results will differ based on where the compare is done.

@Nestor 2011-11-21 18:32:15

Yessss... that solved it. Care to explain the solution?

Related Questions

Sponsored Content

4 Answered Questions

2 Answered Questions

[SOLVED] Azure SQL Server Database Error: 18456, Severity: 14, State: 1

2 Answered Questions

[SOLVED] Import bacpac from SQL Azure into local server fails.

1 Answered Questions

[SOLVED] Cannot connect Power BI Desktop to Azure SQL!

2 Answered Questions

[SOLVED] User can't right-click SQL Azure database in SSMS

1 Answered Questions

[SOLVED] Slow delete with varbinary(max) column

1 Answered Questions

[SOLVED] Transferting large SQL Databases to Azure (>300MB)

1 Answered Questions

[SOLVED] Insert to SQL Azure through Linked Server very slow

Sponsored Content