• Thanks Jeff, Here is the script I am running and using perfmon I am measuring page splits/sec.

    CREATE TABLE [dbo].[Tab1](

    [ORG_KEY] [bigint],

    [PROD_KEY] [bigint],

    [TIME_KEY] [bigint],

    [CST_NON] [float],

    [CST_RPL] [float],

    [RTL_NON] [float],

    [RTL_RPL] [float],

    [UNT_NON] [float],

    [UNT_RPL] [float],

    [UPDATE_DATE] [datetime]

    )

    with all the columns allows null

    CREATE UNIQUE CLUSTERED INDEX [IX_ORGKEY] ON [dbo].[Tab1]

    (

    [ORG_KEY] ASC

    ) with all the default value and fill factor of 100.

    DECLARE @cnt INT

    SET @cnt = 1

    WHILE @cnt <= 100000

    BEGIN

    INSERT INTO Tab1 VALUES(@cnt,19280,10255,250,500,350,450,375,275,GETDATE())

    SET @cnt = @cnt + 1

    END