I think it is getting every possible piece of information from transactional systems instead of just getting data specific for reporting. This gives you more potential for analysis but...

Nice script Rudy. Thanks to Lee and WDolby for their recommended fixes too.

Toreador (1/2/2013)

---

Can't see the need for a Microsoft reference on a question that's about something universal. But I agree with Tom - I'd never use a Wikipedia reference as sole...

Thanks for the 2012 question. I'm not sure why you would use the browse flag or not though.

Good question and nice discussion. I too prefer the left join syntax using the where clause for filtering in a subquery. It's just easier to read in my opinion. I...

I too looked at this as specifically dealing with the unique constraint syntax on a single column instead of unique indexes. Based on the sample code, the author had unique...

Good, straight-forward question on the basics. I'm surprised how many have gotten this wrong. I guess that means there are a lot of people learning a valuable point.

Steve Jones - SSC Editor (12/19/2012)

---

Chris Metzger (12/19/2012)

---

You know I wish more managers\executives thought this way. It makes no sense to emphasize the cert but not the real-world experience...

thanks for the easy question.

Excellent article! The way you break down the MDX language is fantastic. These articles will definitely be book marked as training resources for our team. 😀

Thanks for the 2012 question.

Nice question.

Rob Schripsema (12/12/2012)

---

DugyC (12/12/2012)

---

Knowing already that using sp_rename does not change its definition, and with there being no error scenario in the answers, I had to take the only possibly...

It's probably good that Success.Success.Fail was not listed as an option since at this point, 89% have answered correctly. With the other answer as a choice, I am sure the...

Nice question. Yet another topic for me to read up on.