In the SSRS Reporting Environment, you may never encounter this error and you live a happy and easy life. We all know an SSRS report can easily ping your server to 100% CPU if you decide to export a 120 page report, to PDF, with charts, etc. etc. You may get a complaint that performance suffers in another application while running the reports and you want to fix it, but do not know how. Then one day you or someone at your firm has decided to do your SQL Server a favor and separate out SSRS from the ......
In my experience with SSRS, I have noticed that there are two types of report developers: 1) SQL Developer that naturally flowed into SSRS, uses Stored Procedures for database development and has a very solid background for development. 2) Developers from other categories that somehow fell into SSRS. I come from the second school but I have an endless desire for learning about technology and have been fortunate enough to work with some really intelligent developers. Which brings me to one of the ......