Viewing 15 posts - 40,336 through 40,350 (of 49,552 total)
RBarryYoung (3/16/2009)
Steve Jones - Editor (3/16/2009)
The award is supposed to include lots of technical merits, but I'm not sure that the judges know what is technical and what isn't. ...
That's...
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
March 16, 2009 at 1:31 pm
JacekO (3/16/2009)
So going back to my question about Identity (INT - fixed lenght datatype) with Fill Factor of 100% - that should work fine and avoid the page...
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
March 16, 2009 at 9:54 am
Jeff Moden (3/16/2009)
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
March 16, 2009 at 9:38 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic676411-146-1.aspx
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
March 16, 2009 at 9:22 am
callum.bundy (3/16/2009)
At the moment I run weekly maintenance plans (the wizard created ones in management studio) that do Database checks, re index, reorganise and shrink.
Bad combination of tasks. The reindex...
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
March 16, 2009 at 9:21 am
swmsan (3/16/2009)
Yes...have done that...but size doesn't reduce..It shows me the same size
It won't. Log backups make the space within the file available for reuse. They don't decrease the file size....
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
March 16, 2009 at 9:17 am
Can you post the query?
Is the database that Crystal is querying in compat mode 90?
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
March 16, 2009 at 9:16 am
JacekO (3/16/2009)
Gail,Does your answer assume the index is clustered?
Clustered or nonclustered with variable-width key or include columns.
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
March 16, 2009 at 9:13 am
Bagath (3/16/2009)
Dropped and re-created the default constraint for the table and ran the CHECKCATALOG command successfully.
Yup, that is the way to fix schema-related errors like that. If CheckCatalog is clean,...
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
March 16, 2009 at 1:41 am
I think the best bet here is to restore that clean backup that you said you had and apply transaction log backups (if you have any of those) to get...
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
March 15, 2009 at 4:17 pm
Steve Jones - Editor (3/15/2009)
I don't think I met Mangal up there.
I suspect he wasn't there. The whole 'Answered Posts' yelling match occurred during Summit.
Steve Jones - Editor (3/15/2009)
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
March 15, 2009 at 12:14 pm
Double post. Nevermind.
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
March 15, 2009 at 12:10 pm
I'm confused.
murthykalyani (3/13/2009)
Server: Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc...
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
March 15, 2009 at 12:00 pm
It means that you corrupted a page that gets checked during the attach. That's why I said "if it attaches successfully". Restore a backup, detach and write over in a...
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
March 15, 2009 at 5:18 am
RBarryYoung (3/14/2009)
OK, this is the most disturbing thing that I have read in a while. Read it closely. Brrrr...
Hey, look on the bright side. Jonathan and Jacob got...
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
March 15, 2009 at 2:14 am
Viewing 15 posts - 40,336 through 40,350 (of 49,552 total)