April 27, 2005 at 9:20 am
Hi,
I'm newer on SQL Server, but I've this problem:
I've an application who insert some record (about 1000) each minute in a table using ODBC, but when a scheduled reindex of an other table occurs ( and take about 6 minute), my application can't insert data and return a generic error ODBC - connection failed, What is wrong? The reindex statement
Thanks.
Domenico
April 27, 2005 at 9:24 am
From BOL:
DBCC DBREINDEX is an offline operation. While this operation is running, the underlying table is unavailable to users of the database.
hth
* Noel
April 27, 2005 at 10:06 am
You should probably schedule the reindexes for very, very low use times or setup the application to try reconnecting after a few minutes.
April 28, 2005 at 3:00 am
Hi,
thanks for info, but when is very necessary to recreate index in a SQL Server Table?
April 28, 2005 at 3:07 am
That depends on how the table is used. If an index becomes fragmented then it shuold be defragmented, for instance by using reindex. But there arealso other ways, such as DBCC INDEXDEFRAG which is an online operation. See Fragmentation 101 for some information.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply