August 2012

Tracking milliseconds between processes (Timestamp Differences)

When checking a process for performance it’s useful to track fractions of seconds between steps. In the old days, we had to use dbms_utility.get_time, but with the introduction of TIMESTAMP in Oracle9i, it gets simpler. However, getting the differences between two timestamps is still more complicated than with dates. create or replace function milliseconds (pStartDate […]

Read more →

Performance Comparison Retrieving Data From SQL Server

C# developers generally find retrieving data in a result set from a SQL Server 2008 database procedure is easier than retrieving data from output parameters of a SQL Server 2008 database procedure. Is there any performance cost in this choice? Turns out the answer looks to be yes, although probably only worth pursuing when you’re […]

Read more →