Viewing 15 posts - 37,636 through 37,650 (of 49,566 total)
I didn't mean on your production server. Do it on a dev/test machine. Do it on a local installation of SQL if you have one.
There are standard command that are...
July 15, 2009 at 7:58 am
Oh this is fun....
Got back from shopping, booted my computer and SQL wouldn't start. Checked the error log.
The log scan number (47:112:1) passed to log scan in database 'model' is...
July 15, 2009 at 7:47 am
Lowell (7/15/2009)
there's a lot of inner joins...which part do you weant to change into a subquery?
and why?
July 15, 2009 at 7:44 am
I'm not normally a fan of hints, but what happens if you force that index?
SELECT *
FROM dbo.EmailRecipients er WITH (INDEX= SSC_SentDate)
INNER JOIN Emails e ON er.EmailID = e.EmailID
WHERE er.SentDate IS...
July 15, 2009 at 7:40 am
Why don't you use profiler? Start a trace and then run the maint plan jobs. The trace will show you exactly what they're doing.
July 15, 2009 at 7:38 am
Do you have any transactional replication configured?
Can you run DBCC OPENTRAN and post the results?
The distribution DB doesn't appear to have a problem with the log, just AX30_SP6_LIVE
July 15, 2009 at 7:27 am
Krasavita (7/15/2009)
How, do you know that?
How do I know what?
The database integrity task is a DBCC CheckDB, so it will detect any torn pages, among other corruptions if present.
I...
July 15, 2009 at 7:16 am
Jeff Moden (7/15/2009)
GilaMonster (7/15/2009)
Jeff Moden (7/14/2009)
Something else is going on as well. Look at the difference in durations on your machine compared to mine.
Look at the difference...
July 15, 2009 at 7:12 am
susan.susan28 (7/15/2009)
July 15, 2009 at 3:45 am
Asynchronous mirroring is only available on Enterprise edition. So on Standard your only option is synchronous with witness or synchronous without witness.
July 15, 2009 at 3:18 am
Mel Harbour (7/15/2009)
Note that I've adjusted the forum setup to avoid having to zip up these sqlplans.
Excellent. Thank you for that.
I'll look over this and suggest any possible...
July 15, 2009 at 3:01 am
You cannot do auto-failover without a witness server.
July 15, 2009 at 2:58 am
susan.susan28 (7/15/2009)
I am trying to setup database mirroring.Mirroring started and manual failover is possible.but when i shutdown the principal server ,mirror server is not changing to principal.
Which mode do you...
July 15, 2009 at 2:33 am
isabel (7/15/2009)
Does your command for MIRROR TO DISK supported by MS SQL Server 2000?
No, but you posted in the 2005 forum, that's why I specified 2005 features.
On SQL...
July 15, 2009 at 2:24 am
Viewing 15 posts - 37,636 through 37,650 (of 49,566 total)