Is the Need to be a Replicate DB for Reporting ??

Hello ,

In Large Project , How u can generate the Report from DB. Lots of user access same DB, reporting also based on the same DB. whether we get the fast access of report?? is It Possible ? or What u think abt it ? Or it may be a separate DB fr only REporting??


Welcome for u'r valuable reply's

Thanks

generally there is a reporting db against which the dev team can run queries and on which reporting queries are also run. and the reporting db is refreshed every night or however your schedule permits. so you are only looking a day's old copy.

***********************
Dinakar Nethi
SQL Server MVP
***********************
http://weblogs.sqlteam.com/dinakar/