Viewing 15 posts - 1 through 15 (of 140 total)
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).
August 22, 2007 at 11:02 am
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...
August 17, 2007 at 6:59 am
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...
June 4, 2007 at 8:50 am
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...
June 4, 2007 at 5:12 am
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...
June 4, 2007 at 4:42 am
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...
June 4, 2007 at 3:45 am
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
June 1, 2007 at 8:55 am
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...
May 18, 2007 at 6:53 am
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...
February 7, 2006 at 6:24 am
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...
February 3, 2006 at 8:57 am
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...
January 31, 2006 at 10:38 am
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...
January 6, 2006 at 10:20 am
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...
April 18, 2005 at 9:43 am
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...
April 15, 2005 at 9:13 am
Make sure that the windows firewall on the laptop isn't blocking your PDS'a access.
April 15, 2005 at 8:51 am