devxlogo

Tip Bank

Improve Stored Procedure Speed

When developing stored procedures in SQL Server, use the SET NOCOUNT ON option at the start of your procedure. This will prevent the superfluous “row count” messages from being generated,

Declare Your Objects Properly

Never declare a variable as a “New” of type “object,” but always rather just as of type “object.” If you do so you will always increment the reference count of

Visual Interdev and ODBC errors

Question: I developed a very tiny project in Visual Interdev: * Made a connection in de 32-bit ODBC (Control panel) with the Access97 Database and DSN name. * Add data

Converting between hex/decimal

Question: Is there a way to ‘easily’ convert betweenHexadecimal and decimal with VB 5.0 Profesional.(ie. Without doing the long conversion from hex to ascii, then using the conversion factor, then

System calls

Question: How can I make shell level calls from a java program? For example, I want to execute the “ls -al” command from java and return its values back to

Setting icon image for dialogs in java

Question: How can we set icon images for the dialogs? Answer: There is currently (as of Java 1.1 and 1.2beta3) no way to set icon images for dialogs. On most

Java Pausing Abilities

Question: I want to make my Java program pause for a specified amount of time, but I don’t want to use a threading implementation. How can I do this? Answer:

Garbage collection process

Question: If i have a code like this in the while loop while (true){ java.util.date ldt_date = new java.util.Date() …} Will the ldt_date variable be initialized with new location in