Viewing 15 posts - 2,911 through 2,925 (of 13,855 total)
If there are no updates (impossible without a key) or deletes, I would suggest not using MERGE, but INSERT:
INSERT target (cols)
SELECT cols FROM source
WHERE NOT EXISTS (SELECT...
February 25, 2020 at 7:33 pm
To be honest, I disagree with Thom somewhat. I would use a Flat File source, to break out the data into its columns.
From there, it would be necessary to feed...
February 25, 2020 at 3:24 pm
We use Git on Azure DevOps – and that is what I would recommend. In my opinion, it's way faster and more lightweight to use than TFS.
When you say that...
February 25, 2020 at 2:53 pm
Please describe the issue.
February 24, 2020 at 7:23 pm
I've not tried importing an accdb before, so can't help with specifics.
But converting NVARCHAR to VARCHAR is straightforward enough – a Data Conversion component is what you need. This will...
February 24, 2020 at 3:51 pm
Are you familiar with this stuff?
I've found it helpful, despite being a developer rather than a DBA.
February 21, 2020 at 5:09 pm
One thing I've noticed since Google went on its personalization kick a few years back is that my results often don't look like your results.
I was wondering why mine...
February 21, 2020 at 4:44 pm
Does the final SELECT take the same length of time, regardless of whether the rows are inserted or not? Just wondering whether the query is actually executing.
February 21, 2020 at 4:43 pm
What is the source for this table?
What are the sources for the other tables?
Is there anything 'different' about either the source or the target for the problematic table?
("Different" = Different...
February 21, 2020 at 3:24 pm
Doing a quick search found this other thread, with a script from a highly respected person:
https://www.sqlservercentral.com/forums/topic/script-out-database-mail-settings
Note to OP: why make other people do searches for you, when it's...
February 20, 2020 at 5:31 pm
Why not copy the entire DTSX file? What are you trying to achieve here?
Also, you need to be careful with the ID property, as they are supposed to be unique...
February 19, 2020 at 1:37 pm
Agree with Thom. Redirect your errors from the target if you are having trouble tracking this down.
February 18, 2020 at 11:39 am
You need to do it all in a single query (which can include UNION ALL), but not using temp tables.
February 17, 2020 at 10:24 pm
Not directly related to the question, but surely SMALLINT would have been a better datatype for PeriodYear?
February 14, 2020 at 7:58 pm
A table lock is different from a deadlock. Which one do you mean?
February 13, 2020 at 4:04 pm
Viewing 15 posts - 2,911 through 2,925 (of 13,855 total)