Viewing 15 posts - 39,106 through 39,120 (of 49,571 total)
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
May 15, 2009 at 3:00 am
Christopher Stobbs (5/15/2009)
When you say that a Clustered index is included in every non-clustered index, what do you mean by this?
The clustering key is the row's identifier. Hence it is...
May 15, 2009 at 2:56 am
Depends what's wrong
Please run this and post the full results:
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup?
May 15, 2009 at 2:55 am
Ahhh!!!! Damn it! Twice this year!
Flat broken into again last night. Among other things, took the zune that I bought to replace the ipod that they stole last bloody time.
As...
May 15, 2009 at 2:53 am
mikeandanne (5/14/2009)
They are trying to restore the log to rebulid the db from the transactions.
Can you elaborate?
May 14, 2009 at 2:59 pm
May 14, 2009 at 2:59 pm
Please read through the article I linked. You're still missing the table definition (as a create table) and that sample data's going to be hard to use in it's current...
May 14, 2009 at 2:56 pm
Why are you rebuilding the log? What happened to the existing log file?
Two options.
1) Restore from last backup. Recommended
2) Hack the DB back into the server, do an emergency mode...
May 14, 2009 at 2:43 pm
Bob Hovious (5/14/2009)
On Qo'noS, none rise to the rank of Klingon Senior DBA except over the bloody bodies of their fallen predecessors.
And that's different from current-day corporates how?
May 14, 2009 at 2:32 pm
TcW_1978 (5/14/2009)
So it seems the table is not corrupted, back to square one...
Nope. No corruption.
What's the error messages that you're getting?
May 14, 2009 at 2:31 pm
Paul Randal (5/14/2009)
The sysindexes errors are corruptions in the statistics blobs - you should be able to get around those by dropping and recreating all your statistics.
Drop and recreate all...
May 14, 2009 at 2:28 pm
TcW_1978 (5/14/2009)
Is it possible that a single table is corrupted and not the entire database?
Yes, absolutely. That's the more common form of corruption, just a single page.
What's the error that...
May 14, 2009 at 11:45 am
I'll look at the plans later. Just one thing now. That's a very big clustered index. Clustered indexes should be as narrow as possible because they're included in every nonclustered...
May 14, 2009 at 11:29 am
Ok, two things.
1) This is not completely repairable.
2) You're going to lose data and you probably already lost a lot in the previous repair
I suspect (and will get a second...
May 14, 2009 at 10:59 am
Highly likely it's a statistics problem. If SQL estimates a small number of rows it's likely to use a loop join.
Please post query and exec plan (without hash join hint)
May 14, 2009 at 10:34 am
Viewing 15 posts - 39,106 through 39,120 (of 49,571 total)