Selecting the Most Appropriate Data Type

Selecting the Most Appropriate Data Type
Choosing the data type best suited to the values you expect to enter into the Corresponding field is extremely important. When making this decision, take into account the following factors:

The range and type of values that the field will hold
The types of calculations you expect to perform on those values
The manner in which the data is to be formatted for display purposes
The manner in which the data is to be sorted and compared against other fields
The available subtypes for each field and their storage efficiencies
By taking all these factors into consideration at the time of designing your database, you reduce the chance of incompatibilities and storage inefficiencies later. Using the wrong data type can affect both the performance of your RDBMS and the types of operations you can perform on that field. For example, using a VARCHAR type on a field that is meant for numeric or date values could result in unexpected behavior when you perform calculations on it, just as using a large TEXT field for small string values could lead to a waste of space and inefficient indexing.

Published in: on May 10, 2009 at 6:45 pm  Leave a Comment  

Meaning And Types Of Senses

Our senses are infact the windows to the woprld- internal as well as external. These are the gateways of all information that our brain receives by interacting with the stimuli present inside and outside of our body.

Published in: on May 10, 2009 at 8:48 am  Leave a Comment  

Turn on the treadmill

If the prospect of the treadmill workout makes you weep, here area few tactics to inject some fun into the tedium. But If the prospect of the treadmill workout makes you weep, here area few tactics to inject some fun into the tedium. But first, the caveats: Walk at a very slow speed ( about 0.5 to 1MPH) for the first two exercises, then stop the treadmill for the third. If you have time, repeat the whole 3-minute sequence. As you get fitter, you can increase the speed, but we recommend staying at or below 2 MPH.first, the caveats: Walk at a very slow speed ( about 0.5 to 1MPH) for the first two exercises, then stop the treadmill for the third. If you have time, repeat the whole 3-minute sequence. As you get fitter, you can increase the speed, but we recommend staying at or below 2 MPH.

Published in: on May 10, 2009 at 8:44 am  Leave a Comment