1 Fragmented Table Creation

BEGIN TRAN





select  top 1000000
row_number () over ( order by (Select null)) n into Numbers from
sys.all_columns  a cross  join  sys.all_columns




CREATE TABLE [DBO].[FRAG1] (
Primarykey int NOT NULL ,
SomeData3 char(300) NOT NULL )



INSERT INTO [DBO].[FRAG1]
SELECT
n ,

'Some text..'

FROM Numbers

Where N/2 = N/2.0




ALTER TABLE DBO.[FRAG1]
ADD CONSTRAINT PK_FRAG1 PRIMARY KEY (Primarykey)

--500000
Update DBO.[FRAG1] SET Primarykey =  Primarykey-500001
Where  Primarykey>500001










GO

drop table [DBO].FRAG2

CREATE TABLE [DBO].FRAG2 (
Primarykey int NOT NULL ,
SomeData3 char(500) NOT NULL )



INSERT INTO [DBO].FRAG2
SELECT
n ,

'Some text..'

FROM Numbers

Where N/2 = N/2.0







ALTER TABLE DBO.FRAG2
ADD CONSTRAINT PK_FRAG2 PRIMARY KEY (Primarykey)

--500000
Update DBO.FRAG2 SET Primarykey =  Primarykey-500001
Where  Primarykey>500001








GO


CREATE TABLE [DBO].FRAG3 (
Primarykey int NOT NULL ,
SomeData3 char(1000) NOT NULL )



INSERT INTO [DBO].FRAG3
SELECT
n ,

'Some text..'

FROM Numbers

Where N/2 = N/2.0




ALTER TABLE DBO.FRAG3
ADD CONSTRAINT PK_FRAG3 PRIMARY KEY (Primarykey)

--500000
Update DBO.FRAG3 SET Primarykey =  Primarykey-500001
Where  Primarykey>500001







GO




CREATE TABLE [DBO].FRAG4 (
Primarykey int NOT NULL ,
SomeData3 char(2000) NOT NULL )



INSERT INTO [DBO].FRAG4
SELECT
n ,

'Some text..'

FROM Numbers

Where N/2 = N/2.0




ALTER TABLE DBO.FRAG4
ADD CONSTRAINT PK_FRAG4 PRIMARY KEY (Primarykey)

--500000
Update DBO.FRAG4 SET Primarykey =  Primarykey-500001
Where  Primarykey>500001











COMMIT