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 |
|
aidmondo
Starting Member
23 Posts |
 Posted - 2012-05-12 : 06:08:35
|
| What does it mean to 'Create the table designs as per the given relationship diagram ensuring minimum disk space utilization'How do you create tables ensuring minimum disk space utilization?aidmondo |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-05-12 : 07:01:50
|
| Use the minimum sizes required for the data type of each column. For example, if a column would always be 10 characters long, use CHAR(10). Or if you are interested only in dates in 1900 through 2078, use smalldatetime instead of datetime.So, for each of the columns, look up the various data types you could use and pick the one that would use the least amount of storage while satisfying the business requirement. |
 |
|
|
|
|
|
Creating tables