meta user
network profile
|
Apr 22 |
awarded | Popular Question |
|
Mar 8 |
comment |
Update Table A row if Table B row is changed +1 just for "...instead of premature optimization." |
|
Feb 14 |
awarded | Tumbleweed |
|
Feb 8 |
comment |
SQL Update Efficiency and Blocking Concern With the update you are trying to do, does it matter if any of the data involved in the large JOIN changes before you write the update? If the update is independent of the other data then using a temp table should not be a problem. But is there a situation where the data might change before your write and therefore invalidate the update? I'm guessing probably not as, from the table names, you seem to be recording stock market trades (historical information) |
|
Feb 8 |
comment |
SQL Update Efficiency and Blocking Concern What is the table t you are updating? Saying "...a temp table that has the latest price and rate I need." is a little worrying, why are you storing data in a temp table and not in the main tables of your DB? Updating from a temp table could result in inconsistencies in your data if the tables in the larger JOIN query are changed before your write. |
|
Feb 8 |
comment |
SQL Update Efficiency and Blocking Concern Can you give some more information about the tables involved in the JOIN? Or post an execution plan of the SELECT to see why it's slow. |
|
Feb 8 |
answered | SQL Update Efficiency and Blocking Concern |
|
Feb 7 |
asked | Import batches of rows from Excel in parallel |
|
Sep 24 |
awarded | Popular Question |
|
May 26 |
awarded | Yearling |
|
Oct 11 |
comment |
MySQL - How do you enter a record with only whitespace “ ”? Perhaps you should approach the problem in another way; rather than including white space in your string replacement definition how about storing a setting? E.g. "trim_string" (0 or 1) (false / true) etc. |
|
Oct 10 |
comment |
Any way around unique index 16 column max @Matt M - Thanks for your explanation but I did say "... create a new unique value and store that in addition to the current data." I intended the new key column to be a new field complementing the existing data and not replacing it. I agree the use of a persisted calculated field is better than my suggestion of a UDF but, in spirit, my solution was the same. |
|
Oct 10 |
comment |
Any way around unique index 16 column max @Matt M - I'm interested to know why you down voted my answer when it's not too different from the first suggestion in the accepted answer to this question? I'd also like to know why you disagree, what would be your solution? |
|
Oct 6 |
answered | Any way around unique index 16 column max |
|
Jun 30 |
revised |
What are the top 5 design decisions which need to be made when implementing a database? Changed title, body formatting and language use. |
|
Jun 30 |
suggested | suggested edit on What are the top 5 design decisions which need to be made when implementing a database? |
|
Jun 24 |
comment |
Date Format in Sql Server @Xulfee - Can you clarify which data type is used by the source data for the dates? I'm assuming you are having to convert strings to a date or datetime type given they are displayed in different formats. |
|
Jun 24 |
comment |
Date Format in Sql Server @Stan - I understood the question to be concerning importing data in to a date field. If the OP already has the data in 'date' form there would be no need to ask about accommodating the different formats mentioned in the question. |
|
Jun 23 |
awarded | Commentator |
|
Jun 23 |
awarded | Critic |
