You can definitely query the management views (DMV) and there's also (from 2008) the MDW. A few articles on that here and on using it with SSAS here.

If you want to get really snazzy and generate the 'optimum' partitions for the data set, you could try using the SolverFoundation sample (description found here, search the page...

Things to check are the disk I/O and also the network performance. Based on you saying that when it's Virtual -> virtual, it's reasonably fast, it's more likely the...

Great spackle Jeff! Thanks for putting this brief article together - an easy and informative read.

cheers,

"Sort of" 🙂

If you mean, to have a Server based instance of this PPivot database, do I need SharePoint? Then yes, you do.

If you mean, can I deploy my...

I can't remember exactly what I've been NDA'd to say or not say, so, I'll let Chris Webb say some of it 🙂

Some notes from recent PASS summit[/url]

But in general,...

I tend to agree with you. The simple .Split() style function would push the data into an array, and then you could test for empty 'cells'. The...

James,

Short answer, AFAIK, you can't do it the way you want to do it. What you can do, is add additional rows to the P-C table (ie Department...

Do you want to be able to modify the sort, or have it come out specifically in (say) ASC order? If it's the latter, then why not set the...

and to answer the question - no, the only squiggly i get is a blue one, on the dim root, telling me i should do the right thing and create...

Ok, on my local 2008R2 Developer (so Enterprise), I hadn't actually set a Name for the attribute (lazy but hey, it's a test). But when I did, I selected...

Mark,

What version SSAS are you using? I ran up a quick test in 2008R2 and also 2005 and can't get either to throw the errors you've mentioned.

Below is the...

Oh, quick clarification on the 'free' comment - these services *are* free, ie you get SSRS and SSAS and SSIS with a SQL Server license, *but*, if you end up...

Well, you could start by looking at the 'free' tools that come with the SQL Server licenses you have, namely Reporting Services and Analysis Services. If you also have...

Hey Brandi - pseudo code means just that 🙂 I'm not a huge fan of the SSIS scripting language so it was easier...