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 |
|
SantanaSQL
Starting Member
6 Posts |
 Posted - 2009-12-03 : 12:40:23
|
| I am in the process of creating a database at will collect information from different servers. which one make more out of these options:1- One database and one table for each server.2- One database with one table to all the server.Which one make more sence.Any help will be helpfullThanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-03 : 12:50:02
|
| One table. Add a column to indicate which server. |
 |
|
|
SantanaSQL
Starting Member
6 Posts |
Posted - 2009-12-03 : 12:53:16
|
| Ok, I will be collecting data on a daily bases, I was thinking each column will represent a day, in this case if each column will resent a server. how can I ID each day by its date in the Table? I am new SQL |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-03 : 16:05:23
|
Something like this:Create Table ServerInfo ( serverName sysname not null, date smalldatetime not null, otherColumns...) if you tell us what information you're gathering, we can assist more. quite possibly you want to build a relational model. If you're just collecting statistics from several servers, what i showed above should be good. |
|
|
|
|
|
|
one database several tables