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.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-08-23 : 06:15:59
|
| Dear Experts,I'm working for an ERP company, for our product, there are around 2000 tables. in each table, we are using 10 extra columns for our future use. all these are using nvarchar(50) datatype.almost 95% of the columns in these are not in use almost. those are having null value and in some columns, the values are like 0,1...is this affects the performance?please spare your valuble timethank you very muchVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-08-23 : 07:49:13
|
| is that nvarchar(50) datatype will consume memory and cause for less performance?VinodEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-23 : 22:27:09
|
| Empty varchar columns don't take much resource, and shouldn't have performance impact if don't touch them. |
|
|
|
|
|
|
help regarding unused columns