1,149 reputation
213
bio website
location
age
visits member for 1 years, 11 months
seen Apr 11 at 13:49

Feb
12
comment Timeout while using table valued parameter
Re: MERGE -- I really want MERGE to work well/reliably. I've gotten comfortable with the syntax and find it convenient for my most common tasks--especially when I'm dumping the output to a log table. Most of the issues I've read about seem to be with features we don't make heavy use of (indexed views, filtered indexes, triggers), so I haven't abandoned it (for this environment at least)--though I realize it may bite me later.
Feb
12
comment Timeout while using table valued parameter
I started using the #temp with this pattern (unless the data set is fairly small) after starting to run into performance issues using large table variables. I'm operating under an assumption that a TVP is equivalent to a table variable inside of a proc--but even so, it may well be an overreaction to be using the #temp without specific indication to need it in this circumstance. There is no PK on the TVP (it isn't by definition unique--but I could move the row_number upstream to make it so).
Feb
12
revised Timeout while using table valued parameter
added 1931 characters in body
Feb
12
comment Timeout while using table valued parameter
@Thomas -- That's what I was looking for! I'd found references to that attached to a connection string, but not to the SqlCommand, and I didn't make the connection. cmd.CommandTimeout = 0; let it complete successfully! Now to figure out if this was a good idea to begin with...
Feb
12
comment Timeout while using table valued parameter
@Martin -- Didn't change anything, but got me looking more at the proc itself. I was dumping the TVP into a temp table immediately, then doing the merge. Thinking an index might help, I added a clustered PK constraint, but also no change. Now I'm starting to think that dumping 1m rows into a temp table isn't saving any I/O over rewriting the table...maybe I'm coming at this all wrong
Feb
12
asked Timeout while using table valued parameter
Sep
30
comment how to downgrade a statement for SSIS
Whoops! Corrected.
Sep
30
revised how to downgrade a statement for SSIS
deleted 1 characters in body
Sep
25
answered how to downgrade a statement for SSIS
Sep
24
answered best ETL design to transfer transaction tables records into the data-warehouse
Jul
19
awarded  Self-Learner
Jul
18
accepted SSIS hangs during For Each File enumeration
Jul
18
answered SSIS hangs during For Each File enumeration
Jul
17
answered Restore SQL Server 2000 Database in use
Jul
16
asked SSIS hangs during For Each File enumeration
Jul
16
revised Will Ola's default IndexOptimizer job update my stats?
added 486 characters in body
Jul
16
answered Will Ola's default IndexOptimizer job update my stats?
Jul
16
comment Run job once a minute, every day, except during a certain time
Or one schedule that runs every day from 11:30pm to 06:59pm and another that runs every day except Saturday from 07:00pm to 11:29pm
Jul
10
answered Getting related data from an uncertain column
Jul
8
answered SQL Server: Month Range Join