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

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?
Aug
11
comment Adding columns to production tables
Recent article regarding this problem: sqlservercentral.com/articles/Change+Tracking/74397
Jul
21
comment Does adherence to the DRY principle justify dynamic SQL?
My example is pretty simplistic, but for a more complex query that involved the usage of indexes, would the above approach open you up to parameter sniffing?
Jul
20
comment Should I convert empty varchar values to NULL?
The developer for the middle tier has offered to implement a method that will convert all empty strings to NULL. I'm wondering though, is it the responsibility of the database to ensure this consistency? Or is it my responsibility to represent what was submitted (correct or not)?
Jul
20
comment Should I convert empty varchar values to NULL?
@MartinSStoller: do you a think it would be better to block these empty strings through an error message? In the context of this particular data, an empty string will not have meaning to the user.