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 |
stubarny
Starting Member
2 Posts |
Posted - 2006-07-18 : 19:48:20
|
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
12543 Posts |
Posted - 2006-07-18 : 20:01:41
|
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. |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-18 : 20:09:23
|
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 lessMedium -- in the high megabytes and low gigabytes...thousands and perhaps millions of rowsLarge -- double digit gigabytes up to half a terabyte maybe...millions of rowsXL -- half a terabyte and beyond...billions of rowsIt 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 |
 |
|
stubarny
Starting Member
2 Posts |
Posted - 2006-07-19 : 05:59:41
|
Thanks for the help guys |
 |
|
|
|
|