http://www.windowsitpro.com/authors/author/author/5777585/rsscomment/5777585en-USSun, 27 May 2012 07:35:00 GMTSun, 27 May 2012 07:35:00 GMThttp://www.windowsitpro.com/article/data-modeling/how-many-s-too-many-#commentsAnchorThu, 19 Apr 2007 16:26:54 GMT
To datagod: you might find this article of interest too! Diana May Sr Technical Editor [November 2006] Implementing Supertypes and Subtypes Why, how, and when By: Michelle A. Poolet Solutions by Design InstantDoc #93241 From the November 2006 edition of SQL Server Magazine]]>DianaThu, 19 Apr 2007 16:26:54 GMThttp://www.windowsitpro.com/article/data-modeling/how-many-s-too-many-#commentsAnchorhttp://www.windowsitpro.com/article/data-modeling/how-many-s-too-many-#commentsAnchorTue, 17 Apr 2007 14:06:22 GMT
Loved the article! I have used the super/sub relationships many times without knowing there was an actual official terminology.]]>WilliamTue, 17 Apr 2007 14:06:22 GMThttp://www.windowsitpro.com/article/data-modeling/how-many-s-too-many-#commentsAnchorhttp://www.windowsitpro.com/article/tsql3/the-first-abnormal-form#commentsAnchorTue, 09 Aug 2005 12:59:42 GMT
l337]]>Anonymous User Tue, 09 Aug 2005 12:59:42 GMThttp://www.windowsitpro.com/article/tsql3/the-first-abnormal-form#commentsAnchorhttp://www.windowsitpro.com/article/data-modeling/how-many-s-too-many-#commentsAnchorWed, 28 May 2003 09:40:56 GMT
First of all, good article. But I do have a question. In figure 6, the furniture, trucks and computers subtypes have their PKs named after their types (i.e. FurnitureID, TruckID, etc); however, on figure 1 the subtypes inherited their supertype’s PK name (i.e. VehicleID). In the past, I’ve struggled to decide which format to use, mostly taking the former case, what rules do you adhere to when deciding whether to name the subtypes PK based on their type or based on their supertype’s name?]]>csantos Wed, 28 May 2003 09:40:56 GMThttp://www.windowsitpro.com/article/data-modeling/how-many-s-too-many-#commentsAnchorhttp://www.windowsitpro.com/article/data-modeling/how-many-s-too-many-#commentsAnchorWed, 28 May 2003 09:38:04 GMT
The zip file doesn’t have the CreateAndPopulateDBs.sql script file. Can it be posted on the FTP site?]]>testerWed, 28 May 2003 09:38:04 GMThttp://www.windowsitpro.com/article/data-modeling/how-many-s-too-many-#commentsAnchorhttp://www.windowsitpro.com/article/data-modeling/upgrade-your-e-performance#commentsAnchorFri, 29 Dec 2000 09:03:35 GMT
Excellent article! I recently architected a very large ecommerce site and used Jeff’s techniques to dramatically improve performance.]]>Hal Helms Fri, 29 Dec 2000 09:03:35 GMThttp://www.windowsitpro.com/article/data-modeling/upgrade-your-e-performance#commentsAnchor