GUID vs INT clustered PK's (GUID wins)

/* Test 1 - clustered guid pk */
BEGIN TRANSACTION;
CREATE TABLE Table1(
    [Guid] [uniqueidentifier] primary key,
)

DECLARE @i INT
SET @i = 1
WHILE @i < 1000000
BEGIN
    INSERT INTO Table1 VALUES (newid())
    SET @i = @i + 1
END

ROLLBACK TRANSACTION;

-- Results
-- 18 seconds
-- 14 seconds
-- 14 seconds




/* Test 2 - clustered int identity pk, non-clustered index on guid */
BEGIN TRANSACTION;
CREATE TABLE Table1(
    [ID] [INT] PRIMARY KEY IDENTITY,
    [Guid] [uniqueidentifier],
    UNIQUE NONCLUSTERED
    (
        [Guid] ASC
    )
)


DECLARE @i INT
SET @i = 1
WHILE @i < 1000000
BEGIN
    INSERT INTO Table1 VALUES (newid())
    SET @i = @i + 1
END

ROLLBACK TRANSACTION;

-- Results
-- 24 seconds
-- 24 seconds
-- 24 seconds



/* Test 3 - clustered bigint identity pk, non-clustered index on guid */

BEGIN TRANSACTION;
CREATE TABLE Table1(
    [ID] [BIGINT] PRIMARY KEY IDENTITY,
    [Guid] [uniqueidentifier],
    UNIQUE NONCLUSTERED
    (
        [Guid] ASC
    )
)


DECLARE @i INT
SET @i = 1
WHILE @i < 1000000
BEGIN
    INSERT INTO Table1 VALUES (newid())
    SET @i = @i + 1
END

ROLLBACK TRANSACTION;

-- Results
-- 29 seconds
-- 24 seconds