Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN TRANSACTION
- CREATE TABLE Table1(
- [Guid] [uniqueidentifier] PRIMARY KEY WITH (FILLFACTOR = 90),
- TestID INT IDENTITY(1,1),
- UNIQUE NONCLUSTERED (TestID)
- )
- DECLARE @i INT
- SET @i = 1
- WHILE @i < 1000000
- BEGIN
- INSERT INTO Table1 (Guid) VALUES (newid())
- SET @i = @i + 1
- END
- ROLLBACK TRANSACTION
- -- 23 seconds
- BEGIN TRANSACTION
- CREATE TABLE Table2(
- [ID] [INT] PRIMARY KEY IDENTITY(1,1),
- [Guid] [uniqueidentifier] NOT NULL,
- UNIQUE NONCLUSTERED ([Guid] ASC) WITH (FILLFACTOR = 90)
- )
- DECLARE @i INT
- SET @i = 1
- WHILE @i < 1000000
- BEGIN
- INSERT INTO Table2 (Guid) VALUES (newid())
- SET @i = @i + 1
- END
- ROLLBACK TRANSACTION
- -- 26 seconds
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement