Viewing 15 posts - 1,666 through 1,680 (of 2,701 total)
Thanks! Has anyone has any thoughts on Change Data Capture. The CDC function is, probably similar to the transactional replication. It is not the same, but it has this...
March 23, 2020 at 1:19 am
few questions.
March 22, 2020 at 12:12 pm
and I've just noticed - the view code above does not correspond to the one that the explain plan is referring to.
JD.vw_Orders is the view used on the explain plan...
March 21, 2020 at 9:17 pm
according to the plan it was called with
Parameter Compiled Value Runtime Value
[@ONum] '31856258' '31856258'
March 21, 2020 at 9:13 pm
downloading the plan from the link does have all the info as far as I can see, including predicates.
and from what I can see it is only the view that...
March 21, 2020 at 5:55 pm
All of you are. If she saw a few of these posts, she'd sneak onto my desktop and start banning your accounts.
or she would create a new account and...
March 17, 2020 at 11:05 pm
and this is a lot easier to do in Powershell - which could be called from SSIS directly if "boss" insists in SSIS
variables could be passed from ssis or from...
March 17, 2020 at 4:12 pm
As Phil said it seems correct.
so in order to test it to ensure that the 2 queries work the same way test the individual selects in isolation of the proc...
March 15, 2020 at 2:29 pm
what attempts have you made so far?
that is a fairly simple case of replacing with a combination of "and" and "or"
March 15, 2020 at 1:10 pm
...After the initial installation the databases rarely if ever need to be touched that's what it's been said
no real good reason then to refuse to host it on that...
March 14, 2020 at 4:23 pm
that means that on that particular cube one of the tables has a record that exceeds the max of 64KB
you will need to identify what it is and potentially remove...
March 14, 2020 at 1:12 pm
possible way - not the prettiest and probably not the best one - and not sure if it will work for all periods you may have
code adapted from https://dba.stackexchange.com/questions/174035/split-duration-hourly-depending-on-start-and-end-time
Requirements copied...
March 14, 2020 at 1:26 am
you may be suffering from the change to bulk insert since 2016.
have a look at https://techcommunity.microsoft.com/t5/sql-server/sql-server-2016-minimal-logging-and-impact-of-the-batchsize-in/ba-p/385537
if this is the reason you will need to either change your load processes to...
March 12, 2020 at 9:27 pm
This is akin to asking "whose responsibility is it to provide a quality product"?
Everyone's responsibility should be to make their work the best they can, not depend on other...
March 12, 2020 at 5:27 pm
from my point of view it should be primarily on the developer - and organizations that do not give the tools to their developers to improve their code are loosing...
March 12, 2020 at 3:22 pm
Viewing 15 posts - 1,666 through 1,680 (of 2,701 total)