Viewing 15 posts - 17,851 through 17,865 (of 22,202 total)
GilaMonster (3/30/2009)
Lynn Pettis (3/30/2009)
Just what do the users expect us to do???Read their minds, pull out a magic wand and make the nasty error go away, of course.
😉
You forgot quickly....
March 30, 2009 at 5:59 pm
I agree with Paul. Do a FULL SCAN when you update the statistics.
March 30, 2009 at 5:58 pm
Oh man, thousands... network connectivity, security, service shut down, changes to connection strings... Those are just the easy ones. It could be client configuration changes... It's really hard to say.
March 30, 2009 at 1:28 pm
Actually I would have expected that to be a problem in 2000 as well. All 2000 is doing is an implicit convert, that you should get in 2005 as well....
March 30, 2009 at 1:26 pm
Looks like you either have a connection error, or possibly your DTC process is down:
Microsoft.CommerceServer.Runtime.CommerceException: [highlight=#ffff11]Could not connect to datasource [/highlight]---> System.Runtime.InteropServices.COMException (0x8004D00A): [highlight=#ffff11]New transaction cannot enlist in the specified...
March 30, 2009 at 1:17 pm
You could run DBCC UPDATEUSAGE. It's possible the allocation information is messed up because of dropped objects, large scale data changes, etc.
March 30, 2009 at 12:42 pm
I would start on a problem like this down one of two paths. Either I feel like I know the query & indexes well enough that I'm going to look...
March 30, 2009 at 12:33 pm
First, if you can define them, get foreign key constraints in place. As the last post said, you're looking at a loss of data integrity. That's worse than any performance...
March 30, 2009 at 12:26 pm
I'd use the method of creating a new copy of the table with all the right structures, migrate the data over, then drop the other table and it's FK's,...
March 30, 2009 at 12:23 pm
My memories of 6.5 are fuzzy (and painful) but I think you could backup directly to disk even then, but I could be wrong.
The one reason I can think of...
March 30, 2009 at 12:10 pm
First disable the automatic affinity in the check box below.
March 30, 2009 at 9:27 am
Did you run the Database Tuning Advisor against that system? That looks like artifacts from there. Statistics usually have look something like _WA_SYS_0000003_0425A276.
March 30, 2009 at 9:24 am
To your first question, neither of those tables looks terribly fragmented. When the logical fragmentation breaks 30%, you might want to consider reorganizing the index. As it gets more fragmented...
March 30, 2009 at 9:20 am
Is it possible the statistics are out of date? Maybe it's working harder to gather information on some servers compared to others because of the status of the statistics.
March 30, 2009 at 9:10 am
Viewing 15 posts - 17,851 through 17,865 (of 22,202 total)