The Voice of the DBA - WMV A Private Database

MEVIOtoday

Jun 08, 2008 A Private Database

One of the things I've dealt with, and seen lots of questions about in our forums, is the best way to deal with multiple clients using the same schema and lookup data for an application. I've seen two basic ways that this is handled in SQL Server: some people put everything in one database and use some type of ID to filter results. Others use separate databases for each client and either keep lookup data in a central database, so each client has two databases they access, or use some copy method, such as replication, to ensure the lookup data is in every client's database. Both of these have pros and cons and each company needs to examine their situation to determine which method makes sense.

Read the rest of A Private Database at SQLServerCentral.com

Episode Comments

Success! Your comment will be posted when the producer approves it.

Fans of This Show also Like

  • Ask Lev

    2-5 minutes of advice from Paul Levinson on writing, succeeding, navig...

  • Completely Conspicuous

    Straight talk about news, sports, music, movies, pop culture, and anyt...

  • Burrito Electrico

    Playing the BEST of PUNK, ROCK, PsychoBilly, OI!, Ska, Skate PUNK, Cru...