http://www.sqlservercentral.com/Articles tagged Database Design posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load. http://www.sqlservercentral.com/articles/Administering/sizingadatabase/383/2006/06/30http://www.sqlservercentral.com/articles/Administering/sizingadatabase/383/Too often, denormalization is suggested as the first thing to consider when tackling query performance problems. It is said to be a necessary compromise to be made when a rigorous logical design hits an inadequate database system. As the saying goes, “Normalize ‘til it hurts, then denormalize ‘til it works”. In reality, Denormalization always leads eventually to tears.http://www.sqlservercentral.com/redirect/articles/63821/2008/07/23http://www.sqlservercentral.com/redirect/articles/63821/Learn how to build a B-tree similar to those used by databases to implement indexes.http://www.sqlservercentral.com/redirect/articles/63448/2008/06/25http://www.sqlservercentral.com/redirect/articles/63448/This paper provides an introduction to the Unified Dimensional Model (UDM), including the basic end-user model, and a brief overview of the architecture and security models.http://www.sqlservercentral.com/redirect/articles/63189/2008/06/13http://www.sqlservercentral.com/redirect/articles/63189/When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the seasoned programmer is due for one or two surprises.http://www.sqlservercentral.com/redirect/articles/63171/2008/06/04http://www.sqlservercentral.com/redirect/articles/63171/In SQL Server 2005 there is the concept of alias data types, which are similar to user-defined data types in SQL Server 2000. Yakov Shlafman brings us the first part of a series looking at these structures in SQL Server 2000. http://www.sqlservercentral.com/articles/Data+Types/3038/2008/05/30http://www.sqlservercentral.com/articles/Data+Types/3038/Last time, we discussed Table inheritance, which allowed us to easily reduce redundancies in our table design by creating "base" or "super" tables that contain columns and relations that "sub-tables" automatically inherit.http://www.sqlservercentral.com/redirect/articles/63186/2008/05/28http://www.sqlservercentral.com/redirect/articles/63186/In this article I will try to address some of the design suggestions and experiences that I had in managing similar database.http://www.sqlservercentral.com/articles/Database+Design/62804/2008/05/19http://www.sqlservercentral.com/articles/Database+Design/62804/Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online! http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/2008/05/09http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/Part 15 of this series examines what cost is paid when tables are separated into multiple databases on the same server.http://www.sqlservercentral.com/redirect/articles/62902/2008/05/05http://www.sqlservercentral.com/redirect/articles/62902/New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on. http://www.sqlservercentral.com/articles/Miscellaneous/isxmltheanswer/1147/2008/05/02http://www.sqlservercentral.com/articles/Miscellaneous/isxmltheanswer/1147/My company is just starting to look at adding functionality to retain historical data for key tables and columns for auditing purposes in many of our SQL Server databases. I have seen some of your recent tips related to triggers (Forcing Trigger Firing Order in SQL Server and Trigger Alternatives in SQL Server - OUTPUT Clause). Based on using triggers or a similar technology, what is the best way to store the historical data?http://www.sqlservercentral.com/redirect/articles/62769/2008/04/15http://www.sqlservercentral.com/redirect/articles/62769/In our organization, I have noticed that database requirements are never included as a portion of the system requirements. The requirements always focus on the interface and we derive the database design from the interface as well as fill in some of the gaps.http://www.sqlservercentral.com/redirect/articles/62573/2008/03/26http://www.sqlservercentral.com/redirect/articles/62573/Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design. http://www.sqlservercentral.com/articles/Basics/2936/2008/03/25http://www.sqlservercentral.com/articles/Basics/2936/Entity-Attribute-Value model (EAV) is used interchangeably with name for name value pair. This article will try to address advantages and disadvantages of EAV modellinghttp://www.sqlservercentral.com/articles/Database+Design/62386/2008/03/24http://www.sqlservercentral.com/articles/Database+Design/62386/A brief introduction into the world of scalability, presenting at a high-level the various optionshttp://www.sqlservercentral.com/articles/Administration/62465/2008/03/19http://www.sqlservercentral.com/articles/Administration/62465/Importing data files is always a challenge for a DBA, especially when the files might vary in format. Having one codebase is important and new author Mark Balasundram brings us the template for a high performance application to do just that. http://www.sqlservercentral.com/articles/Miscellaneous/2925/2008/03/13http://www.sqlservercentral.com/articles/Miscellaneous/2925/When designing a database, we sometimes come across situations where there are multiple types of entities that we are modeling, but we'd like them to all have certain attributes or relations in common. Using "sub-type" tables is a simple way to implement table inheritance in SQL Server.http://www.sqlservercentral.com/redirect/articles/62349/2008/03/12http://www.sqlservercentral.com/redirect/articles/62349/Everyone should establish some sort of naming convention for their SQL Server platform. It helps to ensure that developers and DBAs can easily find objects and communicate with one another. New author Michael Lato brings us the start of a series on organizing your SQL Server code with an article on naming conventions. http://www.sqlservercentral.com/articles/Naming+Standards/2895/2008/02/29http://www.sqlservercentral.com/articles/Naming+Standards/2895/5 quick tips to help you become a better data modeler and increase your value to your team and organization.http://www.sqlservercentral.com/articles/Data+Modeling/61817/2008/02/19http://www.sqlservercentral.com/articles/Data+Modeling/61817/An IP address is something we all recognize and is a piece of data that is quite prevalent in many systems. However it is a piece of data tha presents some challenges in its storage and retrieval. SQL Server guru David Poole presents us with a look at how you can work with this strange formatting. http://www.sqlservercentral.com/articles/Advanced+Querying/2871/2008/02/19http://www.sqlservercentral.com/articles/Advanced+Querying/2871/Computed columns are an interesting way to cover some queries that might otherwise require a table scan. SQL Server expert Andy Warren brings us a look at this database design feature.http://www.sqlservercentral.com/articles/T-SQL/61764/2008/02/12http://www.sqlservercentral.com/articles/T-SQL/61764/This is one in a series of articles dealing with Database Design following the design of a single system from start to finish.http://www.sqlservercentral.com/articles/Database+Design/61798/2008/01/31http://www.sqlservercentral.com/articles/Database+Design/61798/An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.http://www.sqlservercentral.com/articles/Database+Design/61530/2008/01/03http://www.sqlservercentral.com/articles/Database+Design/61530/Computer professionals are constantly complaining about the documentation for the software they use. And are notorious for not documenting their own code very well. Longtime author Raj Vasant brings us a short article with some suggestions on how to go about documenting your databases. http://www.sqlservercentral.com/articles/Miscellaneous/2784/2008/01/02http://www.sqlservercentral.com/articles/Miscellaneous/2784/In working on an existing database, DBAs often look to normalize tables and correct obvious flaws in design. Recently Andy Warren was working on a consulting project and realized that defaults would prevent many issues. http://www.sqlservercentral.com/articles/Advanced/2779/2007/12/28http://www.sqlservercentral.com/articles/Advanced/2779/An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.http://www.sqlservercentral.com/articles/Data+Modeling/61529/2007/12/27http://www.sqlservercentral.com/articles/Data+Modeling/61529/How many DBAs need a solution to track those changes made for multiple systems? Auditing is becoming more and more prevalent in all systems and having a good solution can really make your DBA job interesting. New author Keren Ramot brings us his technique that works indepedent of the database structure. http://www.sqlservercentral.com/articles/Security/2773/2007/12/26http://www.sqlservercentral.com/articles/Security/2773/An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.http://www.sqlservercentral.com/articles/Data+Modeling/61528/2007/12/17http://www.sqlservercentral.com/articles/Data+Modeling/61528/MySQL's Jim Starkey discusses databases.http://www.sqlservercentral.com/redirect/articles/61646/2007/12/14http://www.sqlservercentral.com/redirect/articles/61646/