Database Administration |
Database optimization |
SQL Server Reporting Services In Action |
3 more ...
|
Activity:
Question posted: 05 12 2008 00:05:56 +0000,
3 answers, 604 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…
|
|
Though media vs Self |
|
|
157 referals
105 arguments,
3005 views
|
|
|
|
0 referals
3 answers,
332 views
|
|
|
Who has more controlling Power over Environmental concerns...??? |
|
|
1428 referals
48 arguments,
1952 views
|
|
|
|
|
|
|
|
|
does anyone know why the toostep is not updating ? the last updates on my home page are of 20... |
|
|
0 referals
0 answers,
0 views
|
|
|
Hi, I want to know what can be a lean project for A Healthcare industry for a SCM personnel. It... |
|
|
0 referals
0 answers,
0 views
|
|
|
Forged aluminium wheels are very much used in buses, tractors and trailers abroad. Is there... |
|
|
0 referals
0 answers,
0 views
|
|
|
Relationships are definitely important but one wants to be successful and success brings happiness. Happiness which can be shared with the relations we have made.. |
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 ?? |