Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 table size definition - small/medium/large		  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

stubarny
Starting Member

2 Posts
Posted - 07/18/2006 :  19:48:20  Show Profile  Reply with Quote
Hi,

Please could you tell me how big sql tables are when people refer to them as small, medium and large? Preferably in terms of disk space or rows (each row in my table will contain a standard length job advert and 20 additional columns with an average of 8 characters)

Thanks for your help! :-)

Stu

nr
SQLTeam MVY

United Kingdom
12543 Posts
Posted - 07/18/2006 :  20:01:41  Show Profile  Visit nr's Homepage  Reply with Quote
Depends on what they have dealt with and what the system is like.

I've heard people talk about 100 MB databases being large.

If you're talking about a batch system then probably a million shortish rows is quite small - the sort of thing you can table scan. On a web based oltp system with a lot of clients the same table might be considered large and need to be handled carefully.

Nowadays a lot of databases are talked of in Terrabytes - tens of gigabytes is the sort of size that you don't worry too much about in capacity measurement.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
38200 Posts
Posted - 07/18/2006 :  20:09:23  Show Profile  Visit tkizer's Homepage  Reply with Quote
It's subjective, so it'll be based upon people's opinions only.

My opinion on sizes of tables:

Small -- in the megabytes...thousands of rows or less
Medium -- in the high megabytes and low gigabytes...thousands and perhaps millions of rows
Large -- double digit gigabytes up to half a terabyte maybe...millions of rows
XL -- half a terabyte and beyond...billions of rows

It also depends on the width of the table though. You could have millions of rows in a narrow table, and it might be considered medium sized. If it were wider, then it might be considered large or greater.

Tara Kizer
Edited by - tkizer on 07/18/2006 20:10:06
Go to Top of Page

stubarny
Starting Member

2 Posts
Posted - 07/19/2006 :  05:59:41  Show Profile  Reply with Quote
Thanks for the help guys
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000