declare @begin datetime, @end datetime;
select @begin = '1912-04-05T11:23:45', @end = '2048-12-17T23:57:18';

select @begin as [begin], @end as [end], cast(cast(@begin as float) + (cast(@end as float) - cast(@begin as float)) * rand() as datetime) as [random date];

SET NOCOUNT ON
GO

BEGIN tran;

CREATE TABLE #AG_T
(
 AG_NUM INT, 
 AG_STR NVARCHAR(1), 
 AG_ORG_FK INT, 
 AG_ORG_SIMPLE_INT INT, 
 AG_ORG_INDEX INT,
 AG_DATE datetime
);

CREATE NONCLUSTERED INDEX [NonClusteredIndex-XXX] ON #AG_T
(
 AG_DATE ASC
);

declare @begin datetime = '2000-01-01T00:00:00', @end datetime = '2013-12-31T23:59:59';

INSERT INTO #Ag_t
	(
		Ag_num,
		Ag_str,
		Ag_org_fk,
		Ag_org_simple_int,
		Ag_org_index,
		Ag_date
	)
	SELECT TOP 5000000
		CONVERT(int, CONVERT(binary(4), NEWID())),
		CONVERT(nvarchar(1), CONVERT(binary(2), NEWID())),
		CONVERT(int, CONVERT(binary(4), NEWID())),
		CONVERT(int, CONVERT(binary(4), NEWID())),
		CONVERT(int, CONVERT(binary(4), NEWID())),
		CAST(CAST(@Begin AS float) + (CAST(@End AS float) - CAST(@Begin AS float)) * RAND() AS datetime)
	FROM Sysobjects O1, Sysobjects O2, Sysobjects O3, Sysobjects O4;

SELECT
	@@Rowcount;

SELECT
	*
FROM #Ag_t
WHERE Ag_date > '2007-01-01T00:00:00';

DROP TABLE #Ag_t;
 
COMMIT tran;

RAND(CHECKSUM(NEWID()))

select RAND(CONVERT(int, CONVERT(binary(4), NEWID())))