Re: Large DB vs Several Small DB's?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: bert (bertcord_at_gmail.com)
Date: 01/29/05 

Date: 28 Jan 2005 17:06:25 -0800

How big is big. I manage dbs in 2 enviroments.

App 1
100 - SQL Servers
1,000 Databases
We are in the process of adding the ability of each customer having
multiple databases. Certain clients load 100,000,000 records a day

App2
4 servers
4 big DBS ( 2-3TB)
I wish it was smaller :(

I say unless your db is going to be over 100GB stick with one db. How
big are you planning?

Bert

Relevant Pages

  • Re: Query Two Databases
    ... > Depends on the databases. ... If the 2 DBs are MS SQL Server DBs on the ... > same server you can do a query like this: ...
    (microsoft.public.access.queries)
  • Re: Query Two Databases
    ... If the 2 DBs are MS SQL Server DBs on the ... FROM databaseA..table1 AS A INNER JOIN dtabaseB..table1 AS B ... Or must I create a linked-table reference in one of the databases? ...
    (microsoft.public.access.queries)
  • Restricting Access to BUILTINAdministrators
    ... I have a bunch of SQL servers that I inherited when I took over ... Grant that the System Administrator role to the NT Group and ... both accounts then you are denied access (Deny supercedes Grant). ... Looking at one of the databases my domain user is the owner and there is no ...
    (microsoft.public.sqlserver.security)
  • Re: Planning to move SQL 7.0 to 2000 on to a new server
    ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... Issues When a Database Is Moved Between SQL Servers ... What databases to I> need to do this other than user databases? ...
    (microsoft.public.sqlserver.security)
  • Re: Performance issue
    ... I concur with Mike and also would like to add a note about dependencies/relations and backup. ... Too often I see applications split over several databases where the developers didn't even consider ... > The only reason that I can think of for splitting the tables across multiple ... > move DBs between servers (I encountered big headaches migrating SQL6.5 DBs ...
    (microsoft.public.sqlserver.server)