database size - SQL Server Forums

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.

All Forums

General SQL Server Forums

Database Design and Application Architecture

database size

Author

Topic

seracohw
Starting Member

2 Posts

Posted - 2011-08-02 : 12:21:34

Anyone know what is the average number of tables for an sql server database used for a large application like online banking ? About how many MBs of data is that ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-02 : 13:00:12

This is not something that can be answered. Number of tables is dependent on your design. Designs are typically proprietary or you're purchasing a COTS package. Size of database is dependent on so many things such as indexes, design, retention, etc.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

seracohw
Starting Member

2 Posts

Posted - 2011-08-02 : 13:06:42

I just need an average number ... something approx. cause I have no idea what is possible . What are some of the numbers out there ? I am thinking for online banking for a major bank .

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-08-02 : 14:05:24

It depends. It really does.

Depends on the business, the database design, the requirements, etc, etc, etc.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources