hi prasad,

please check the query execution plan for both statements. it shows same plan and costs.

hi ,

just put a WAITFOR DELAY '00:00:01' statement after

SET @dateTest = GETDATE() statement

Set @SetDateCommand = 'date ' + convert(varchar,@dateLoop,110)

 Execute master.dbo.xp_cmdshell @SetDateCommand 

 SET @dateTest = GETDATE()

 select @dateTest,GETDATE()