LOOP INSERT 에서 명시적 트랜젝션으로 성능향상

--트랜젝션 적용
USE test
GO
IF object_id('tblx') is not null
DROP TABLE tblx
GO
CREATE TABLE tblx(idx INT, c1 CHAR(100))
go
DBCC SQLPERF ('SYS.DM_OS_WAIT_STATS',CLEAR);
BEGIN TRAN
    DECLARE @LOOPCNT INT = 1
    WHILE (@LOOPCNT <= 10000) BEGIN
    INSERT INTO tblx VALUES(@LOOPCNT, 'A')
    SET @LOOPCNT += 1
    END
COMMIT TRAN
SELECT * FROM SYS.DM_OS_WAIT_STATS
WHERE WAIT_TYPE IN ('LOGMGR_QUEUE', 'WRITELOG');