Enable Row Set Paging in a Client/Server Environment Using SQL
by Michael Sansoterra

One of the general paradigms of client/server programming is keeping the server side processing 'fat' while keeping the client side processing 'thin.' That is, a client/server application should let a server do as much work as possible while making as few assumptions as possible about how much processing power, memory, network bandwidth, etc., the client will have. Of course, sometimes certain applications, such as those requiring a graphics intensive environment, must be heavy on the horse power, but in general it's good practice to keep network, memory, and processing requirements minimal on the client side. READ MORE >

The Case of the Used Unused Object: A Mystery
Hey, Ted:

Put on your deerstalker hat. I've got a mystery for you. We are cleaning up disk and stumbled upon something that has us puzzled. The system tells us that a logical file in a test library has been used many times, and according to the object description, was recently used. None of our programs use the file, and no one has used the test library for a long time. Why does the system tell us we're using a file that we don't use? READ MORE >