What is the ideal size for a table

Question

What is the ideal size for a table

Ather M

SSChasing Mays

Points: 607
More actions
March 26, 2010 at 3:17 pm

#231257

Can somebody tell me what is ideal size for table.
Ideal size means
a. Number of rows ?
b. Number of columns ?
c. Size of table ?
d. Size of Columns ?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

That one comes down to "It Depends". It really does, what is the data that is going to be stored in the table. For one application, you could 40 columns in one table, and 5 in another. There really isn't in single ideal tale size.

GregoryF SSCertifiable Points: 6296 More actions · Answer 2

What the previous poster said, plus OLTP or Warehouse.

There is no one size fit's all approach.

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

Ather M SSChasing Mays Points: 607 More actions · Answer 3

Thanks for your reply....

I agree with you ppl but can you give me some scenarios or link where I can understand it more deeply...

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

That would come down more to database design and theory. The ideal size of the table (number of columns) will depend on your application needs and design specifications.

I would look up Database Design and Normal Forms to try and get a better idea for table design.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

GregoryF SSCertifiable Points: 6296 More actions · Answer 5

There is no one answer. I've worked with OLTP systems that had over 2 billion rows in a frequently accessed table with few problems, I've worked with DW's that a million row table was problematic. It all depends. It depends on:

The Hardware (SAN speed, Server hardware, etc...)

The Software (SQL2000, 2005, 2008, 6.5)

The Middleware

The structure of the queries

The index design

The physical layout of the database

There is no answer on ideal table size, there are so many variable that can go into any answer. It all depends.

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 6

That question is like asking how big a human should be. Do you want to be a fullback for a professional US footbal team or a ballerina?? 😛

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

TheSQLGuru (3/30/2010)
That question is like asking how big a human should be. Do you want to be a fullback for a professional US footbal team or a ballerina?? 😛

Nice analogy.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Paul White SSC Guru Points: 150467 More actions · Answer 8

Ather M (3/26/2010)
Can somebody tell me what is ideal size for table.

The smallest size that meets the needs that inspired its creation.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi