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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Usage of Multiple db's

Author  Topic 

sona
Yak Posting Veteran

68 Posts

Posted - 2001-10-09 : 00:39:53
Like,

I have a single server.
In that 300 external devices will dump datas
into the tables.
ie. each device will make 1,00,000 insertions every 2hrs.
Each device is going to insert into say 10tables .All devices are gonna to insert same type of datas.

How can i deal this?
Can i use multiple databases ? or what?
I have no idea of dealing it.

The no. of records is going to be very large,
I will often query from the table also.

suggestion please!!!!!!!!!!!!!!
   

- Advertisement -