Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @t1 DATETIME;
- DECLARE @t2 DATETIME;
- SET @t1 = GETDATE();
- SELECT TOP 100000 * FROM [BRT-DR01].[livefdb].[dbo].RegAcctQuery_Result;
- SET @t2 = GETDATE();
- SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;
- SET @t1 = GETDATE();
- SELECT TOP 100000 * FROM [BRT-DR01].[livefdb].[dbo].RegAcctQuery_Result;
- SET @t2 = GETDATE();
- SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement