The problem resolved. It is due to the users are connecting to the network without logging into the domain. Thank you very much for your help!! I...

We only have Default instance. He cannot log into the server while he was in the company i.e. local network. And guess what, now I have another user who...

Yes. Is this has anything to do with MDAC?? The server is using TCP/IP and Name Pipes.

By the way, the user usually use the same laptop...

Thanks!

Thanks a lot, Chris!

Thanks - Allen and Jay!!

Yes, Calvin, I read about identity column and Clustered index. Since I am new to this database, I would like to observe more before I start changing things.

And, Jay,...

CREATE TABLE [dbo].[CheckQueue] (

[CheckQueueKey] [int] IDENTITY (1, 1) NOT NULL ,

[AppUser] [int] NULL ,

[CmdCodeKey] [smallint] NOT NULL ,

[CustomerKey] [int] NULL ,

[RequestDate] [datetime] NOT NULL ,

[ResponseDate] [datetime] NULL ,

[CheckQueueCodeKey] [smallint] NULL...

Try this: DBCC DROPCLEANBUFFERS

Yes, this is a very highly transactional table. There are about 10 processes querying and updating this table every other seconds...

Yes, I have clustered index in the table. And yes, I use dbcc DBREINDEX to rebuild first the clustered index, and then the rest of the nonclustered indexes. ...

Yes, the index does help me a lot when there are values in the field.

This is a very important table and changing the table structure would mean an...

Actually, all the 3 indexes are based on the int data type.

Let's say I do need the indexes, disregarding the selectivity. What can I do in order...

I have 3 columns with the same situation. The percent null for the 3 columns are around 40%, 65% and 92%. The table bas 2.5 million records...