What's the datatype of the WeeklyPlanMix.FinanceForecastExVAT field?

Separately, it's the references to 'CalculatedFieldWrapperImpl' that I don't like - looks like RS is doing something odd with the value.

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/10c33d92-7f23-4c29-ac30-497c904505c1/

suggests multivalued parameters...

It might not like trying to divide an aggregated field by a non-aggregated field in the same dataset.

Does the calc work without the SUM?

I'm thinking that being "The DBA in Space" could be worth rather more than $100k to your career... 😎

Being "The DBA Who Took the Cash", not so much.

Are the fields both in the same dataset, or are either calculated fields?

Agreed. I have worked as both and they're very different 🙂

Title is DBA now, have been BI Developer.

Generally I'll say "I work...

Extra or missing bracket (depending on the calc you want) unless it's a typo?

It's a tough one. The cash would be might useful. On the other hand, bet it'd be one hell of a ride*!

*Once they actually have something working...

Or Deny delete permissions to the developers! 😉

Once the table is created, you add exactly one million rows to it, all with ShortDescription equal to 'None', LongDescription and AddDate set to NULL, all numeric columns equal to...

Yep looks like it: http://msdn.microsoft.com/en-us/library/cc280356.aspx

Got caught out by it myself a while ago by some Windows 2000 machines 🙂

If it's an old box I'd check that version of Native Client supports the host OS.

Should be able to use an older version of NC if it is an issue.

Ha, let me rephrase that - you could use the FORCESEEK hint, but I really really really _really_ wouldn't recommend it 🙂

I have had cause to use an index (not...

You could use the FORCESEEK table hint, but I wouldn't recommend it.

Does the query with the dummy WHERE clause outperform the one without, and are they synonymous queries?

As Ninja says,...

Does your actual view or query have a where clause?

Is it table 1, 2, or 3 that's being scanned? What's the DDL for table 3?

Is it a table scan or...

Good question, agree with Hugo's points.