Viewing 15 posts - 601 through 615 (of 1,353 total)
A transaction log backup is only good so long as the base backup exists (whether full or differential). I've never done differential, but as soon as the full could...
August 4, 2015 at 8:53 am
I'm still learning the ins and outs of writeback. But as this is an old post, I will offer my best educated guess at this point.
With small amounts of...
August 3, 2015 at 11:28 am
I'm finding this confusing as you seem to have chosen a measure that can be added across the days. Especially so as the first of the month was so...
July 22, 2015 at 9:31 am
Worked for a company whose dress was M-Th business casual + tie. You could pay $2 per Friday or $50 for the year to wear jeans on Friday. ...
July 17, 2015 at 5:14 am
I have a similar issue with one cube. I insert them into a reference table in the final staging area. The essential columns are the unique incrementing id...
July 10, 2015 at 5:49 am
I added a measure based on a fact table column that had never been used in the cube before. ... [T]his column wasn't included in the index of the table,...
July 9, 2015 at 12:30 pm
That's a possibility. Normally a measure group will have it's own fact table because that fact represents a certain level of granularity based on the table. And when...
July 7, 2015 at 11:34 am
Just taking a stab at this. Do the three new measure groups share a lot of dimensions in common with the measure groups that were already in the cube?
July 7, 2015 at 8:25 am
Just this weekend I had to develop a step that pulled a particular value from an XML statement using the XML query tools. It worked great. I won't...
June 23, 2015 at 9:32 am
It may be possible to recyle a SEQUENCE number, but IDENTITYs can be reseeded. If you want to mess something up, it's always possible.
June 23, 2015 at 9:27 am
I didn't see anywhere example of sequence object in composite PK
The sequence by its nature would not need to be part of a composite key. It will be unique...
June 22, 2015 at 9:11 am
Your English is just fine. Don't worry about it. As far as your question:
1. There is a debate within the database community on using surrogate keys in an...
June 22, 2015 at 7:18 am
I learned a lot using the developer's version on my PC. Backups, restores, point in time restores. I also learned a lot of BI. Since Excel can...
June 19, 2015 at 7:52 am
I looked at it briefly a couple of years ago, and my reaction was something like "Why on earth would anyone ever want to use this pile of *&^%...
June 19, 2015 at 7:15 am
That's a different but interesting topic. For that I have a separate Holiday table.
I agree that that's a better way. It's been on my list to do for some...
June 5, 2015 at 2:05 pm
Viewing 15 posts - 601 through 615 (of 1,353 total)