Reputation
879
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
1 10 22
Newest
 Yearling
Impact
~80k people reached

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?
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