none
maxdop linked server question

    Question

  • Does anyone know how MAXDOP works when you have a linked server query?

    I have a linked server query that is reading a table on a remote server and inserting it into a table on the local server. Does MAXDOP apply to both servers or just the local or remote? Or is there a way of re-writing the query to control how it works?

    Example query

    Select * into dbo.temptbl from rmtsvr.srcdb.dbo.mytable OPTION (MAXDOP 1)

    Thanks


    Brian Searle

    Tuesday, September 24, 2013 8:16 AM

Answers

All replies