Other News

Community

SQL Performance: Use STATISTICS

(george.p.alexander) Sometimes overlooked and innocently missed during the development phase of a project is the existence of poor SQL queries. There can be various excuses for getting poor performance queries. But it won’t be unusual if you find somewhere during the programming life that end users

Community

Normalization for dummies

(Samuel Isaac) Most database designers probably don’t set out trying to “normalize their database”. They just come out with this nice, logical design that happens to be normalized (usually up to the 3rd Normal Form) though that wasn’t the primary goal. The primary goal is usually performance.

Community

Data Joins

When studying relationships, we reviewed techniques of making data from one table available to the records of another table. This demonstrated to reduce data duplication and mistakes. Another issue that involves the combination of tables consists of creating records from more than one table and maki