239 reputation
110
bio website
location Juneau, AK
age 47
visits member for 3 years
seen yesterday

I have three wonderful kids, two boys and a girl. My wife is a treasure.


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.
Mar
20
asked Best way to automatically reset sequence/identity once a year
Mar
17
answered Adding Users after Database Restore
Feb
8
answered DELETE command not completing on 30,000,000 row table
Jan
17
accepted MS Migration Assistant (SSMA) index renamed
Jan
16
comment MS Migration Assistant (SSMA) index renamed
It's a VB4/5 app that was upgraded to VB6, it uses DAO and the index names are specified for several queries. Why it did that, I have no idea. I'm currently planning on a .NET webapp and MS SQL. No need for index hints, even if I was tempted to do so.
Jan
16
comment MS Migration Assistant (SSMA) index renamed
@AaronBertand: I tested it with all unique names, and SSMA still renames them all. As a side note, while it won't really cause me any real problems as the code that does it will be going away, the index names ARE being being used by the application for some some queries.
Jan
15
comment MS Migration Assistant (SSMA) index renamed
@AaronBertrand: That sounded reasonable, assuming that it found duplicates and then renamed those. But further investigation shows it seems to simply rename all indexes. Possibly it renames all indexes when it finds any duplicates, I haven't tried having all unique names.. Ah, well, now that I know it is doing it to everything, I'm less concerned about it somehow causing problems.
Jan
15
revised MS Migration Assistant (SSMA) index renamed
added 100 characters in body
Jan
15
asked MS Migration Assistant (SSMA) index renamed
Sep
24
awarded  Autobiographer
Sep
10
comment Why would call to scalar function inside a Table Value Function be slower than outside the TVF?
@AaronBertrand: updated the question with some details and psuedo-code.
Sep
10
revised Why would call to scalar function inside a Table Value Function be slower than outside the TVF?
Added addition details
Sep
9
asked Why would call to scalar function inside a Table Value Function be slower than outside the TVF?
Aug
2
comment Rebuilding an entire Microsoft SQL Server Database
I would script the table structure, import the data, and then synch the database structure -- foreign keys, indexs, procs and so forth.
Jul
25
revised How do I place leading zeros for numbers less than 10 without affecting those 10+?
added 349 characters in body