310 reputation
18
bio website
location
age
visits member for 3 years, 5 months
seen Aug 25 at 18:55

Jan
13
comment In Oracle, why would an OR / LIKE(A,B) take far longer than running the same query for each condition separately and unioning
Perhaps there's an index on my_column that the optimizer decided not to use in the former case but did use in the latter? When was the last time you gathered stats on the tables? Any number of possibilities... but we need the real query plans...
Apr
30
revised Any Open Source / free ETL out there?
Link Changed
Apr
29
awarded  Critic
Mar
26
awarded  Organizer
Aug
1
awarded  Revival
Aug
1
answered Solutions for reporting off of an EAV structured database?
Jun
25
awarded  Citizen Patrol
Jun
14
revised Methodology & Architecture to Create ETL Process
Added link
Jun
14
suggested suggested edit on Methodology & Architecture to Create ETL Process
Jun
14
comment Methodology & Architecture to Create ETL Process
He also wrote The Data Warehouse ETL Toolkit which is a through explanation of ETL architecture.
Jun
11
comment Are SQL Server's Date values stored as a single int?
@cdhowie knowing how a specific DB engine stores the data allows you to make educated guesses for capacity planning
Mar
11
awarded  Yearling
Dec
29
awarded  Supporter
Nov
28
awarded  Nice Answer
Apr
5
awarded  Editor
Apr
5
revised Any Open Source / free ETL out there?
added 281 characters in body
Apr
5
awarded  Teacher
Apr
5
answered Any Open Source / free ETL out there?