Useful tools for monitoring & managing ssrs

Reading this forum article on SSC led me to some interesting tools. Firstly this pack of SSRS reports that monitor the server and statistics is extremely useful and I will add it to the toolbelt. http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69257/   The other is a great little app to download/deploy reports on mass. Many a…

Multivalue parameters in SSRS

Normally when connecting to a SQL Server datasource you can create a paramter and allow multiple values and then use it in a query in this sort of construct: Select column from table where column in (@parameter) This works well and the parameter is passed from SSRS to the SQL Server…

MDX via OPENQUERY

When you run a basic MDX query directly against the cube, it returns only those measures and dimensions you have specified in the query. Note that [Customer Geography] is a hierarchy. Select Non empty [Measures].[Sales Amount] ON Axis(0), [Customer].[Customer Geography].[State-Province].Allmembers ON Axis(1) FROM [Adventure Works]            …

Showplan Query Execution Plans

SQL Server execution plans are the key to optimising queries in an empirical, scientific way. The wrong way to go about optimising SQL is to trial and error until the query appears to run more quickly. The problem with that technique is that your query might not scale efficiently. Confronting…