Viewing 15 posts - 12,376 through 12,390 (of 49,552 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...
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
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...
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
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...
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
July 15, 2013 at 4:57 am
hvermaak (7/15/2013)
Brandie Tarvin (7/15/2013)
GilaMonster (7/15/2013)
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
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?
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
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...
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
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?
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
July 15, 2013 at 3:30 am
Autoshrink on? Manual shrink operations?
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
July 15, 2013 at 2:45 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?
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
July 15, 2013 at 2:35 am
ramanathan.raman88 (7/15/2013)
File 'sample' cannot be restored to 'C:\Program Files\Microsoft...
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
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...
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
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...
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
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...
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
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...
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
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....
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
July 14, 2013 at 5:23 am
Viewing 15 posts - 12,376 through 12,390 (of 49,552 total)