837 reputation
11022
bio website
location
age
visits member for 4 years
seen yesterday

May
2
accepted ETL: extraction strategy for 200 source databases
Apr
30
comment ETL: extraction strategy for 200 source databases
Thanks for the detailed answer. Do you have any thoughts on using replication as a low impact means of mirroring the source data?
Apr
30
asked ETL: extraction strategy for 200 source databases
Apr
2
accepted Is there a performance benefit to placing transaction log files on a separate drive?
Mar
30
awarded  Nice Question
Mar
29
accepted How do query notifications detect changes in the query result?
Mar
29
asked Is there a performance benefit to placing transaction log files on a separate drive?
Mar
29
revised How do query notifications detect changes in the query result?
added 7 characters in body
Mar
23
awarded  Yearling
Mar
9
revised Can this method for unit testing a stored procedure be improved?
added 3 characters in body
Mar
9
asked How do query notifications detect changes in the query result?
Feb
20
accepted Data warehouse: using day number in Epoch in a date dimension
Feb
17
comment Data warehouse: using day number in Epoch in a date dimension
Interesting. In the example in the book, the last column in the date dimension is a SQL Date Stamp. So if Epoch means the same thing, I'm not sure why both would be included. But if Epoch is a timestamp, then what would "Day Number in Epoch" represent?
Feb
17
revised Data warehouse: using day number in Epoch in a date dimension
edited title
Feb
16
revised Data warehouse: using day number in Epoch in a date dimension
added 165 characters in body; edited title
Feb
16
asked Data warehouse: using day number in Epoch in a date dimension
Sep
8
accepted Can this method for unit testing a stored procedure be improved?
Sep
1
revised Can this method for unit testing a stored procedure be improved?
edited title
Sep
1
asked Can this method for unit testing a stored procedure be improved?
Aug
31
accepted Where can I find information on shredding xml with .nodes?