Because the ASP engine reads and interprets every character in the file, adding comments in the ASP page increases the work of the IIS. Although the HTML page that is
It is a good idea to build a separate error-handling ASP page and call it from the code whenever it is required. Besides being a modular approach, it also improves
A common user scenario in a development environment is where the code typically opens a connection, executes a row or non-row returning command, processes results, and closes the connection. For
The File DSN usage should be avoided whenever possible. Instead, use System DSN; it is, on average, twice as fast. Also, File DSN is less secure because the database name,
SQL Trace can monitor, filter, and record all of the calls sent from the client applications to the server. It often reveals unexpected application overhead due to unnecessary calls to
RDO is an object interface that is closely tied to ODBC and is optimized for accessing SQL Server databases, especially from Visual Basic programs. It has little performance overhead on
ADO 2.0 includes few optimizations when it is marked as an Apartment model in the Registry. It determines the threading model from the Registry at DLL load time. The scaling
Question: How do I find out the top-five best sale items? I want the maximum five items to be listed. Answer: In version 7, SQL Server has conveniently provided the
Question: What is faster: two LIKE statements or one BETWEEN? ((MyData LIKE ‘02105_’) OR ((MyData LIKE ‘02106_)MyData BETWEEN ‘021050’ AND ‘021069’ Please advise. Answer: When trying to decide which is