May, 2003
How Many's Too Many?
Now that you’re comfortable with many-to-many (M:N) relationships, don’t get complacent. Your database performance can often benefit from taking a relationship in a new direction--for example, by implementing the underused supertype-subtype model.
SQL Server Magazine
|
July, 2001
The First Abnormal Form
Ever find yourself stuck with an assignment to code against poorly designed tables? Learn some tricks that will help you get the data you need from these abnormal tables.
SQL Server Magazine
|
December, 2000
Upgrade Your E-Performance
Adding a little redundancy to your e-commerce database can yield big performance gains.
SQL Server Magazine
|
August, 2000
From Nested Subqueries to Joins
To decrease the load on your processor, check your stored procedures to determine whether you can translate any subqueries into joins.
SQL Server Magazine
|