Why do I have such high overhead when creating tables in MSSQL7?

Posted by scotty2012 on Server Fault See other posts from Server Fault or by scotty2012
Published on 2009-08-17T15:27:31Z Indexed on 2010/05/06 14:38 UTC
Read the original article Hit count: 149

Filed under:
|

I have an old system running MSSQL7. It takes about 10.5 seconds to create the table below and another 30 seconds to add the index. Is there anything I can do to decrease these times?

CREATE TABLE [dbo].[MyTable] (
    [queue] [int] NOT NULL ,
    [seqNum] [numeric](12, 0) NOT NULL ,
    [cTime] [char] (14) NOT NULL ,
    [msg] [char] (255) NULL ,
    [status] [int] NOT NULL ,
    [socket] [int] NULL 
) ON [PRIMARY]
GO
 CREATE  INDEX [search] ON [dbo].[MyTable]([queue], [seqNum], [status]) ON [PRIMARY]
GO

 CREATE  INDEX [new] ON [dbo].[MyTable]([queue], [status]) ON [PRIMARY]

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-7