Here’s a quick way to get some timing statistics on your T-SQL:
DBCC FREEPROCCACHE
GO
DBCC DROPCLEANBUFFERS
GO
SET STATISTICS TIME ON
GO
-- Insert your query here
SET STATISTICS TIME OFF
GO
GO
DBCC DROPCLEANBUFFERS
GO
SET STATISTICS TIME ON
GO
-- Insert your query here
SET STATISTICS TIME OFF
GO
After you run the statements in query analyzer, check the messages tab to see how it went.