Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Access table is very slow in sql2005

Author  Topic 

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2011-06-27 : 00:17:16
Dear Member

In my database one of table their is 25 Lakhs Records. Which are increasing day to day . we have multiple transaction of this table like insert,update and delete record.

In my problem i will access this table in my application it is working very slow. i have try open this table in smo in sql2005 but its very slow open.

So what is the reason why its slow it is effect of high size of record or any other
please tell me any process in sql to fast working this table.


Thanks in Advance
   

- Advertisement -