devxlogo

Tip Bank

Watching Index Use

Question: The goal is to watch queries for their use, nonuse, or abuse of indices (using SQL Server 6.5). One of the problems is to be sure that a given

SysTray Popup Menu

Question: I’ve used your technique for getting the icon in the tray and for being notified when the user has clicked on it, but I’m having a problem getting a

Testing String Equality

Question: This is a section from a program I am writing. It goes through the first if statement fine, but when it gets to the second if statement it doesn’t

security – object permissions

Question: Why can’t I revoke the “update” permission from four tables in a database in the object permissions GUI? I have successfully revoked “update” from all other tables in the

Global Fucntion in Datawindow fails in exe

Question: I’m working on PowerBuilder 6 under a Windows environment. I’m calling a global function in a datawindow object. This function gets called perfectly in the development environment, but it

Hardware config. development server

Question: I plan to create a SQL Server 7 database containing about 40 – 70GB of data. The data will be generated by queries. How should I spend my money

Function Pointers

Question: I’m converting an fsm from C to Java. The C code has a struct and one of the members contains a pointer that contains the address of a function.

Outputting query data to a file

Question: I am trying to list out the contents of a field, and there are so many, that I need to send the output to a file. Can you tell