508 reputation
31325
bio website
location
age
visits member for 3 years, 2 months
seen Mar 24 at 21:22

My friends call me "Mac". I'm a master of improvisation. I have vast scientific knowledge and unique abilities to use ordinary objects to get myself and friends out of trouble. I typically carry my Swiss Army knife and a roll of duct tape with me at all times. I dislike guns because of a traumatic childhood incident. I try to avoid violence whenever possible. Because my life was getting too stressful at the Phoenix Foundation, I have picked up programming as a new career. I spend my spare time on Stack Overflow.


Mar
24
revised What causes disk space growth from Informatica load onto SQL Server?
added 483 characters in body
Mar
24
comment What causes disk space growth from Informatica load onto SQL Server?
@Aaron, not necessarily. We are a datawarehouse but this database only represents the latest facts, so our type of facts don't change very much in this application. Only the date in which they are being represented. We basically just take the latest facts, so it doesn't grow very much considering we have data from 1988. From the last year, we may have grown a few dozen GB.
Mar
24
comment What causes disk space growth from Informatica load onto SQL Server?
@Kin, we are using Informatica 9.1. Our mapping is fairly simple, in that we have a source definition, a source qualifier, and a target definition. Nothing fancy. So just a single table with about 2 billion rows.
Mar
24
comment What causes disk space growth from Informatica load onto SQL Server?
@Aaron, we are almost hitting our disk space limit.
Mar
24
asked What causes disk space growth from Informatica load onto SQL Server?
Mar
12
awarded  Notable Question
Feb
4
awarded  Notable Question
Dec
5
accepted Database storage limit for open source PostgresSQL
Dec
5
asked Database storage limit for open source PostgresSQL
Oct
24
awarded  Notable Question
Oct
16
revised ODBC Data Source Administrator: Driver name is an empty string
added 11 characters in body
Oct
16
asked ODBC Data Source Administrator: Driver name is an empty string
Oct
1
comment Best index to apply for modifier query in i2b2
@Kin, I'd like to install that tool, but we have to go through a process to get new tools on our machine. I'll post the actual execution plan from SQL Server when I post the answer.
Oct
1
comment Best index to apply for modifier query in i2b2
Despite how this query runs, this query wasn't intentional. i2b2 has its own query writer, and I discovered a flaw in the query writer. It's excluding an absolutely essential piece of the query (the concept_cd nested query) before the modifiers are queried. I'll post more detail when I get time.
Sep
30
awarded  Famous Question
Sep
30
accepted What does this error mean in IBM Netezza Administrator? - ERROR: Permission denied on “_VT_DISK_PARTITION”
Sep
29
asked Best index to apply for modifier query in i2b2
Sep
24
awarded  Autobiographer
Sep
23
awarded  Famous Question
Sep
11
revised What does this error mean in IBM Netezza Administrator? - ERROR: Permission denied on “_VT_DISK_PARTITION”
edited title