
Performance Tuning in SQL Server 7.0 by Efficient Data Retrieval
Database Programmers using interfaces APIs like ADO, DAO etc. must remain aware of the result sets they are building. One should try to reduce the size of the result set

Database Programmers using interfaces APIs like ADO, DAO etc. must remain aware of the result sets they are building. One should try to reduce the size of the result set

Use of inequality operators in SQL queries force databases to use table scans to evaluate the inequalities. These queries generate high I/O if they run regularly against large tables. You

It has become customary for Microsoft Windows users to close an active window by pressing the escape key. It is not that easy to intercept key events in Java. This

When you use Access database or other file based database with Active Server Pages (ASP), you should make sure that the directory in which the database resides is marked as

Question: How to write a text directly to printer port, such as lpt1? Answer: While there is no standard method of writing directly to a printer, you can try writing

Question: Is there a compiler or run-time option to specify whether to use static binding or dynamic binding for function calls? This option, if it exists, may actually override the

Question: Is there any way I can create scrollable forms in VB 5.0? Answer: There isn’t a simple way that I know of. If you must have scrollable screens consider

Question: I have a datawindow where I sort the data by clicking on the column header. In one of the columns I have a drop-down datawindow attached. Whenever I click

Question: Using ifstream, I want to open a file that already exists, and launch an error message if it does not exist. How can I get indication that the file