We use SQL reports in a .NET web application, but some of our reports are heavy and involve more table join and columns.
As you know we cannot index all the involved columns (performance problem).
These reports impact web application performance. Now we are running reports against the same database that is serving web application.
What are some solutions to have reports on a separate database?