209 reputation
110
bio website
location Juneau, AK
age 47
visits member for 2 years, 11 months
seen Jan 23 at 20:04

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


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
Jul
25
answered How do I place leading zeros for numbers less than 10 without affecting those 10+?
Jul
18
awarded  Popular Question
Jun
25
awarded  Yearling
May
2
accepted DDL statements being commited within transaction
May
2
comment DDL statements being commited within transaction
I should have thought of that. I'm sure you're right and this is what is happening. And I do have some statements wraaped in GOs. I have SET XACT_ABORT is ON trying to avoid that, but the GOs are probably interfering....
May
2
asked DDL statements being commited within transaction
Mar
19
awarded  Popular Question
Aug
7
answered How to query a database for empty tables