Jeffrey Bane
   

Jeffrey Bane is a database consultant who specializes in e-commerce and SQL Server. He is an MCSE and an MCDBA.
Email address: jeffreyb@visioninventive.com

4 results found for Jeffrey Bane, displaying items 1 - 4
June 2003

How Many's Too Many? This article is only available to subscribers. Sign up now and get instant access!

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

August 2001

The First Abnormal Form This article is only available to subscribers. Sign up now and get instant access!

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

January 2001

Upgrade Your E-Performance This article is only available to subscribers. Sign up now and get instant access!

Adding a little redundancy to your e-commerce database can yield big performance gains.

SQL Server Magazine

August 1, 2000

From Nested Subqueries to Joins This article is only available to subscribers. Sign up now and get instant access!

To decrease the load on your processor, check your stored procedures to determine whether you can translate any subqueries into joins.

SQL Server Magazine

Add these Headlines to your Website