Make sure that you have the same version of the Oracle client software (SQL*Net) on both servers (and use the ODBC driver that comes with it).

dbcc checkdb needs free space in TEMPDB. Try DBCC CHECKDB WITH ESTIMATEONLY to see how much tempdb space is needed and make sure you can get it. Also, if you...

I take it back. With this simple example it doesn't seem make any difference when I checked further. It is more useful when there are more than two tables joined together.

What I was suggesting was...

Rule one of support...find out what has changed. Has someone just updated some of the SQL?

Also, check for any errors in the SQL server logs. If you see any errors...

Try moving the filter condition on table a from the WHERE clause to the ON clause. This generally speeds up most queries, as the WHERE clause is not applied until all the records...

Could be timing out while McAfee scans the transaction log file when it is opened (in memory) to be written to by the database. Stop McAffee monitoring files opened in...

You can use the last DOS version of PKZIP.exe to unzip zipped file. PKZIP is old but still works. It can be downloaded from http://www.salokin.demon.co.uk/dos_utils.htm

Regards

Peter

Check that the SQL server and SQL Server Agent service is running under a domain logon account. If it is running as the default 'local system' account on the server then...

DCOM allows you to start com+ (activex) components executing on another pc or server, but you need to have the correct permission and it needs various services to be running on that...

If he is performance tuning a system that is being developed (the code) then it is an ideal job for one of the developers on the project. But, it wouldn't be necessary...

Make sure that your windows firewall is disabled and that the services needed for DCom to work are running. I am not absolutely sure what the services are but the...

Famous Groucho Marx sayings:

Behind every great man is a woman. Behind her is his wife

I don't want to join any club that would have me as a member

Time flies like an...

What I find useful with problem DLLs is using Dependency Walker to see what version of DLLs are called by the problem DLL. Then either copy those client DLLs onto your test PC...

You could use a stored procedue on the main site to do the merge. Or, you could use the built in Replication facility - see 'Books Online'. This is what replication is...

Make sure that the windows firewall on the laptop isn't blocking your PDS'a access.

Peter