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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  How many columns is too much

Author  Topic  gibsonr Starting Member 2 Posts Posted - 2001-09-24 : 17:46:24 Hello all, Using SQL 7.0 and/or SQL 2000, at what point is the # of columns in a table "too" much, and you begin taking a performance hit for it. I realize this a broad question and depends on the size/data type of your fields, however, I'm just looking for a ball-park #. 100 columns, 1000, even more???? Thanks! -rg