Viewing 15 posts - 16 through 30 (of 45 total)
Update: I have set the MAXDOP to 1 and wanted to see if that helped. So far, yes, it has. I'm going to run a trace to verify that the...
August 29, 2006 at 11:25 am
Mike, how do I remove the patch if it doesn't go right? I've got the installation program for it.
August 28, 2006 at 11:14 am
Also, I don't want to remove SP4 (as it was preinstalled), I just want to make sure if I patch it to 2187 and it messes something else up, I...
August 28, 2006 at 9:08 am
How do I add hints without having access to the code that is generating the queries? The indices being skipped are the primary keys of the table in both traces.
The...
August 28, 2006 at 8:56 am
I'll try patching SQL Server, setting maxdop to 1 (I'll try it anyway, even with HT disabled, can't hurt), dropping the server memory to 2048MB and doing the BCP this...
August 25, 2006 at 1:34 pm
No, wait, I do see the MAXDOP setting in sp_configure. It's set to 0 on both machines. I didn't notice it before.
August 25, 2006 at 11:48 am
I'm going to have to do the BCP over the weekend with no activity on the current system, and that is why I havent' said anything about it.
I don't know...
August 25, 2006 at 11:38 am
The reason this came up in the first place was that a query on the old server that took maybe 15 seconds to run is taking more than a minute...
August 25, 2006 at 11:17 am
Also, I did a search on Infoseek and all I saw was articles that seemed to say that SP4 was the cure-all for SQL Server 2000. I guess I could...
August 25, 2006 at 8:39 am
Priority Boost is enabled on the old server, disabled on the new server (I was told never to use this option)
Remote Query Timeout is 600 on the new server, 0...
August 25, 2006 at 8:37 am
Enterprise Manager shows 8.00.2039 as the version. It's SQL Server Standard, so I don't know what good the /3GB switch would do (both machines are running SQL Server 2000 Standard...
August 25, 2006 at 6:08 am
One problem is that I don't have access to the code and I was under the impression that index hints only work within a query, which is hidden in a...
August 24, 2006 at 1:16 pm
I have gotten a recommendation from our application developers to use the script wizard to drop and recreate the tables and indices, then use BCP to load the data in.
I...
August 24, 2006 at 1:02 pm
Everything I saw in Google stated that it was a problem with either .NET or with Access Violations. Our app server is running Tomcat and no AV's have been reported
Also,...
May 24, 2006 at 9:50 am
As per your suggestions, I have retooled the query and added indices to no avail.
I have put a non-clustered index on the table TXUYUV00 involving UBLA, UBNR and USL1, and...
May 15, 2006 at 12:55 pm
Viewing 15 posts - 16 through 30 (of 45 total)