Viewing 15 posts - 12,376 through 12,390 (of 49,557 total)
That is corrupt beyond the point of being able to identify objects. You've got fatal metadata corruption and allocation page corruption.
You're going to be very lucky if you get much...
July 15, 2013 at 6:30 am
2000 questions should go in the SQL 2000 forums.
You have database corruption, so that object id is very likely invalid, especially given the nonsensical index id listed (max index id...
July 15, 2013 at 5:11 am
You've got database corruption.
The table name will be printed as part of the CheckDB output. Please run the following and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH...
July 15, 2013 at 4:57 am
hvermaak (7/15/2013)
Brandie Tarvin (7/15/2013)
GilaMonster (7/15/2013)
July 15, 2013 at 4:51 am
ChrisM@Work (7/15/2013)
Edit - removed RESULTNUMBER, it's the cluster key.
Why? What if someone changes the clustered index?
July 15, 2013 at 4:36 am
ananda.murugesan (7/15/2013)
as per query that well parameterized and again index seek 50 %.. please explain me?
Well, the cost has to be somewhere. Percentages have to add to 100% or they're...
July 15, 2013 at 4:35 am
ananda.murugesan (7/15/2013)
But NC clustred index seek 50% and .. what could be issues?
And that's a problem why?
July 15, 2013 at 3:30 am
No, you don't need to fiddle with the fill factor to rebuild an index.
Is it an index or is it a heap?
July 15, 2013 at 2:35 am
ramanathan.raman88 (7/15/2013)
File 'sample' cannot be restored to 'C:\Program Files\Microsoft...
July 15, 2013 at 1:31 am
What exactly do you mean by 'restore as a temp database'? If you mean one you'll drop soon, that's no different from a normal database so just use the RESTORE...
July 15, 2013 at 1:26 am
One of the worries I have when travelling is that I have my passport, ID book and driver's licence with me all at the same time. It's one of the...
July 15, 2013 at 1:22 am
sweetmoulali (7/14/2013)
I would like to share one of my views on files i.e. same file (with same logical name) could not be added in 2 databases.Is that correct?
Same logical name...
July 15, 2013 at 1:20 am
Neeraj Prasad Sharma (7/15/2013)
p.s. Plan costs != query performance. Don't make that mistake. If you want to compare performance, compare performance not estimated numbers.
please explain, This could be eye opener.
Since...
July 15, 2013 at 1:17 am
sweetmoulali (7/14/2013)
IBy this we can say it allowed same file group for 2 databases.
No, what you've done is add a filegroup to each database and given it the same name....
July 14, 2013 at 5:23 am
Viewing 15 posts - 12,376 through 12,390 (of 49,557 total)