can't select/delete a record set from a table

Question

Post reply

can't select/delete a record set from a table

jzhou

SSCommitted

Points: 1863
More actions
September 23, 2003 at 11:59 am

#82265

I insert a record set to a table. Then I found that it takes forever to select the new record set. I now even can't delete the record set or truncate the table. However, selecting or deleting other record sets in this table works ok. How can I do? A quick help is appreciated.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

philcart SSC-Forever Points: 47797 More actions · Answer 1

Can you provide an idea of what your table structure and indexing looks like?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

--------------------
Colt 45 - the original point and click interface

jzhou SSCommitted Points: 1863 More actions · Answer 2

My table is a very simple table, as shown below:

CREATE TABLE [dbo].[sim_PriceData] (

[PriceID] [int] NOT NULL ,

[TimeID] [int] NOT NULL ,

[DataSource] [int] NOT NULL ,

[Price] [float] NULL ,

[MaxPrice] [float] NULL ,

CONSTRAINT [PK_sim_PriceData] PRIMARY KEY CLUSTERED

(

[PriceID],

[TimeID],

[DataSource]

) ON [PRIMARY]

GO

CREATE INDEX [i_PriceID] ON [dbo].[sim_PriceData]([PriceID]) ON [PRIMARY]

GO

CREATE INDEX [i_TimeID] ON [dbo].[sim_PriceData]([TimeID]) ON [PRIMARY]

GO

CREATE INDEX [i_DataSource] ON [dbo].[sim_PriceData]([DataSource]) ON [PRIMARY]

GO

From the Enterprise Manager, I found that there is a process is locking this table. What is the nicest way to unlock this table from the process?

philcart SSC-Forever Points: 47797 More actions · Answer 3

The nicest way is to let the other process complete whatever it's doing

The nastiest is to issue the KILL command to terminate it

Before you get nasty, do some further investigation to determine why the other process is causing problems. Maybe there is an update that hasn't been committed.

Take a look at the following articles,

http://support.microsoft.com/default.aspx?scid=kb;en-us;283725&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;295108&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;224453&Product=sql2k

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Edited by - phillcart on 09/23/2003 7:09:56 PM

Edited by - phillcart on 09/23/2003 7:11:24 PM

--------------------
Colt 45 - the original point and click interface