|visits||member for||1 year, 7 months|
|seen||Nov 15 '12 at 6:36|
Have SQL reports on separate database than same database that is serving web app?
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 ?
|asked||Have SQL reports on separate database than same database that is serving web app?|