Viewing 15 posts - 40,351 through 40,365 (of 49,571 total)
Can you explain more about the issues with SSIS and SSRS? I know of some problems with SSIS, hadn't run into any SSRS ones.
I agree with you on the 32...
March 16, 2009 at 2:39 pm
You can restore either full backup followed by all the logs, in sequence, since that backup. Full backups do not truncate the log.
Backup A
Log backup 1
Log backup 2
Log backup 3
Backup...
March 16, 2009 at 1:41 pm
callum.bundy (3/16/2009)
PS if its still making huge changes, can I drop the reorganise?
Not a good idea. You should either rebuild or reorganise indexes relatively regularly. If you don't want to...
March 16, 2009 at 1:34 pm
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...
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...
March 16, 2009 at 9:54 am
Jeff Moden (3/16/2009)
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
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...
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....
March 16, 2009 at 9:17 am
Can you post the query?
Is the database that Crystal is querying in compat mode 90?
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.
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,...
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...
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)
March 15, 2009 at 12:14 pm
Viewing 15 posts - 40,351 through 40,365 (of 49,571 total)