/*
EXEC master.dbo.sp_addlinkedserver @server = N'LOCALSERVER', @srvproduct=N'', @provider=N'SQLNCLI', @datasrc=N'lpc:(local)\SQL2017DEV', @catalog=N'master'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LOCALSERVER',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
EXEC master.dbo.sp_serveroption @server=N'LOCALSERVER', @optname=N'rpc', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'LOCALSERVER', @optname=N'rpc out', @optvalue=N'true'
*/

SET NOCOUNT ON;
declare @dt datetime, @dif1 int, @dif2 int, @dif3 int;

if object_id('tempdb..#netinfo') is not null drop table #netinfo;
create table #netinfo ([val] varchar(max));


delete from #netinfo;
set @dt = getdate();
	-- напрямую INSERT SELECT
	INSERT INTO #netinfo ([val]) SELECT [val] = REPLICATE(cast(REPLICATE(cast(CHAR(55) as varchar(max)),1024) as varchar(max)),1024*100);
set @dif1 = DATEDIFF(ms,@dt,getdate());

delete from #netinfo;
set @dt = getdate();
	-- через INSERT EXEC AT [LOCALSERVER]
	INSERT INTO #netinfo ([val]) EXEC(N'SET NOCOUNT ON; SELECT [val] = REPLICATE(cast(REPLICATE(cast(CHAR(55) as varchar(max)),1024) as varchar(max)),1024*100)') AT [LOCALSERVER];
set @dif2 = DATEDIFF(ms,@dt,getdate());

delete from #netinfo;
set @dt = getdate();
	-- через INSERT SELECT FROM OpenQuery ( [LOCALSERVER], ... )
	INSERT INTO #netinfo ([val]) SELECT [val] FROM OpenQuery ( [LOCALSERVER], N'SET NOCOUNT ON; SELECT [val] = REPLICATE(cast(REPLICATE(cast(CHAR(55) as varchar(max)),1024) as varchar(max)),1024*100);' );
set @dif3 = DATEDIFF(ms,@dt,getdate());


select [local ms] = @dif1 ,[AT ms] = @dif2 ,[OpenQuery ms] = @dif3;