SqlServer2008 & DDBB múltiple

Posted on 2011-04-29
Last Modified: 2012-05-11
Hemos creado una aplicación Web basada en muchos usuarios pequeños y para cada usuario individual cream,os una nueva DDBB en un SqkServer2008. Ahora, presuntos expertos en Sql nos dicen que está mal enfocado. ¿Porqué sería correcto tener una sola DDBB con el nº de cliente en cada registro de cada archivo y no es correcto tener miles de DDBB con todos los ficheros y registros sin el nº de cliente?. Ejemplo: DDBB name: 000000001 con el fichero XXX con los campos A, B y C. Select A,B,C from XXX de la DDBB 000000001 en lugar de Select A,B,C,D from XXX where D='000000001'. Dajando aparte el tema de la ocupación en bites del resultado.
Question by:77258840
    LVL 76

    Expert Comment


    Unfortunately, my spanish is not that good, but has a good translator. The problem with your post is that it is not clear what the issue is. If you do not have an identity column, this makes it difficult to normalize data to have maximum information with minimal space usage.
    English to spanish translation
    Desgraciadamente, mi español no es muy bueno, pero tiene un buen traductor. El problema con su mensaje es que no está claro cuál es el problema. Si usted no tiene una columna de identidad, esto hace que sea difícil normalizar los datos para tener la máxima información con el uso de un espacio mínimo.
    Translation from
    We have created a web application based on many small users and individual users cream, a new DDBB you a SqkServer2008. Now, alleged experts tell us that Sql is misplaced. Why would one DDBB right to have the customer number in each record of each file and it is wrong to have thousands of DDBB with all the files and records without the customer number?. Example: DDBB name: 000000001 XXX file with the fields A, B and C. Select A, B, C from the DDBB 000000001 XXX instead of Select A, B, C, D from D WHERE XXX = '000000001 '. Dajando aside the issue of occupancy bit of the result.

    Open in new window


    Author Comment

    The application runs perfectly with: hundreds of DDBB named GWS000000001, GWS000000002, GWS000000003... Each user are one DDBB with the numbner of customer. We do sql like: select * from filename with string connection directed to DDBB GWS000000NNN and this run perfectly. But "the experts" say when we have thousandas of  DDBB that falls on the SqlServer performance.
    This is right>?
    We think that sqlserver lets you manage many DDBB as requested.
    LVL 76

    Accepted Solution


    When you have many databases that means that sql server has a "query plan" for each database,  This means that after a while it has to kick one out of memory to load in the one you query.
    a different organization where you have a single database where you have a table for all the users. Then you have a table for items with a column that references to which user this entry belongs. Setting up index will let sql keep most of the database in memory.

    Where do you keep a reference for the user and their DDBB?

    It is still unclear.
    IF each user has a completely different, their own designed database, this is the only option you have.

    If the databases are identical just separated because they are user based, i.e.
    If you have a sign in process for entry into your company, but based on your setup, the front desk will have a sign-in book for each individual rather than having a single sign-in book for all. In this case, the clerk has to locate the correct sign-book for each of the individuals before them. You can see how inefficient that is and it will waste the clerks time who could be using that time for other more productive purposes, answering questions.  In this configuration, during heavy traffic, there will be a line at the front desk longer than necessary.

    Author Comment

    More opinions please?

    Author Closing Comment

    Thenk you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    By default, Carbonite Server Backup manages your encryption key for you using Advanced Encryption Standard (AES) 128-bit encryption. If you choose to manage your private encryption key, your backups will be encrypted using AES 256-bit encryption.
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
    The viewer will learn how to download and install Comodo Backup on Windows 7. Comodo Backup is another solution for backing up your computer. It is free for local backup and online backup has differing amounts depending on storage required. In my op…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now