Viewing 12 posts - 1 through 12 (of 12 total)
Firstly, rules usually have exceptions. You have one exception and I would argue that in some cases, e.g. when dealing with dates, there might be other exceptions. Generally, your rule...
March 27, 2018 at 12:52 am
Deshpande.chai's solution worked for me, thanks.
I had changed the key attribute in a date dimension. I then moved all of the Attribute Relationships so that the old key was...
March 23, 2018 at 9:54 am
November 14, 2017 at 12:47 pm
Finally, I have tried to get the other users here to work with Powerpivot, and that has not gone very well. This leads me...
November 26, 2016 at 5:20 am
If hardware is so reliable these days then a good strategy may be to have clusters with one new (supported, warrantied etc) server paired with an old (unsupported, out of...
August 10, 2016 at 7:59 am
TheSQLGuru (6/21/2016)
Your focus on range scans sounds like lots of data warehouse queries. Outside of that we will need to agree to disagree on some key design philosophies.
The design philosophy...
June 22, 2016 at 3:23 am
TheSQLGuru (6/21/2016)
June 21, 2016 at 7:07 am
If you are reviewing the indexes then you may also want to review the decision about which index is clustered. By the time you have coalesced Index 1 and 2,...
June 21, 2016 at 3:45 am
GSquared (5/27/2016)
Don't leave because you think something else might be better. Leave because you know it will be better.
Completely agree but most people leave because they know that they...
May 27, 2016 at 10:48 am
For a long time I have disagreed with bosses and organisations in some jobs but then got on OK in other jobs. Things came to a head 2 years ago...
May 27, 2016 at 8:04 am
Viewing 12 posts - 1 through 12 (of 12 total)