Paul_Blackler
asked on
Max number of columns in a table if using just the float data type
Hi - because I really dont want to get this wrong - how many float columns can a SQL Server 2000 table hold. I know that the max row size is 8060 bytes.
ASKER
But if a float is used and filled to the maximum, there will be a finite number of columns that could be used surely as we have 8060 bytes - its that number that I am looking for?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And I should have added, IMHO any table that has half as many columns as that is highly suspect.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
By the way when I stated you could have more than 1000 columns, I was making the assumption that you did not allow Nulls. If you do than the total number of columns is significantly less.
ASKER
acperkins - you stated if you did not allow nulls it would be far less - but surely if you did allow nulls it would still be 1000 would it not? :)
>>but surely if you did allow nulls it would still be 1000 would it not? :)<<
Nope. Enabling Nulls requires overhead. Hence less than 1000 columns.
Nope. Enabling Nulls requires overhead. Hence less than 1000 columns.
i do not know if there is any reason why 1 or all of these could not be float