I've got an INSERT in stored procedure:
INSERT INTO t1 SELECT TOP 3 x FROM t2 WHERE NOT EXISTS (SELECT 1 FROM t3 inner join t4 on t4.z = t3.z)
My question is: Is it possible, to get execution time of every step in this insert?
I'm using SQL SERVER EXPRESS 2008.