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)  Database design for handling terrabytes of data

Author  Topic  deepa Starting Member 17 Posts Posted - 2001-10-27 : 00:51:21 We want a database which have to handle incoming data from 300 devices and the same time any no(around 300) of web clients can query the DB 1.Whether to have a 300 databases (each per device) or 2.Storing more than one device data in same database but having sepearate table for each device. 3.Storing more than one device data in same database using single table differentiate by deviceid. Reply based on follwing factors 1.Resources required 2.performance 3.Reliability Deepa