Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Programmabi... » SQL Tips and Tricks   (RSS)

Reporting Services Staaaarrrrrtttt Up

I hear the complaint a lot that after a time period of no calls to Reporting Services, the first call to the Reporting Services instance is very slow. This is totally expected because the application pool generally gets spun down and we need to restart

Working around the 4.2 billion tuple calculation limit in Analysis Services 2005 is possible in some cases...

An Analysis Services 2005 query against a calculation on a cell may report the error: "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples." This may be because there are simply more underlying cells in
 
Page view tracker