Viewing 15 posts - 7,006 through 7,020 (of 18,926 total)
Assuming the question is directed to me.
I do the daily tlog daily because we are on full rather than simple (didn't want to make thing even worse) and I want...
March 18, 2011 at 2:10 pm
Oh crap, I know I should have checked that one myself... never take the word of someone online when you think they're wrong! :w00t:
Looks like we misunderstood each other...
March 18, 2011 at 2:02 pm
His reply will be known next week because we're both heading out for the week-end now.
Thanks again and keep 'em coming!
March 18, 2011 at 10:43 am
Actually we do have 3 days of full and log backups and in this case the live db and tlog.
So while it would be a pita I guess it could...
March 18, 2011 at 10:42 am
WayneS (3/18/2011)
Well, the execution plan is suggesting that you can get a 70% improvement by adding this index...
USE [FINRISK]GO
CREATE NONCLUSTERED INDEX [IX_T_REPORTSTATUS_Cover] -- rename as appropriate
ON [dbo].[T_REPORTSTATUS] ([ProfileName],[DomainName])
INCLUDE ([COBDate],[BookName],[SystemName],[AdapterName],[ReportName],[RerunCount],[Status],[RunNumber])
Agreed but...
March 18, 2011 at 10:29 am
Ian Scarlett (3/18/2011)
Ninja's_RGR'us (3/18/2011)
No he's actually really smart, and he never had problems with "his" stuff. Hence my "what if" has very little weight.
Sound as if a little "accident"...
March 18, 2011 at 10:10 am
homebrew01 (3/18/2011)
Maybe someone in the business end needs to know they have...
March 18, 2011 at 10:00 am
Maybe so from you pov, however even bad programmers still need multiple spaces to actually see what's going on!
March 18, 2011 at 9:53 am
homebrew01 (3/18/2011)
Only up to the point of your most recent t-log...
March 18, 2011 at 9:32 am
homebrew01 (3/18/2011)
What is the reason for not taking frequent t-log backups ? I can't think of any.
Same here. I'm consulting as BI dev here and since I'm not...
March 18, 2011 at 9:30 am
Ian Scarlett (3/18/2011)
Ninja's_RGR'us (3/18/2011)
admin doesn't want to take tlog during the day because he feels it can't possibly breakNo need to take ANY backups then :-D.
Awesome comeback!!! He actually...
March 18, 2011 at 9:28 am
anglincis (3/18/2011)
I've been coding for a few years now but still not with the level of technical expertise as shown in some of these posts. So can someone please comment...
March 18, 2011 at 9:23 am
GilaMonster (3/18/2011)
Ninja's_RGR'us (3/18/2011)
He had me do 2 full daily and then hope we could take a tail tlog backup to do p.i.t. restore.
Tail log requires that the log file is...
March 18, 2011 at 9:18 am
On top of the exec plan, what other indexes do you have on the table?
March 18, 2011 at 9:09 am
Viewing 15 posts - 7,006 through 7,020 (of 18,926 total)