Database Administration |
Database optimization |
SQL Server Reporting Services In Action |
3 more ...
|
Activity:
Question posted: 05 12 2008 00:05:56 +0000,
3 answers, 343 views, last activity
07 06 2010 20:18:08 +0000
|
|
|
|
A very common mistake I come across is 'overusing a table'. If you have similar entities, it is easy to extend your table a little bit and include a field to define the entity-type. This way, you can store all the entities in that single table.
However, this also leads to the fact that when retrieving data from the database, you will have to seperate those entities and it will usually lead to a lot of unused fields in the database because of the fact that those entities slightly differ. More often than not, it will lead to poor performance.
I think most of the database design mistakes is like not using SQL facilities to protect data integrity. and one should also keep in mind that like planning properly, using proper normalization, using a strong naming standards and documenting ones work and to me these are things that even the best DBAs and architects are fighting to make it happen.
That is a good question that should be made by many developers… as I have seen in many customers I was invited to help… a lots of problems came firstly from a poor planning and design (as they often start to “creating tables” on the first thought).Not use of a naming standard is also a problem, as each developer try to put their own meaning on column names; ff course that by ignoring the 3-normal form of normalization can bring several problems on maintenance and also query performance. Another big mistake is not using the tools/features to guarantee the data integrity… some developers are scared of using triggers, check, and other constraints…
- Create a confidential Career Profile and Resume/C.V. online
- Get advice for planning their career and for marketing of experience and skills
- Maximize awareness of and access to the best career opportunities
|
|
Which one is more better secure ? |
|
|
1 referals
17 arguments,
1311 views
|
|
|
Corporations are finding it tough to settle on a single development architecture such as .Net or... |
|
|
3 referals
79 arguments,
2625 views
|
|
|
|
Android the open source mobile OS from the stable of google, will it win over admist stiff... |
|
|
0 referals
6 arguments,
619 views
|
|
|
|
|
|
|
|
|
HI all, I am presently conducting an online survey for IT/Software professionals in India as a... |
|
|
0 referals
0 answers,
0 views
|
|
|
|
HI all, I am presently conducting an online survey for IT/Software professionals in India as a... |
|
|
0 referals
0 answers,
0 views
|
|
|
|
HI all, I am presently conducting an online survey for IT/Software professionals in India... |
|
|
0 referals
0 answers,
0 views
|
|
|
|
|
You can say that money does not bring happiness but I want to ask "REALLY".. Think if you had no money what would you do? You would not be able to satisfy your needs. Anyone who does not earn sufficient money suffers from depression and lack of self... |
Would you buy a ticket to watch football game ?? |
There is a lot more than just illiteracy. There are few women who have made a mark but the number is too less and there rises the concern. If all the women come up to show their power things will change drastically. |