October 7, 2008 at 9:20 am
can you tell me which method is better and why ? and when to implement?
1. Drop and recreate Indexes
2. DBCC DBREINDEX
3.DBCC INDEXDEFRAG
4. Rebuild indexes
5. Reorgnize indexes
October 7, 2008 at 9:31 am
The easy answer is It Depends. Read the Books online sections on each of these. That will help give you a good understanding of what each one does. Then perhaps you could post a more specific question about what to use in your situation and we could give you a better recommendation.
-Luke.
October 8, 2008 at 2:16 pm
i have error like
the index entry for row id 94 was not found in index id 121348304584
now which method need to do and why?
October 8, 2008 at 2:23 pm
None of the above. You've got database corruption. Please run the following and post the results.
DBCC CHECKDB(< Database Name > ) WITH NO_INFOMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 2:31 pm
hi
my db is around 1000 gig ? checkdb will take lot of time
need some alternate fastest solutions
October 8, 2008 at 2:39 pm
Yes, it will take time. Probably a couple of hours. You still need to do it.
At this point you have an unknown amount of corruption of unknown severity in that database. I can't suggest a solution to that without getting rid of the unknowns. The only way to do that is to run a full database integrity check
If you just want to check the one table, then use DBCC CheckTable, with the same options. If you do that, post the results.
I strongly suggest you run a checkDB as soon as possible. There may be other tables corrupt, there may be damage to allocation structures, etc. We just don't know
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 2:42 pm
the below things are not good?
1. Drop and recreate Indexes
2. DBCC DBREINDEX
3.DBCC INDEXDEFRAG
4. Rebuild indexes
5. Reorgnize indexes
i can do check table but it will lock table right?
October 8, 2008 at 2:47 pm
Maybe, maybe not. It depends on how bad the corruption is. No way to tell without seeing the results of CheckTable or CheckDB.
In SQL 2000 I think it does take locks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 8:34 am
Would you pleae humor my curiosity and give a short description of what kind of an application generates a terabyte of data ?
October 9, 2008 at 10:20 am
J (10/9/2008)
Would you pleae humor my curiosity and give a short description of what kind of an application generates a terabyte of data ?
A bank's trading system for one. One of those I worked on hit 1.2 TB just before I left.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 5:10 pm
J (10/9/2008)
Would you pleae humor my curiosity and give a short description of what kind of an application generates a terabyte of data ?
SAP
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply