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 |
|
raysefo
Constraint Violating Yak Guru
260 Posts |
 Posted - 2012-04-30 : 16:50:57
|
| Hi,I wonder if there are cons of using unneccessary columns when creating tables? Best Regards. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-30 : 16:54:11
|
| If they are truly unnecessary, what "pros" would there be? (that alone suggests they should be removed) |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-05-01 : 01:31:26
|
| Overhead in maintenance.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-05-01 : 05:46:04
|
| Space is valuable and costly in terms of Overheads....it should only be used if the requirement is really necessary.N 28° 33' 11.93148"E 77° 14' 33.66384" |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-05-02 : 01:23:11
|
| Adds complexity to troubleshooting. e.f if you're investigating an issue in the future - and detailed documentation is not availableJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
What are the cons of using unneccessary columns?