http://www.windowsitpro.com/authors/author/author/5777585/rss/5777585en-USSun, 27 May 2012 07:34:57 GMTSun, 27 May 2012 07:34:57 GMThttp://www.windowsitpro.com/article/data-modeling/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.]]>Jeffrey BaneTue, 20 May 2003 00:00:00 GMThttp://www.windowsitpro.com/article/data-modeling/how-many-s-too-many-http://www.windowsitpro.com/article/tsql3/the-first-abnormal-formEver 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.]]>Jeffrey BaneWed, 25 Jul 2001 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/the-first-abnormal-formhttp://www.windowsitpro.com/article/data-modeling/upgrade-your-e-performanceAdding a little redundancy to your e-commerce database can yield big performance gains.]]>Jeffrey BaneWed, 20 Dec 2000 00:00:00 GMThttp://www.windowsitpro.com/article/data-modeling/upgrade-your-e-performancehttp://www.windowsitpro.com/article/tsql3/from-nested-subqueries-to-joinsTo decrease the load on your processor, check your stored procedures to determine whether you can translate any subqueries into joins.]]>Jeffrey BaneTue, 01 Aug 2000 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/from-nested-subqueries-to-joins