Max. No. of Columns in a Table

How many columns can be created in a table in SQL Server 2000? Is it affect
performance?1024.
The point is that a properly normalized database will never reach that
number.
Don't forger, the maximum row length is 8060 (excluding BLOB data types).
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Moorthy" <Moorthy@.discussions.microsoft.com> wrote in message
news:AB5DCB81-C11E-4128-BA9C-97E0A84F4830@.microsoft.com...
> How many columns can be created in a table in SQL Server 2000? Is it
> affect
> performance?|||The very fact that you ask this question scares me for your database design.
There are so few good RELATIONAL database designs that could actually need
the 1024 column limit that it almost a moot point. And yes, having 1000
columns in a table will not be good for performance either. For starters
every column would have to average less than 9 bytes each, so that would be
bothersome, but it would require that the server deal with all 1000 when you
do a select *
Now, I did highlight RELATIONAL (well, perhaps I screamed it,) because if
you are just using SQL Server as a data storage engine only, rather than
using a file system for all singleton access then who cares. But as that is
so unlikely, I will suggest you might want to get a database design book and
read it before doing any serious design :)
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Moorthy" <Moorthy@.discussions.microsoft.com> wrote in message
news:AB5DCB81-C11E-4128-BA9C-97E0A84F4830@.microsoft.com...
> How many columns can be created in a table in SQL Server 2000? Is it
> affect
> performance?|||The one stop reference for such queries is
"Maximum Capacity Specifications" section BOL.
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"Moorthy" <Moorthy@.discussions.microsoft.com> wrote in message
news:AB5DCB81-C11E-4128-BA9C-97E0A84F4830@.microsoft.com...
> How many columns can be created in a table in SQL Server 2000? Is it
> affect
> performance?|||
"Roji. P. Thomas" wrote:

> The one stop reference for such queries is
> "Maximum Capacity Specifications" section BOL.
>
> --
> Roji. P. Thomas
> Net Asset Management
> http://toponewithties.blogspot.com
>
> "Moorthy" <Moorthy@.discussions.microsoft.com> wrote in message
> news:AB5DCB81-C11E-4128-BA9C-97E0A84F4830@.microsoft.com...
>
> Thanks for you all.
I'm not going to design new database. I'm just going to alter the database
for implementing new features in my project. That'swhy I asked this question
.