Hey, if business can do it so can I 😀

Thanks for all the...

Thanks Dev,

The main advantage for me was that this is something that is used often within queries and this solution could have made the report not hit the fact table...

Thanks for the feedback,

Maybe my exampe wasn't the best one...

If we change the dim attribute to "last purchased date"

1) would you include that in your dimension?

2) if so, which...

Thanks Bruce!

I needed to get that confirmation that the same entity/table in the OLTP environment can become seperate entitiies/dims/facts in the modeling world.

I got my copy of the MSDW toolkit...

Hi Chris,

Your reasons for doing all the hard work in the relational layer makes alot of sense.

Thanks for the input!

Hi Paul,

I have a similiar design that I have been struggling with... and still are... I was wondering if you came up with a solution in the meantime 🙂

Some detail:

In...

Grant Fritchey (2/15/2011)

---

Hash match operators build a hash table, that can result in writes to tempdb. I also see a sort operation, again, writes to the tempdb. That's probably where...

Thanks Dave,

I'll definitely do the test without the order by, I also noticed that not all the instances of this query captured in profiler show writes... it might be that...

Hi Dave,

I don't see any spooling operations, there is an order by though...

just FYI - Below are the physical and logical results from statistics profile to show the operations from...

Steve Jones - Editor (8/31/2010)

---

2 years in college. Started in the UK, played a bit of 2nd row and then dropped to the "B" team so I could get out...

-- ** Not SQL related... **--

I was surprised to hear you played rugby?! Have even more respect for you now 😀

For anyone coming across this post, below is an article worth looking at:

http://prologika.com/CS/blogs/blog/archive/2006/06/27/1331.aspx

Thanks Pablo!

And taking it further to the cube level... Would you also stick with a single datamart feeding a cube or is it acceptable to having multiple marts as datasources?

No, definitely not 🙂

But in keeping with Steve's topic, I think the certification will give the candidate the confidence that he is good enough to apply for a DBA position.

I think this is exactly why certifications are important.

For instance, if the person pass the MCTS exam, that person should be "capable" of fulfilling a junior/intermediate DBA role and should...