CREATE TABLE my_table1 (
    field1 VARCHAR(256) NOT NULL,
    field2 VARCHAR(256) NOT NULL,
    field3 VARCHAR(256) NOT NULL
);
CREATE INDEX idx_field1 ON my_table1(field1);

GO

CREATE PROCEDURE insertToTable1
    @field1 VARCHAR(256), @field2 varchar(256), @field3 varchar(256)
AS
BEGIN
    SET NOCOUNT ON

    IF NOT EXISTS (SELECT * FROM my_table1 WHERE field1 = @field1)
      INSERT INTO my_table1
        (field1, field2, field3)
      VALUES (@field1, @field2, @field3);
    ELSE
      THROW 50000, 'xxxxxx', 1;
    END
GO

CREATE TABLE my_table2 (
    field1 VARCHAR(256) NOT NULL,
    field2 VARCHAR(256) NOT NULL,
    field3 VARCHAR(256) NOT NULL
);
CREATE UNIQUE INDEX idx_field1 ON my_table2(field1);


GO

CREATE PROCEDURE insertToTable2
    @field1 VARCHAR(256), @field2 varchar(256), @field3 varchar(256)
AS
BEGIN
    SET NOCOUNT ON
      INSERT INTO my_table2
        (field1, field2, field3)
      VALUES (@field1, @field2, @field3);
    END
GO

SET NOCOUNT ON

PRINT 'Testing non unique'
PRINT SYSUTCDATETIME()
DECLARE @I INT = 0
WHILE @I < 1000000
BEGIN
DECLARE @field1 VARCHAR(256) = CONVERT(CHAR(32), CRYPT_GEN_RANDOM(16),2),
        @field2 varchar(256) = CONVERT(CHAR(130), CRYPT_GEN_RANDOM(65),2),
        @field3 varchar(256) = CONVERT(CHAR(64), CRYPT_GEN_RANDOM(32),2)

EXEC insertToTable1 @field1, @field2, @field3

IF @I % 100000 = 0
    PRINT SYSUTCDATETIME()

SET @I = @I + 1;
END
PRINT SYSUTCDATETIME()



--DATAFILE AND LOGFILE presized to 4GB



go

PRINT 'Testing unique'
PRINT SYSUTCDATETIME()
SET NOCOUNT ON

DECLARE @I INT = 0
WHILE @I < 1000000
BEGIN
DECLARE @field1 VARCHAR(256) = CONVERT(CHAR(32), CRYPT_GEN_RANDOM(16),2),
        @field2 varchar(256) = CONVERT(CHAR(130), CRYPT_GEN_RANDOM(65),2),
        @field3 varchar(256) = CONVERT(CHAR(64), CRYPT_GEN_RANDOM(32),2)

EXEC insertToTable2 @field1, @field2, @field3

IF @I % 100000 = 0
    PRINT SYSUTCDATETIME()

SET @I = @I + 1;
END
PRINT SYSUTCDATETIME()