762 reputation
1720
bio website
location
age
visits member for 3 years, 7 months
seen Oct 21 at 15:27

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.