Reputation
298
Top tag
Next privilege 300 Rep.
Create new tags
Badges
3 11
Newest
 Curious
Impact
~9k people reached

Feb
5
answered How do I prove that the act of removing foreign keys doesn't corrupt existing data?
Feb
5
comment Foreign Keys doesn't work as I expect
Your expectation is pretty much the exact oppoaite of what you should want to have happen. On delete cascade does one thing, prevents orphan records, but not in a useful way. Orphan records are only a problem because they indicate that there was once something that was deemd important, and part of it was deleted -- either it was deleted in error or it wasn't important. If it wasn't important, then the orphans don't matter and can be deleted at leisure. If it was important cascading a delete hides that it was deleted in error, instead of preventing it.
Nov
25
revised How to define the logical name in a backup ? ( Sql Server 2008 )
restored link to related question
Nov
25
suggested approved edit on How to define the logical name in a backup ? ( Sql Server 2008 )
Nov
23
accepted List of Object properties
Nov
21
awarded  Curious
Nov
20
comment List of Object properties
@Kin: Thanks for the reference to OBJECTPROPERTYEX
Nov
20
revised List of Object properties
added 191 characters in body
Nov
20
comment List of Object properties
@MaxVernon these are properties for functions.
Nov
20
asked List of Object properties
Nov
16
revised Why do people recommend not using the name “Id” for an identity column?
Added to explanation
Jul
6
comment Creating a stored procedure and adding date manually to filename
As this is 2015, the odds are pretty good that he is dealing with a 2012+ sever, in which case Format is a better option than CONVERT.
May
13
awarded  Notable Question
May
5
comment Calculating values from three related tables, without using join or union
Is this for school or work? If for work, you should push back -- joins should be used when appropriate.
Apr
17
awarded  Notable Question
Mar
23
comment Best way to automatically reset sequence/identity once a year
@MichaelGreen: with a day where all of the values are wrong.
Mar
23
revised Best way to automatically reset sequence/identity once a year
added 290 characters in body
Mar
22
answered Best way to automatically reset sequence/identity once a year
Mar
22
revised Best way to automatically reset sequence/identity once a year
added additional option
Mar
21
comment Best way to automatically reset sequence/identity once a year
@RafaelPiccinelli: I find a job somewhat clumsy and am afraid of errors such as the job not being ran because the server happens to be down at the wrong time. If that's the best that can be done, that is the best that can be done, but I am hoping a better solution exists.