Matan Yungman is a Technical Evangelist and senior consultant at Madeira SQL Server Services. His job is to get the word out about SQL Server. He speaks, lectures, writes, teaches and consults about SQL Server, focusing mainly on performance tuning, database development, high availability and database design. He’s passionate about SQL Server, technology and the SQL Server community.

5 Performance Killers When Working With Linked Servers

by Matan_Yungman

Matan Yungman

When working with linked servers, the most expensive factor to consider is the amount of data that will have to...

2012-09-08

535 reads

All authors

Read the latest Blogs

Visit the forum

Question of the Day

Replacing a NULL II

What is returned from this code in SQL Server 2022?

DECLARE
  @value INT = NULL
, @value2 VARCHAR(20) = NULL;
SELECT COALESCE (@value, @value2, 100.5) AS Result;
GO

See possible answers

5 Performance Killers When Working With Linked Servers

Blogs

Understanding Lakehouse Permissions in Microsoft Fabric

The Cost of Not Having a DBA

Who are you? Building an identity map.

Forums

Union where it matches against only one shared column

How to update using data from three tables?

Select Returning Blank Rows

Question of the Day

Replacing a NULL II

Blogs

Forums

Question of the Day

Cookies on SQLServerCentral