Viewing 15 posts - 391 through 405 (of 1,353 total)
While I agree with Gail that there are a number of factors to consider and skill level of the DBA team is an important consideration, large databases in a single...
February 20, 2017 at 7:35 am
When I think of a "lookup table", it's usually not something that models a complete entity, but rather just ID and Description.
Agreed. I still don't...
February 17, 2017 at 12:26 pm
However, it shouldn't be confused with a "Junk Dimension" when building a data warehouse. The junk dimensions are actually a good design practice.
Agreed on both points.
February 16, 2017 at 12:42 pm
I would have loved to show the diagram however I am not 100% sure about the rights to reproduce it are.
If you paid the consultant to do the...
February 14, 2017 at 8:50 am
Would you be interested in posting a photo of the 15 circle diagram your friend gave you?
Agreed. As interesting as I found the article, the...
February 14, 2017 at 7:32 am
Adding my voice to the chorus. This is a VERY bad idea. I work with a database that has these on a small scale, with each major entity has it's own...
February 13, 2017 at 5:21 am
I did try to aggregate it, but it didn't like that command. I'd be interested to see your function equation with that command.
January 31, 2017 at 9:12 am
This turned out to be more complicated than it should be.
=IIF(SUM(Fields!Prior_Year_Actual.Value)=0, 0, (1 - SUM(Fields!Actual.Value)/SUM(Fields!Prior_Year_Actual.Value))*-1) -- For all except grand total
=IIF(SUM(Fields!Prior_Year_Actual.Value)=0, 0,(SUM(Fields!Actual.Value)-SUM(Fields!Prior_Year_Actual.Value))/SUM(Fields!Prior_Year_Actual.Value)) -- For grand...
January 31, 2017 at 7:22 am
Reporting off of cubes is different from reporting off of transactional data.
Yes, we have found that to be the case. The solution provided seems to use...
January 24, 2017 at 2:54 pm
I don't know what information can be gathered from an .rdl file, so I'm hesitant to provide one. Assume the groups are set up correctly as the SSAS cube has...
January 24, 2017 at 12:31 pm
I'll be testing against that database. I have it set up, but have only started some R work. This gives me something concrete to follow and try.
January 17, 2017 at 12:43 pm
This looks like a great article. I'm going to try this over the weekend on my home SQL Server 2016 sandbox. If all works as you've laid out, I'll come...
January 17, 2017 at 7:53 am
SSIS is a maintenance nightmare! Avoid SSIS like the plague. It's for people who shouldn't be coding at all! About the only exception I can think of is if you...
January 6, 2017 at 7:45 am
Don't try to "learn Azure", but instead think about "building a database to track my own movie reviews in Azure and use it for a year."
I like it! ...
January 6, 2017 at 7:36 am
Viewing 15 posts - 391 through 405 (of 1,353 total)