InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 00:37:16 GMT20http://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxGood article. Some more things could be elaborated more.Surrogate key is another issue. Why we need another key, etc. may be another very usefullPreethiG.R. Preethiviraj KulasinghamSun, 13 Jul 2003 02:33:00 GMTG.R.Prithiviraj Kulasinghamhttp://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxThat's a good idea. I'll have to add it to the list of articles I need to write. Of course, if someone is a hardcore data warehousing DBA (I know you guys are out there) write up an article and submit it to Steve, Andy, or Brian Knight!K. Brian Kelleyhttp://www.truthsolutions.com/Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1Thu, 13 Mar 2003 23:08:00 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxI'd like to see a follow up article from the other side of the fence. De-normalizing the databaase for datawarehousing/reporting.In my current contract, where we are building a small datamart, I've run up against a lot of resistance to denormalizing the database.We've been able to alleviate some concerns by keeping the tables somewhat normalized and denormalizing via indexed views, but we still get a lot of weird looks.Hope this helpsPhill Carter--------------------Colt 45 - the original point and click interface <img src=icon_smile_wink.gif border=0 align=middle>Thu, 13 Mar 2003 15:18:00 GMTphilcarthttp://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxmdhealy, I'd agree with you, but unfortunately, it's the reality of the situation. I've been in the position where I've said, "I would prefer you build your database this way..." (DBAs didn't have veto) and when asked why I said, "Normalization!" That's when I got the blank stare.K. Brian Kelleyhttp://www.truthsolutions.com/Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1Thu, 13 Mar 2003 10:22:00 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxHi jrobertsteg,Can you elaborate more on your concerns and perhaps discuss how you'd present it?K. Brian Kelleyhttp://www.truthsolutions.com/Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1Thu, 13 Mar 2003 10:20:00 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxGood article but as Steve said it is indroductary. If you've got developers who don't understand normal forms you've got bigger problems on your hand. Thu, 13 Mar 2003 07:59:00 GMTmdhealyhttp://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxI didn't find this to be very well-written. I gave up on it after seeing repeating data conflated with redundancy and seeing 2NF described as "all attributes describing the entire key". Thu, 13 Mar 2003 07:15:00 GMTjrobertsteghttp://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxI liked your article too. I always hear database people talk about normalization and denormalization and the various levels of normalization without really understanding what they are talking about. Now I understand this better and will understand when I hear it again. Thanks!Robert MardaWed, 23 Jan 2002 15:06:00 GMTRobert W Mardahttp://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxThat is something I plan on doing. This first article was to solve the question of, "What do I give the developers?!?" <img src=icon_smile.gif border=0 align=middle>K. Brian Kelleybkelley@sqlservercentral.comhttp://www.sqlservercentral.com/columnists/bkelley/Wed, 23 Jan 2002 13:47:00 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxBrian,nice introductary article. I'd love to see a followup dealing with more complex designs and including child tables.Steve Jonessteve@dkranch.netWed, 23 Jan 2002 13:30:00 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic2297-59-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/bkelley/normalization.asp>http://www.sqlservercentral.com/columnists/bkelley/normalization.asp</A>Sun, 20 Jan 2002 00:00:00 GMTK. Brian Kelley