Timeline for Have SQL reports on separate database than same database that is serving web app?
Current License: CC BY-SA 3.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 18, 2012 at 11:25 | comment | added | Mohammad | yes,surely as soon as we will separate reports to another server, but some reports has complex queries and multiple join, SO migrating to another server although will help the application but steel the report server will be slow. i think it is better to have some custom denormalize table with more columns that serve complex queries. but i don't know that sql server has any embeded mechanism to doing this or if i myself had to fill this table? i dont know how? is any other application i should setup to do this ? | |
| Apr 18, 2012 at 9:33 | history | answered | toomanyairmiles | CC BY-SA 3.0 |