472 reputation
148
bio website blog.componentoriented.com
location Ohio
age 46
visits member for 3 years, 9 months
seen May 14 '13 at 15:33
Architect, developer, and software pundit.

Oct
4
awarded  Good Question
Jan
31
awarded  Famous Question
Jan
3
awarded  Yearling
May
23
awarded  Notable Question
Feb
25
awarded  Popular Question
Feb
7
comment Passing array parameters to a stored procedure
Very interesting technique -- thanks.
Jan
3
awarded  Yearling
Apr
19
awarded  Nice Question
Apr
5
answered Any Open Source / free ETL out there?
Feb
28
answered What is your workflow for planning a data migration?
Feb
10
comment Passing array parameters to a stored procedure
This looks pretty consistent with other TVP examples I've seen. In playing with these techniques myself, I've found the XML solution to make a lot of sense if you've already got data in XML format in your application; otherwise, the TVP solution is very clean and fast.
Jan
27
answered How to dive into an ugly database?
Jan
26
answered Will this Database design logic work and what should be used?
Jan
26
awarded  Critic
Jan
26
comment Estimate large database size and speed
It's certainly true that there's no substitute for a "real" test, but I'm guessing that at this point, "go try it" is effectively the same as "I don't know." It seems like there should be a way to get in the right ballpark with an answer -- how about asking if anyone's got experience with 10^9 records in a MySql table?
Jan
15
comment Passing array parameters to a stored procedure
Sorry - yeah, I actually found that link after I started with the one Marian pointed out. What a windfall of info there! And Marian, you're right, I don't know that there's anything else that could really be added to that work.
Jan
14
comment Does SQL Server Compact Edition 4 finally support Views?
I'm also not able to create views on a CE database using VS2010.
Jan
14
comment Passing array parameters to a stored procedure
Ok, I almost hate to select a link as the answer, but that's an absolute killer link. That's more detail than I'd hoped for. Thanks!
Jan
14
awarded  Scholar
Jan
14
accepted Passing array parameters to a stored procedure