I'd be guessing.

First two thoughts are permissions on one end or the other, or some connection option that isn't set correctly.

Cool! Somehow, I missed that one in the ranking functions. Very nice.

You're welcome.

On the point of "don't lose sight of the big picture", I'll just say that this is one of the biggest mistakes people make, assuming they can't do anything with...

J Livingston SQL (8/8/2012)

---

GSquared (8/8/2012)

---

If execs are looking for ad hoc reporting tools, it's hard to go wrong with pivot tables. PowerPivot and Excel have been mentioned already. ...

Evil Kraig F (8/8/2012)

---

-- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a phone book or...

If execs are looking for ad hoc reporting tools, it's hard to go wrong with pivot tables. PowerPivot and Excel have been mentioned already. I haven't used PowerPivot,...

I agree with Craig.

Break the process down into smaller pieces first. Conquer each piece, one at a time.

In this kind of confusing situation, don't try to get a grasp...

Stefan Krzywicki (8/8/2012)

---

Jan Van der Eecken (8/8/2012)

---

Jan Van der Eecken (8/8/2012)

---

SQLRNNR (8/8/2012)

---

Lynn Pettis (8/8/2012)

---

SQLRNNR (8/8/2012)

---

D.Oc (8/8/2012)

---

LOL, made me laugh 🙂 Although it is not appropriate for...

Have you tried the solutions proposed here: http://ssas-olap.blogspot.com/2011/07/linked-server-for-analysis-services.html

Coming in from the re-post of the editorial today.

I used to know a manager who insisted that "consult" was just a phonetic contraction of "con" plus "insult".

I've worked with a...

bsclyde (8/7/2012)

---

Evil Kraig F (8/2/2012)

---

Would you be willing to post your current version here? As I mentioned, I'm unable to see the site it's currently posted on and would...

Jeff Moden (8/7/2012)

---

GSquared (8/7/2012)

---

Date formatting is done in the front-end application, not in the database. What application are you using? That's the point I'm making.

There is no formatting...

Robert Davis (8/7/2012)

---

GSquared (8/6/2012)

---

The whole idea is to maximize bandwidth that can be used to read/write in tempdb.

....

Same for multiple files. It will often create zero advantage to...

Weirdest interview I ever had was 4 hours long. They flew me out to their city, put me up in the local Hilton, rented a car for me for...