Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Table db Design > new table or lo...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 12096 of 12659
Post > Topic >>

new table or lots of null values

by =?Utf-8?B?c2hhbm5vbnNpZGVy?= <shannonsider@[EMAIL PROTECTED] Aug 7, 2008 at 05:00 AM

Hi,

I have a table of file information. For image files, I wish to include a 
width and height field. Since most of my files are not images these fields

will be null in about 95% of records.

Is it better to put this field in a new table and create a join between
the 
two tables? Is having a field with a lot of null values wasteful? In
Access, 
unlike SQL Server, there is no varchar data type.

I would appreciate any advice.

Regards
John
 




 2 Posts in Topic:
new table or lots of null values
=?Utf-8?B?c2hhbm5vbnNpZGV  2008-08-07 05:00:02 
Re: new table or lots of null values
"Allen Browne"   2008-08-07 21:23:15 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 22:33:32 CST 2008.