About empty field in database

Question

3.67/5 (3 votes)

See more:

Hi Team,

I have a Table, which is contain number of database field are Empty. I just want to be know about that-
1- Is it make any impact on database performance.
2- It it occupied any Spaces in data base.
Please guide me.

Thanks
Ravik

Posted 9-Dec-12 18:52pm

ITSRavik

Add a Solution

Comments

choudhary.sumit 10-Dec-12 0:55am

if they are empty, what is the reason to be exist of them in table? elaborate your question.

ITSRavik 10-Dec-12 8:13am

Empty field goes in table due to use same query syntax, Suppose I have a query like
Insert into MyTable (MyName, MyAddress, MyPhone)values ('ABC', 'xyz', '1234567890')
it's stored all data, but I have partial data (Name and Address)now I enter this data using same query like-
Empty field goes in table due to use same query syntax, Suppose I have a query like
Insert into MyTable (MyName, MyAddress, MyPhone)values ('ABC', 'xyz', '')
now what happen, Phone no. is saved as a Empty.
So My Question is that-
This empty field occupied any space or make any Impact in database performace.
Please help me.

Thanks
Ravik

pradiprenushe 10-Dec-12 1:22am

Good question. check this link
http://stackoverflow.com/questions/3731172/how-much-size-null-value-takes-in-sql-server
http://stackoverflow.com/questions/632332/sql-server-performance-size-drawbacks-of-null-columns
http://www.sql-server-performance.com/2007/datatypes/
http://www.sqlmag.com/article/sql-server-2000/designing-for-performance-null-or-not-null-

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jibesh · Answer 1 · 2012-12-14T08:54:00

While designing a database you must set the size of the each column to avoid any unnecessary allocation of memory and database size while inserting a record.

You said some of the columns may have empty values which you cannot avoid because you cannot design a table for each row value, rather you design column wise.

for eg: if you have set the MyPhone column with varchar size 30 no matter how much data you stored whether it's one char or 10 char or 30 the space allocation is 30. and if you try to store more than that it will crop your data to 30 char length.

so in this case you cannot do anything the better options must be limit the column size to the required length rather setting some arbitrary number. and Yes empty space increases your database size so care must be take while designing your database tables.