742 reputation
614
bio website
location
age
visits member for 3 years
seen 16 hours ago

Jun
16
comment How to efficiently check EXISTS on multiple columns?
@Thomas: Welcome to Stack Exchange. Have watched your SQL Bits Extreme DW presentation about twenty times.
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
May
31
accepted What is the purpose of the database 'owner'?
May
31
revised What is the purpose of the database 'owner'?
deleted 1 characters in body
May
31
asked What is the purpose of the database 'owner'?
May
13
answered How to split tables without affecting all stored procedures
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?