September 2004 - Posts

TSQL Optimization

Saw this in CODE magazine. Maybe this is common knowledge, but want to make sure I don't forget it.
Appears that that using multiple SET statments to setup variables like:
SET @foo1 = 0
SET @foo2 = 0
SET @foo3 = 0
...

is slower than one SELECT like:

SELECT @foo1 = 0, @foo2 = 0, @foo3 = 0

makes sense once you understand that behind the scenes each SET statement is converted to an individual SELECT statement.

Great article, but that tidbit makes it well worth reading
posted Friday, September 24, 2004 11:40 AM by Harpua with 1 Comments

Visual Time Sheet

I recently started a new long-term contract with a local company and they use Visual Time Sheet within their IT department, not so much to track hours, but to use more of a tracking of the number of "non-project" tasks that take up a big part of the day. They are using it to justify to upper-management the need for further staffing. I've downloaded the trial version and am using it to see if I benefit in my own business. Very slick yet simple software package for a nice price.
posted Tuesday, September 21, 2004 4:23 PM by Harpua with 0 Comments

Class 9 Events

I have a client that requested I add what he called “Class 9 Events” to his application.  His description of what that is is that it basically just logs all operations done within the software.  I've tried to search to see if there are some specific requirements to implement Class 9 events, but have not been successful.  Are Class 9 Events a specific type of events or logging that has specific requirements and/or structure?

Thanks

posted Wednesday, September 08, 2004 12:28 PM by Harpua with 0 Comments