1024 fields (just for discussion in another forum)

[Juris]

Hi, All!
Does anybody use all 1024 fields in one table?
-OR-
The max number of fields you are using in tables?

Juri Shutenko
Municipality of Maardu, Estonia

http://kodu.neti.ee/~juri4

http://www.hot.ee/jurisfox

 

[SQLDenis]

The more columns you have, the wider the table will be
the wider the table is, the less records you can have per page
The less records you have per page/extent, the more IO SQL Server has to perform to get back a number of records
The more IO sql server has to perform, the slower your system is
That's why you need to normalize
For Data Warehousing it's OK to denormalize and eliminate joins

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[vongrunt]

Let's just say none of my live tables has more than 40 columns.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[Juris]

Thank You! It's quite enough!
Somebody wants to have more than 1024 fields in the ordinary table!
The reference to this thread fulfilled its purpose.


Juri Shutenko
Municipality of Maardu, Estonia

http://kodu.neti.ee/~juri4

http://www.hot.ee/jurisfox