Re: sql express 2005 table

Hello GS,

Take a look into 3rd normal form while designing your database model.THis
will help you reducing the storage and provide you better performance.
3 NF normalization is used to reduce the total amount of redundant data in
the database. The less data there is, the less work SQL Server has to
perform, speeding its performance.

http://defiant.yk.psu.edu/~lxn/IST_210/normal_form_definitions.html

Thanks
Hari

"GS" <gsmsnews.microsoft.comGS@xxxxxxxxxxxxxxxxx> wrote in message
news:ekOXNQEbHHA.2552@xxxxxxxxxxxxxxxxxxxxxxx
I hope this is the right ng for sql serer 2005 express
I looked for guideline for optimal table design with regard to attribute
word boundary and other best practise, I failed to din any.


can anyone point me some quick guideline?

In some database, each attribute should ideally start on certain word
boundary otherwise penalty for either storage or performance will occur.




.

Relevant Pages

  • Re: a neophytish normalization question
    ... I am designing a database for a social science project I'm doing. ... I can keep it in 3rd normal form by moving down the levels ... And while I am going to assign things on the bottom a certain ...
    (comp.databases)
  • a neophytish normalization question
    ... I am designing a database for a social science project I'm doing. ... I can keep it in 3rd normal form by moving down the levels ... And while I am going to assign things on the bottom a certain ...
    (comp.databases)
  • Re: reiser4 plugins
    ... And have you ever heared of the problem of Wikipedia storage? ... reduced the database by 85%). ... Reiser4 won't provide anything but the storage part. ... What userland tools you use to acess this filesystem is upon your decission ...
    (Linux-Kernel)
  • Re: reiser4 plugins
    ... > an entire new storage array and this wasn't/isn't cheap. ... > following versions of an article; reduced the database by 85%). ... So a filesystem with intelligent ... Any "unnecessary double work" would squarely be within ReiserFS... ...
    (Linux-Kernel)
  • Re: The Zen nature of a Delphi database application
    ... results directly to UI controls, then write data from the controls to ... then write data back from the modified objects to the DB for storage? ... I load the whole contents of the database into my business objects, ... I have dreamt of the perfect OO database application framework ...
    (comp.lang.pascal.delphi.misc)
Loading