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: 143
Filed under:
sql-server
|sql-server-7
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
