the main bulk of the time is the insert into the 'clone' table from the source table ..that takes 45 mins..recreating the keys etc only takes a couple of minutes...

LutzM (11/15/2013)

---

how did you test the two options?

Using Management Studio and the table design wizard or a query window and the T-SQL command?

If the former (design wizard) then you should...

sure, 1.6 mil rows in

CREATE TABLE [dbo].[MyTable](

[MyID] [int] NOT NULL,

[MyCode] [varchar](15) NOT NULL,

[MyNumber] [decimal](2, 0) NOT NULL,

[MyDate] [datetime] NOT NULL,

[My_XML] [text] NOT NULL,

[MyGuid] [uniqueidentifier] NOT NULL,

CONSTRAINT [PKey_MyTable] PRIMARY...