Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2008-05-07 : 07:23:54
|
| I've plan to writing Stored Procedure ("SP"). This SP contains program that produce a result and this result will insert into already define summary table. This SP will running every 30 minutes.What is the best solution? I should put this already define summary table in existing Database or i should create a new database and create the summary table into this new database. Can i using ReportServer Database to create this summary table?I'm using SQL Server 2005. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-07 : 11:15:55
|
| Why do you have an issue putting this into the existing database? Is the database heavily used for data input? Is it time critial? If not then I do not see an issue. |
 |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2008-05-07 : 11:28:26
|
| Kindest Mr. RickD,The existing database it heavy now. It contains million of rows. Lagging when execute the queries. What the best solution? Add more memory to the server? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-07 : 16:12:04
|
| Putting new table in existing db or in new db makes no difference in performance point of view, unless new db is on different server. |
|
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2008-05-08 : 09:43:42
|
| tq mr. rickd and rmiao. |
|
|
|
|
|
|
Using existing database or should create new one