SQL Server2000 - New database or new file group?

Marcelo Cassani

Delphi Developer

Tue, 11 Oct 2005 02:41:54 GMT

SQL Server2000 - New database or new file group?

Hy,

I creating a new database with:
1 - A complex production tables structure - small quantity of data - time
critical.
2 - A simple tables structure for dimissal data - a bigest quantity of
data - heavy data retriveral.

My installations can: small (one computer server/client), mediun (server + 5
computers) or big (server + 20 computers) - an small installation can grow
for a while.

My question is: Using SQLServer2000 what is the best solution to guarantee
perfornace?
1 - Create a two separed database?
2 - Create only one database and put "dimissal data tables" in a file group
(another disk)?

Thanks in advance,

M.Cassani

Paul Lineha

Delphi Developer

Thu, 13 Oct 2005 22:35:07 GMT

Re:SQL Server2000 - New database or new file group?

marcelo.cass...@tiscalinet.it says...

Quote

> I creating a new database with:
> 1 - A complex production tables structure - small quantity of data - time
> critical.
> 2 - A simple tables structure for dimissal data - a bigest quantity of
> data - heavy data retriveral.

What is "dimissal" data?

Quote

> My installations can: small (one computer server/client), mediun (server + 5
> computers) or big (server + 20 computers) - an small installation can grow
> for a while.
> My question is: Using SQLServer2000 what is the best solution to guarantee
> perfornace?
> 1 - Create a two separed database?
> 2 - Create only one database and put "dimissal data tables" in a file group
> (another disk)?

Using indices and a reasonable table design, I can see no reason why you
should not keep all your data in one db.

What is the maximum size that the DB will grow to?

Paul...

Quote

> M.Cassani

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

Other Threads

1. Using New Unit vs New cpp file and Header File

2. MS SQL Servers New Groups

3. Copying database tables to new tables (haviing new fields)

4. Creating new Index Files for a new Ttable

5. ! MS-SQL SERVER2000 database connection

6. Creating a new SQL database

7. Out-Puting a SQL query to a new database

8. creating a new database file.

9. Writing File New, Save, Open code for D1 Database form

10. How to make a new database file using TQuery