Database Challenges

The following script generates the data required for the performance testing of TSQL Challenge 23.

/*************************************************************
 --------------------------------------------------------------
 Performance Testing Data for TSQL Challenge 23
 Copyright © beyondrelational.com
 -------------------------------------------------------------- 
 
 Notes:
 
 Revision History:
 Rev 00 - 09 June 2010 - Muhammad Al Pasha - Initial Release     
*************************************************************/

IF OBJECT_ID('TC23','U') IS NOT NULL 
BEGIN
	DROP TABLE TC23
END
GO

CREATE TABLE TC23
(
   AuditTime DATETIME,
   IsOnline BIT -- 0:Down, 1:Up
);


INSERT INTO TC23(AuditTime, IsOnline)
SELECT TOP 10000 AuditTime, ABS(CHECKSUM(NEWID())) % 2
FROM (SELECT DISTINCT DATEADD(SECOND, ABS(CHECKSUM(NEWID())) % (30 * 24 * 60 * 60), '20100601') AS AuditTime
FROM tsqlc_Tally
WHERE N < 11000) AS T;