Database Challenges

We did a Load Testing of the solutions that passed Logic Testing. The Load Testing is done using a table with 100,000 rows. Here is the script used to generate the test table.

/***********************************************************************
 Purpose:
 Test data generator for TSQL Challenge 14 - Load Testing
***********************************************************************/
--===== If the test table already exists, something is wrong.
     -- Warn/instruct the operator and exit early.
     IF OBJECT_ID('TC14','U') IS NOT NULL
  BEGIN
        RAISERROR('RUN ABORTED. "TC14" already exists.',11,1);
        RAISERROR('Please drop the table if you wish to recreate.',10,1);
        RETURN
    END;

--===== Create and populate the table on the fly
 SELECT TOP 100000 
        CAST(NEWID() AS VARCHAR(40)) AS Data
   INTO dbo.TC14
   FROM master.sys.all_columns ac1
  CROSS JOIN master.sys.all_columns ac2;

GO