scotta_miller (3/23/2009)
Thanks, for a Great article. I am trying to implement this on a test server and the report shows no data at all (Except the server name). When I run the stored procs by them selves I get data back. Any idea why the report is blank?
Thank you!
Are you running it on SQL-2008 Reporting Services? If yes, pls have a look at the bottom of the article (last figure), where I'm discussing a similar issue I was having when I migrated the app from SQL-2005. If you are running it on SQL-2005 SSRS, I will need more info to troubleshoot on.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]