Viewing 15 posts - 1 through 15 (of 16 total)
I think it is because the query optimizer cannot decide as accuratately with a variable as with a value. Is is described in this article http://www.microsoft.com/sql/techinfo/tips/development/July16.asp
which applies to...
December 5, 2003 at 1:31 pm
Locks were: config value 10000, run value 10000. Now I changed this to zero.
After the error I put the /3GB switch in the boot.ini file.
October 23, 2003 at 11:23 pm
sp3 is installed, SQL 2000 ent. on windows 2000 adv. server, 8 CPUs and 8GB RAM (/3GB,/PAE,AWE enabled).
Temp tables are used to prepare data and satisfy key uniqueness. What...
October 23, 2003 at 9:10 am
I would say they do in the light of my previous posting on Feb 18, 2003.
February 24, 2003 at 1:27 pm
I also use SQL 2000 Standard Edition on a new IBM Server with two processors which replaced an older and less capable Compaq server. We see no performance gain at...
February 18, 2003 at 1:47 pm
Does anyone know whether an IBM 10 disk array can be configured with two drives mirrored and the rest in a RAID 5 or 10 ?
February 13, 2003 at 1:54 pm
It is quite clear, but what about the original question on where to place a cursor's declaration?
September 20, 2002 at 12:22 pm
Thats ok. But is it always possible to avoid using a cursor? How to loop through a recordset and make some calculations and updates?
September 19, 2002 at 1:11 pm
You are right! It was SQL Server agent not running.
May 29, 2002 at 1:56 pm
There was nothing logged in maintenance history and I didn't see any error reported. Where can I look for errors?
May 26, 2002 at 2:14 am
I had a similar experience where on an NT 4.0 server with 500 MB free on the HD I tried to restore a 35 MB backup of a DB with...
May 24, 2002 at 2:38 pm
Viewing 15 posts - 1 through 15 (of 16 total)