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 |
|
Girlnet
Yak Posting Veteran
77 Posts |
 Posted - 2008-09-12 : 10:59:34
|
| I'm wondering what everyone's opinion is . . .Would you be comfortable buying a solution that uses a single database method for every customer they have?There is an ERP solution that sells their product as a ASP model - they manage your data. But . . . every customer shares the same database. That ALOT of data! |
|
|
Girlnet
Yak Posting Veteran
77 Posts |
Posted - 2008-09-12 : 14:00:41
|
| The people involved are telling me it's no big deal to do this - but I don't have any warm fuzzies. Is it perfectly OK to have 300 companies all utilizing the same database?Please anyone? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-12 : 14:08:41
|
| Yes that's okay! I would hate to support 300 databases when all I needed was 1.I was actually recently complaining about a 3rd party solution that was going to create a database for each of our customers. We've got thousands of customers. I told them, "absolutely not".If you need to scale out the single database, then you'd do that via partitioning.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
Girlnet
Yak Posting Veteran
77 Posts |
Posted - 2008-09-12 : 14:24:15
|
| What about performance then? Wouldn't performance start to degrade on a database with 3 trillion rows to query versus 3 hundred? Or is this when data mining starts to kick in? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Girlnet
Yak Posting Veteran
77 Posts |
Posted - 2008-09-12 : 14:37:27
|
| Isn't partioning a new feature of SQL 2005? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-12 : 14:41:55
|
| No. In SQL Server 2000, there are partitioned views. SQL Server 2005 brings us partitioned tables and still supports partitioned views. The benefit to partitioned views is that you can federate them, meaning you can spread the partitions amongst SQL Server instances which means you can spread across more hardware.I like partitioned views better for scaleability reasons.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
Girlnet
Yak Posting Veteran
77 Posts |
Posted - 2008-09-12 : 14:51:57
|
| Thanks Tara - good information. |
|
|
|
|
|
|
Single Database Design