The connections to the SQL-server dropped to about 40-50 on heavy load when using client side cursors. But from time to time we get these errors in...
Is there any easy way to convert all queries to use client side instead of server side without rewriting too much code? Is it possible to use...
This might be the problem! But isn't the server side cursor a forward-only and read-only cursor, sometimes called a firehose cursor, by default? And...
Yes, I know that DSN invokes overhead, but the main problem is the connections to the SQL-server. The ASP-code is generated by Macromedia Dreamweaver...
We have been trying to use a DSN-less connection: MM_SQLDB_STRING = "Provider=MSDASQL; Driver={SQL Server}; Server=xxx.xxx.xxx.xxx,yyyy;...
Drivers:<br /><br />MDAC 2.6<br />SQL Server ODBC-driver, Version 2000.85.1025.00<br /><br />---<br /><br />A typical ASP-page on our server looks...
On heavy load to our webserver we got around 80-100 connections from the webbserver to the SQL-server. We use ODBC (System DSN) and connection...
Thank you Joe! You solved the problem! I created a clustered unique index on "time" and "id" and now every query uses the index! I do not runt...
Thank you Frank! I have now rewritten the query but I still have the same problem. Why isn't it enough to create an index on only the "time" column?...
After installation of SP3 I now receive a message from Enterprise Manager when trying to create INDEX 2: "Total size of an index or primary key...
I am trying to tune a query that is returning activities of the day from a calendar. The query executes rather slowly on the SQL-server and I have...
Separate names with a comma.
