I’ve based a couple of different post on this, as it uses a couple of different techniques i found worth posting about.

Please feel free to download the report from here
http://sdrv.ms/HJ3H7U

links to the previous posts are also available:

Knowing your CheckDB duration Times (Using Ola Hallengren Maintenance Scripts):

https://sqlnotesfromtheunderground.wordpress.com/2013/11/06/knowing-your-checkdb-duration-times-using-ola-hallengren-maintenance-scripts/

SSRS Dynamic Connection Strings:

https://sqlnotesfromtheunderground.wordpress.com/2013/11/08/ssrs-dynamic-connection-strings/

SSRS Custom Code, Formatting made easy:

https://sqlnotesfromtheunderground.wordpress.com/2013/11/08/ssrs-custom-code-formatting-made-easy/

Advertisements