Tips & Tricks
Indexes
Query Hints
AI
Links
Contact

Optimize Linked Server Performance with MAXDOP Settings

Posted on May 4, 2026May 4, 2026 by admin

The working solution is to set Openquery:

SELECT * FROM OPENQUERY (MSSQL_Linked_Server, 'SELECT name FROM joe.titles
WHERE name = ''NewTitle'' option (maxdop 1)');

Posted in Query Hints, Tips & Tricks

Brent Ozar’s Blog

I’m Coming to the #PassDataSummit in Seattle!

The lineup for the PASS Data Community Summit Seattle event was just released,and I’m proud to share that I’ll be teaching my new all-day pre-conference workshop. Dev-Prod Demon Hunters: Finding [...]

We’re Discontinuing SQL ConstantCare and the Consultant Toolkit. Here’s Why.

About ten years ago, I sketched out an idea for a different kind of SQL Server monitoring tool: one that gathered data just once per day, and gave you a [...]

[Video] Office Hours: Off St. Thomas

I’m at sea again, this time cruising aboard the Disney Treasure off of St. Thomas. Let’s go through your top-voted questions from https://pollgab.com/room/brento. 00:00 Start 01:40 DbaMan: You have been [...]

And Then There Was The Time RCSI Actually Made Query Results More Accurate.

Normally when I tell people about SQL Server’s optimistic concurrency isolation levels, Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation (SI), I have to give them a little speech about [...]

Leave a Reply Cancel reply