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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2008-08-19 : 05:23:43
|
| Who designs tables to be full of NULLs on a major scale?Have you seen this? Not for years for me. The odd NULL is fine, but this is 100,000s of rows, 30 columns, vast majority of NULLs apart from the first 1, 2 columns have a few values in there. What's the point?Is this a regular thing? There are 1,000s of tables like this in this company - empty. A few tables OK. Seeing 3 databases like this.What do you say? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-19 : 05:37:36
|
| Depends. You can even consider EAV approach as an alternative for them. |
 |
|
|
|
|
|
NULL Tables