792 reputation
1920
bio website
location
age
visits member for 3 years, 9 months
seen Dec 13 at 0:54

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?
Aug
31
asked Where can I find information on shredding xml with .nodes?
Aug
11
comment Adding columns to production tables
Recent article regarding this problem: sqlservercentral.com/articles/Change+Tracking/74397
Aug
10
accepted How often to backup the master database?