Category: Performance Tuning and Optimization

Sort Your Data on Load for Improved Compression

My last 2 blog posts have been about data compression – that theme continues today.  In December I blogged about the basics of compression and impacts that columns have on file size and did some testing with randomised data. 

Written by on February 9, 2016

Less Columns, More Rows = More Speed!

“Stay close!  Come together!  Staggered columns!  Staggered columns! I mean…  less columns!  More rows!” -General Maximus Speedicus Queryus A Long-Held Belief, Quantified For a long time now I have been […]

Written by on August 1, 2011

Hardware/Capacity Planning: From the Trenches

So How Many Servers Do I Need in My PowerPivot SharePoint Farm?
As people increasingly move up from just dabbling with the addin, and decide to start leveraging the publish/schedule/share/secure benefits of the PowerPivot for SharePoint infrastructure, I am getting this question more frequently.

Written by on November 30, 2010

Slicers and pivot update performance

-Posted by Rob Collie OK, I was sitting at the 2nd-day keynote down in New Orleans last month, watching Amir Netz do a demo on some PowerPivot goodies we can […]

Written by on July 2, 2010