By Jeffrey Bane, 05/20/2003
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 ...
By Jeffrey Bane, 07/25/2001
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.
By Jeffrey Bane, 12/20/2000
Adding a little redundancy to your e-commerce database can yield big performance gains.
By Jeffrey Bane, 08/01/2000
To decrease the load on your processor, check your stored procedures to determine whether you can translate any subqueries into joins.