Viewing 15 posts - 271 through 285 (of 1,353 total)
I make it a practice to open SSIS and SSDT as administrator to avoid annoying permission errors. This error seems to appear most frequently during the Data Flow process.
February 6, 2018 at 7:46 am
You don't say what's wrong, and it looks like a homework assignment. Please provide additional information.
February 4, 2018 at 8:33 pm
What may make sense is to create MORE of these big ol' flat tables that breaks things into more narrowly defined sets.
As it's a fact table, breaking...
February 2, 2018 at 1:37 pm
Again, you'll have to go with what works for you. I don't know enough about the data. In my system, an order is going to eventually be closed, whether via...
February 2, 2018 at 12:30 pm
Breaking out the date and time is the correct approach if both items are dimensionalized. Otheriwse the row count gets out of hand quickly.
As for the dates, if...
February 2, 2018 at 11:45 am
The answer to your question is yes, denormalization can definitely help performance. Unfortunately it can also lead to inconsistent data. I'll state plainly that I have sometimes lost design battles...
February 2, 2018 at 8:34 am
That can't possibly be normalized or a fact table.
Without a review of the data, this cannot be definitively established. That said, that is a lot of...
February 2, 2018 at 8:29 am
OK, I see. You knew the list was there, you just wondered if there was a way to determine that in code. Can't think of a scenario for that, as...
January 30, 2018 at 7:34 am
I might be missing something as the question seems straightforward, but are there two lists accessed via the interface. One list is the read only variables, the other the read...
January 30, 2018 at 7:22 am
Ideally when you have this parent child package configuration, each child package encapsulates a complete business process. This would include what to do if it fails. This could entail failing...
January 26, 2018 at 7:12 am
You seem fixed to the idea that "every view must be schema bound." That's just not true, and probably not even optimal.
This all started because the original...
January 25, 2018 at 9:15 am
Correct. My suggestion is to consider the option of removing schemabinding and instead refresh all views / all related views after any table change.
I'm not sure...
January 23, 2018 at 10:03 am
Have you considered instead of binding them just running a:
sp_refreshview
across all the views when a base table changes?
You can't change the table if...
January 23, 2018 at 9:31 am
to be honest it sounds like a lot of hard work for little benefit
I agree it's an extra step that isn't strictly necessary, at least in my...
January 22, 2018 at 11:46 am
You're apparently taking a maintenance hit as well. I don't have a good system of maintaining schemabound chained views as I don't use them. But as already said, that's not...
January 19, 2018 at 12:19 pm
Viewing 15 posts - 271 through 285 (of 1,353 total)