It's a Matter of Time
I've been thinking a lot lately about my recent
failed deployments.
How did I get so sloppy?
I'm not one to make excuses, but I would say there are some mitigating circumstances at least. Time being one of them.
So I got out my trusty calculator (SQL*Plus), and ran the numbers.
From August 26, 2007 through March 30, 2008, I've worked 1802 hours. Of that, 118 were PTO or holiday, which brings the total down to 1784. For perspective, a work year of 8 hours per day comes out to 2080 hours a year.
VAR HOURS NUMBER;
EXEC :hours := 1784
1 SELECT
2 ROUND( ( :HOURS / 2080 ) * 100, 1 ) per_of_tot_year_hours
3* FROM DUAL
ETL_WRK@ORA10GR2>/
PER_OF_TOT_YEAR_HOURS
---------------------
85.8
Cool! Only 86% of my hours in a little over 6 months!
Obviously, this is not a good thing.
Further breaking the numbers down:
VAR C VARCHAR2(10);
EXEC :C := '26-AUG-07';
SELECT
start_day,
end_day,
days_between db,
SUM( business_days ) bd,
ROUND( ( :hours / days_between ), 1 ) hpd,
ROUND( ( :hours / ( days_between / 7 ) ), 1 ) hpdw,
ROUND( ( :hours / SUM( business_days ) ), 1 ) hpwd,
ROUND( ( :hours / SUM( business_days / 5 ) ), 1 ) hpww
FROM
(
SELECT
start_day,
end_day,
TRUNC( end_day - start_day ) days_between,
start_day + rownum dayof,
( CASE
WHEN TO_CHAR( start_day + rownum, 'D' ) IN ( 2, 3, 4, 5, 6 ) THEN
1
END ) business_days
FROM
dual a,
(
SELECT
TO_DATE( :c, 'DD-MON-YY' ) start_day,
TO_DATE( '30-MAR-08', 'DD-MON-YY' ) end_day
FROM dual
) b
CONNECT BY LEVEL <= TRUNC( end_day - start_day )
)
GROUP BY
start_day,
end_day,
days_between
/
START_DAY END_DAY DB BD HPD HPDW HPWD HPWW
---------- ---------- ------ ------ ------ ------ ------ ------
08/26/2007 03/30/2008 217 155 8.2 57.5 11.5 57.5
DB = Days Between
BD = Business Days
HPD = Hours Per Day
HPDW = Hours Per Day/Week
HPWD = Hours Per Work Day
HPWW = Hours Per Work Week
The scary part is that I am not very diligent about entering my time. It's probably short anywhere between 5 and 10%.
I'm not the only one working these kinds of hours either. I know for a fact there are others.
Do you think this plays a role in my failed deployments?
Labels: discipline, sql, work
