Many thanks to those of you who attended my presentation at TechDays 2008 in Paris, earlier this week.
As promised, here are the scripts that I used during my demos,
as well as the Powerpoint slides themselves -- you'll need to read
French to get anything useful out of them :-)
The Techdays.zip archive contains the following files:
Optimisation Performances AS2005.pptx: the Powerpoint presentation in French
Techdays-FE.xmla: the XMLA script to recreate my demo database
TechDays-FE.mdx: the script that contains the queries I ran against the techdays-FE cube
TechdaysQueries.sql: the SQL queries to determine the time spent in the Storage engine vs. the formula engine.
You'll need the AdventureWorksDW database (http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=8392) to be able to run the FE and SE queries I used in my demo.
Good luck and feel free to drop me a message if you have any questions!