This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft Logo
Gray Pipe
Developer Network Developer Network Developer
:CreateViewProfileText: Sign in

Subscriber portal

Get tools
  • Downloads
    • Visual Studio
    • SDKs
    • Trial software
      • Free downloads
      • Office resources
  • Programs
    • Subscriptions
      • Overview
      • Administrators
    • Students
      • Microsoft Imagine
      • Microsoft Student Partners
    • ISV
    • Startups
    • Events
  • Community
    • Magazine
    • Forums
    • Blogs
    • Channel 9
  • Documentation
    • APIs and reference
    • Dev centers
    • Samples
    • Retired content
search clear
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Ask a question
Quick access
  • Forums home
  • Browse forums users
  • FAQ
Announcement: 2

Database Design announcement

  • Link
    Database Design Resources
    Arnie Rowland Wednesday, December 23, 2009 8:40 PM

    The following list of database design resources is not intended to be exhaustive or ‘the correct list’. Items are included simply because one of the Moderators knew the material and offered it as a suggestion. If you wish to offer suggestions for inclusion, please do so.

     

    Books

     

    A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

    Eric Johnson and Joshua Jones

    An Introduction to Database Systems

    Chris Date

    Applied Mathematics for Database Professionals

    Lex de Haan, Toon Koppelaars

    Architecting Regulatory-Compliant Architectures
    Mike Walker, Microsoft

    Data Modeling Essential

    Graeme Simsion and Graham Witt

    Database Modeling and Design: Logical Design

    Toby Teorey

    Information Modeling and Relational Databases

    Terry Halpin

    Practical Issues in Database Management: A Reference for the Thinking Practitioner

    Fabian Pascal

    Pro SQL Server 2008 Relational Database Design and Implementation

    Louis Davidson, Kevin Kline, et al

     

    Online Resources

     

    A Simple Guide to Five Normal forms and Relational Database Theory
    http://www.bkent.net/Doc/simple5.htm

    Data Modeling vs. Database Design
    http://www.aisintl.com/case/library/R-Theory_vs_ER/r-theory_vs_er.html

    Data Models
    http://www.databaseanswers.org/data_models/index.htm

    Database Design - Ten Common Database Design Mistakes, Louis Davidson
    http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

    Database Design Issues -EAV Model Discussion (Querying an EAV Table)
    http://tinyurl.com/yks8hu

    Database Design Issues –EAV and OTLT
    http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.html

    Database Design ROI by Paul Nielsen
    http://www.sqlserverbible.com/files/databasedesignroi.pdf

    Introduction to the Unified Dimensional Model (UDM)
    http://technet.microsoft.com/en-us/library/ms345143(SQL.90).aspx

    Library of database models
    http://www.databaseanswers.org/data_models/

    On Normalization and Repeating Groups by Fabian Pascal
    http://www.dbdebunk.com/page/page/622318.htm

    ORM white paper
    http://www.orm.net/pdf/ORMwhitePaper.pdf

    Overview of the Relational Model
    http://www.utexas.edu/its/archive/windows/database/datamodeling/rm/overview.html   

    Understanding Data Model Quality, Graeme Simsion
    http://www.tdan.com/view-articles/5100

     

  • Link
    Please READ before Posting or Replying to Posts
    Arnie Rowland Monday, December 7, 2009 6:27 PM

     


    Out of Scope
     

    Some topics are out of scope for this forum.

    1. Bugs, Product Decisions, and Feedback: The purpose of this forum is not to ask the product team why decisions were made and to ask them to make other changes. That feedback belongs in Connect. The purpose of this forum is to help you out with specific issues, if possible. Please post your feedback via Connect:

    https://connect.microsoft.com/SQLServer

      

    Rules of Conduct

    ·         Relevance to Topics: We encourage you to keep your postings as close to the subject as possible.

    ·         Respect: Please be respectful of other participants, and their contributions; avoiding insults, demeaning remarks and slurs.

    ·         Tolerance: Please don’t assume someone’s curtness was meant to insult, slur, or demean you.

    ·         Confidentiality: Confidential information should not be posted. This is a publicly available forum.

    ·         Appropriate Language: Please keep the conversation on a professional level, avoiding any hint of profanity in your interactions.

    ·         Advertising/Solicitation: Advertisements should not be posted, and will be removed.

    Forum Moderators may, at their discretion, edit posts for clarity, readability and inappropriate language; split post into separate threads when appropriate; and delete post that do not positively contribute to the thread. Failure to comply with these 'Rules of Conduct' may result in your posts being edited to remove the offending comments, censure, or expulsion from participating in the Forums. The bottom line is: this Forum should feel like a ‘safe’ place to ask hard questions that invoke passionate responses.

    Marking Answers

    By their very nature, many database design questions will not have a easily decernible 'answer'. You are encouraged to give folks 'credit' for helping you when appropriate. If someone's response was 'Helpful', use the 'Vote as Helpful' button. If a response answered some part of your question, or provided you one or more clues that led you to a solution, then use the 'Mark as Answer' option. Just as a thread may evolve into multiple questions, it may also have more than one 'Answer'.

    Welcome to the Database Design Forum

    This is a Forum for questions and discussions about database designs for Microsoft technologies, including: SQL Server, Access, SQL Azure, SQL Express, SQL Compact, etc. Often Database Designs will be generic and can be ported to any vendor's technology. Design problems that are best solved with other technologies will be welcomed and addressed to the best of our knowledge and ability.

    We ask that you recognize that database design is a mixture of art and science. You may receive conflicting suggestions, for there can be multiple paths to a workable solution. You will have to use your own judgment and knowledge of your business requirements to determine the best solution for your particular problem. The 'right' design is compounded by many factors, including business, regulatory, hardware/software requirements, as well as staff expertise. We also encourage you to share your experiences with a particular design issue if it will serve to help others encountering similar problems.

    In order to receive useful responses, please spend some time and properly present your scenario. Attempts to 'save time and effort' by cutting out parts of the scenario will often lead to wasted time and effort as the suggestions have to be discarded because they don't work with other parts of the unseen puzzle.


    But there are limits to what you can expect from volunteers through a disconnected medium. The questions most likely to receive a good and targeted answer, are those that present a small problem, that give a very clear description of that problem within its context, and that are placed by people with a fair understanding of the subject who need help getting over a few nasty bumps. The questions that are almost impossible to answer satisfactorily are those that present a huge problem, with no clear description, and asked by someone totally new to the subject matter.

    We hope that you will understand when we say that most of us that volunteer our time on this Forum do so in order to help folks learn. We will be pleased if you find the Forum to be useful. However, it is difficult or impossible for us to engage with folks privately. We don't have time to do both, and our commitment is help folks using the Forums.

    Do not hesitate to read all of the threads, join in the discussions, offer your own experiences and information, and ask questions to increase your knowlege. Seek out blogs from those who write in a manner that you appreciate, and consider reviewing the Database Design Resources for additional guidance and help.

     

  • Remove From My Forums

Forums [ view all ]

Selected forums

Clear
Database Design
x
Filter : All threads
All threads
Answered
Unanswered
Proposed answers
General discussion

No replies
Helpful
Has code

All languages
Sort : Most recent post
  • Most recent post
  • Most recent thread
  • Total votes
  • Total replies
  • large check mark
    0 Votes

    POSTING TIPS - Code, Diagrams, Hyperlinks, Details

    SQL Server
     > 
    Database Design
    When you're posting a question - please search the forum first!  If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below.  If you want to show us a database ...
    Sticky | 0 Replies | 8661 Views | Created by Kalman Toth - Wednesday, March 26, 2014 12:22 AM
  • large check mark
    0 Votes

    using case statment to check that a date is in the right format

    SQL Server
     > 
    Database Design
    I am creating a data quality table. I want to use a case statement to check that all the  dates in a date of birth column in another table is in the (yyyy/mm/dd) format. if it is then I ...
    Unanswered | 1 Replies | 38 Views | Created by legendarycowboy - 8 hours 36 minutes ago | Last reply by Tom Phillips - 8 hours 7 minutes ago
  • large check mark
    3 Votes

    Cannot drop schema 'VCS' because it is being referenced by object 'xyz'

    SQL Server
     > 
    Database Design
    Proposed | 5 Replies | 179 Views | Created by ashwan - Friday, February 8, 2019 12:21 AM | Last reply by TiborK - Tuesday, February 12, 2019 9:21 AM
  • large check mark
    2 Votes

    Appropriate variable type for list of char values while creating table

    SQL Server
     > 
    Database Design
    Hi I am converting MySQL database to SQL server database. I need to use a variable with pre-set text values while creating a table. In MySQL the following works ...
    Proposed | 3 Replies | 111 Views | Created by jacks4545 - Monday, February 11, 2019 4:57 PM | Last reply by Emily Fei - Tuesday, February 12, 2019 6:27 AM
  • large check mark
    3 Votes

    How do I properly audit changes in my tables?

    SQL Server
     > 
    Database Design
    It's my first time creating an audit log for a PoS WPF application and was wondering on how exactly do I implement an auditing system because it seems like each option available has its ups and downs. ...
    Proposed | 3 Replies | 405 Views | Created by MarkusTrim - Thursday, September 20, 2018 6:46 PM | Last reply by Ed Price - MSFT - Monday, February 11, 2019 9:04 PM
  • large check mark
    1 Votes

    Clarification on First Normal Form

    SQL Server
     > 
    Database Design
    For the most part, I understand first, second, and third normal form. I would just like clarification on a few normalization examples I found on the net. The first example is as ...
    Proposed | 3 Replies | 372 Views | Created by ZampanoLievre - Wednesday, May 23, 2018 9:45 PM | Last reply by Ed Price - MSFT - Monday, February 11, 2019 8:48 PM
  • large check mark
    4 Votes

    Database Modeling For GeoLocation Networking App

    SQL Server
     > 
    Database Design
    Hello, I am trying to create a Geo-Location networking mobile app DATA MODEL. I am not sure if i have covered all so wanted to get advice from experts who are ...
    Proposed | 6 Replies | 394 Views | Created by SenthilP Nathan - Friday, August 3, 2018 8:27 PM | Last reply by Ed Price - MSFT - Monday, February 11, 2019 8:40 PM
  • large check mark
    1 Votes

    Database for committee sessions - your opinion

    SQL Server
     > 
    Database Design
    I would like your opinion on this project of mine. It’s part of a system for managing refugees asylum requests examined by a commission. This first part of ...
    Unanswered | 2 Replies | 465 Views | Created by liuc - Friday, August 24, 2018 1:39 PM | Last reply by Ed Price - MSFT - Monday, February 11, 2019 8:37 PM
  • large check mark
    3 Votes

    SQL Sub-query error

    SQL Server
     > 
    Database Design
    I'm not sure exactly how to make a sub-query in SQL This is my attempt but there is an error that stops if from working.  Msg 1033, Level 15, State 1, Line ...
    Proposed | 4 Replies | 339 Views | Created by Karlossimo - Sunday, October 14, 2018 2:16 PM | Last reply by Ed Price - MSFT - Monday, February 11, 2019 8:34 PM
  • large check mark
    1 Votes

    SQL Cluster Patching practice

    SQL Server
     > 
    Database Design
    Hi Members, I was following SQL cluster patching process generally as follows  Patch Node 2(Passive node). Switch over services to Node ...
    Answered | 3 Replies | 365 Views | Created by Akash Pawar - Thursday, December 6, 2018 7:18 AM | Last reply by Ed Price - MSFT - Monday, February 11, 2019 8:20 PM
  • large check mark
    3 Votes

    Problem in persian Collation 'ی' and 'ي'

    SQL Server
     > 
    Database Design
    Hi In Server by Collation persian, I try to Create Table But have Problem by Char , NChar, VarChar, NVarChar. CREATE TABLE [dbo].[test](   ...
    Unanswered | 3 Replies | 482 Views | Created by H. R. Heydari - Sunday, October 7, 2018 10:57 AM | Last reply by Ed Price - MSFT - Monday, February 11, 2019 8:19 PM
  • large check mark
    0 Votes

    SQL storage of date not working

    SQL Server
     > 
    Database Design
    I have some data coming in from Twitter as date/time.  I have tried to convert this into date see pic attached.  This works but when it enters powerBI it is not a date format... it is ...
    Answered | 6 Replies | 118 Views | Created by matthew appleyard - Tuesday, February 5, 2019 9:19 AM | Last reply by matthew appleyard - Tuesday, February 5, 2019 11:34 AM
  • large check mark
    0 Votes

    Protect Data

    SQL Server
     > 
    Database Design
    I don't want someone to see the whole data. Especially for credit cards' numbers, telephone and so on. How to protect these ...
    Answered | 2 Replies | 134 Views | Created by SQLNewer007 - Monday, February 4, 2019 4:58 PM | Last reply by Emily Fei - Tuesday, February 5, 2019 6:48 AM
  • large check mark
    2 Votes

    Is there way I can capture table growth daily?

    SQL Server
     > 
    Database Design
    Hello, Is there way I can capture tables growth on daily basis? 
    Proposed | 2 Replies | 135 Views | Created by Danny2426 - Monday, February 4, 2019 7:30 PM | Last reply by Emily Fei - Tuesday, February 5, 2019 6:12 AM
  • large check mark
    0 Votes

    Unable to start SQL Server instance 2016 R2

    SQL Server
     > 
    Database Design
    I am configuring SQL server 2016 R2 Cumulative Update (CU4) Builds 13.0.5233.0 Now I already installed and setup to start using service users. SQL startup and worked ...
    Answered | 7 Replies | 313 Views | Created by ashwan - Friday, January 25, 2019 5:21 AM | Last reply by ashwan - Tuesday, February 5, 2019 5:19 AM
  • large check mark
    6 Votes

    simple SQL table very slow, help me optimize please

    SQL Server
     > 
    Database Design
    This table I created <g class="gr_ gr_35 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="35" id="35">have</g> 16 million rows ...
    Proposed | 6 Replies | 287 Views | Created by kfcnhl88 - Thursday, January 31, 2019 7:16 PM | Last reply by Tom Phillips - Friday, February 1, 2019 1:09 PM
  • large check mark
    3 Votes

    How to Normalize and Design the Database

    SQL Server
     > 
    Database Design
    A Company has the Following Departments. They need to build a letter management system. That means, some persons, companies and government agencies send letters to them. They need ...
    Proposed | 3 Replies | 153 Views | Created by Kumarasiri - Thursday, January 31, 2019 6:51 AM | Last reply by scott_morris-ga - Thursday, January 31, 2019 1:17 PM
  • large check mark
    1 Votes

    Microsoft Corp. Select Plus SQL Server Standard 2 Core 2017 License Only Level A

    SQL Server
     > 
    Database Design
    Hello, We have purchased Part No: 7NQ-01194 (Microsoft Corp. Select Plus SQL Server Standard 2 Core 2017 License Only Level ...
    Proposed | 1 Replies | 140 Views | Created by Pawan KKumar - Thursday, January 31, 2019 8:11 AM | Last reply by Olaf Helper - Thursday, January 31, 2019 8:22 AM
  • large check mark
    5 Votes

    how to remove alphanumeric characters from numeric value

    SQL Server
     > 
    Database Design
    Dears, i have one column in my table called 'salary',unfortunately we have alphanumeric values also there in that filed.my values are like below. for example ...
    Proposed | 5 Replies | 329 Views | Created by ds_999 - Tuesday, January 15, 2019 11:40 AM | Last reply by TheBrenda - Monday, January 28, 2019 9:43 PM
  • large check mark
    0 Votes

    Monitoring records to take action on.

    SQL Server
     > 
    Database Design
    1 I have my software run another query to get all the data and print a label.   This is using up a lot of SQL server resources and I am wondering if there ...
    Answered | 5 Replies | 278 Views | Created by Pisteuon - Friday, January 25, 2019 7:20 PM | Last reply by TheBrenda - Monday, January 28, 2019 9:40 PM
  • large check mark
    1 Votes

    What is Alternative of numbered_procedures?

    SQL Server
     > 
    Database Design
    Hi every body I use numbered_procedures because of versioning purpose. (Notice: versioning means version of live and up procedures and Doesn't mean source control ...
    Answered | 7 Replies | 427 Views | Created by Hamid309 - Saturday, January 19, 2019 6:14 AM | Last reply by Hamid309 - Sunday, January 27, 2019 1:53 PM
  • Items 1 to 20 of 4284 Next ›
Announcement: 2

Database Design announcement

  • Link
    Database Design Resources
    Arnie Rowland Wednesday, December 23, 2009 8:40 PM

    The following list of database design resources is not intended to be exhaustive or ‘the correct list’. Items are included simply because one of the Moderators knew the material and offered it as a suggestion. If you wish to offer suggestions for inclusion, please do so.

     

    Books

     

    A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

    Eric Johnson and Joshua Jones

    An Introduction to Database Systems

    Chris Date

    Applied Mathematics for Database Professionals

    Lex de Haan, Toon Koppelaars

    Architecting Regulatory-Compliant Architectures
    Mike Walker, Microsoft

    Data Modeling Essential

    Graeme Simsion and Graham Witt

    Database Modeling and Design: Logical Design

    Toby Teorey

    Information Modeling and Relational Databases

    Terry Halpin

    Practical Issues in Database Management: A Reference for the Thinking Practitioner

    Fabian Pascal

    Pro SQL Server 2008 Relational Database Design and Implementation

    Louis Davidson, Kevin Kline, et al

     

    Online Resources

     

    A Simple Guide to Five Normal forms and Relational Database Theory
    http://www.bkent.net/Doc/simple5.htm

    Data Modeling vs. Database Design
    http://www.aisintl.com/case/library/R-Theory_vs_ER/r-theory_vs_er.html

    Data Models
    http://www.databaseanswers.org/data_models/index.htm

    Database Design - Ten Common Database Design Mistakes, Louis Davidson
    http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

    Database Design Issues -EAV Model Discussion (Querying an EAV Table)
    http://tinyurl.com/yks8hu

    Database Design Issues –EAV and OTLT
    http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.html

    Database Design ROI by Paul Nielsen
    http://www.sqlserverbible.com/files/databasedesignroi.pdf

    Introduction to the Unified Dimensional Model (UDM)
    http://technet.microsoft.com/en-us/library/ms345143(SQL.90).aspx

    Library of database models
    http://www.databaseanswers.org/data_models/

    On Normalization and Repeating Groups by Fabian Pascal
    http://www.dbdebunk.com/page/page/622318.htm

    ORM white paper
    http://www.orm.net/pdf/ORMwhitePaper.pdf

    Overview of the Relational Model
    http://www.utexas.edu/its/archive/windows/database/datamodeling/rm/overview.html   

    Understanding Data Model Quality, Graeme Simsion
    http://www.tdan.com/view-articles/5100

     

  • Link
    Please READ before Posting or Replying to Posts
    Arnie Rowland Monday, December 7, 2009 6:27 PM

     


    Out of Scope
     

    Some topics are out of scope for this forum.

    1. Bugs, Product Decisions, and Feedback: The purpose of this forum is not to ask the product team why decisions were made and to ask them to make other changes. That feedback belongs in Connect. The purpose of this forum is to help you out with specific issues, if possible. Please post your feedback via Connect:

    https://connect.microsoft.com/SQLServer

      

    Rules of Conduct

    ·         Relevance to Topics: We encourage you to keep your postings as close to the subject as possible.

    ·         Respect: Please be respectful of other participants, and their contributions; avoiding insults, demeaning remarks and slurs.

    ·         Tolerance: Please don’t assume someone’s curtness was meant to insult, slur, or demean you.

    ·         Confidentiality: Confidential information should not be posted. This is a publicly available forum.

    ·         Appropriate Language: Please keep the conversation on a professional level, avoiding any hint of profanity in your interactions.

    ·         Advertising/Solicitation: Advertisements should not be posted, and will be removed.

    Forum Moderators may, at their discretion, edit posts for clarity, readability and inappropriate language; split post into separate threads when appropriate; and delete post that do not positively contribute to the thread. Failure to comply with these 'Rules of Conduct' may result in your posts being edited to remove the offending comments, censure, or expulsion from participating in the Forums. The bottom line is: this Forum should feel like a ‘safe’ place to ask hard questions that invoke passionate responses.

    Marking Answers

    By their very nature, many database design questions will not have a easily decernible 'answer'. You are encouraged to give folks 'credit' for helping you when appropriate. If someone's response was 'Helpful', use the 'Vote as Helpful' button. If a response answered some part of your question, or provided you one or more clues that led you to a solution, then use the 'Mark as Answer' option. Just as a thread may evolve into multiple questions, it may also have more than one 'Answer'.

    Welcome to the Database Design Forum

    This is a Forum for questions and discussions about database designs for Microsoft technologies, including: SQL Server, Access, SQL Azure, SQL Express, SQL Compact, etc. Often Database Designs will be generic and can be ported to any vendor's technology. Design problems that are best solved with other technologies will be welcomed and addressed to the best of our knowledge and ability.

    We ask that you recognize that database design is a mixture of art and science. You may receive conflicting suggestions, for there can be multiple paths to a workable solution. You will have to use your own judgment and knowledge of your business requirements to determine the best solution for your particular problem. The 'right' design is compounded by many factors, including business, regulatory, hardware/software requirements, as well as staff expertise. We also encourage you to share your experiences with a particular design issue if it will serve to help others encountering similar problems.

    In order to receive useful responses, please spend some time and properly present your scenario. Attempts to 'save time and effort' by cutting out parts of the scenario will often lead to wasted time and effort as the suggestions have to be discarded because they don't work with other parts of the unseen puzzle.


    But there are limits to what you can expect from volunteers through a disconnected medium. The questions most likely to receive a good and targeted answer, are those that present a small problem, that give a very clear description of that problem within its context, and that are placed by people with a fair understanding of the subject who need help getting over a few nasty bumps. The questions that are almost impossible to answer satisfactorily are those that present a huge problem, with no clear description, and asked by someone totally new to the subject matter.

    We hope that you will understand when we say that most of us that volunteer our time on this Forum do so in order to help folks learn. We will be pleased if you find the Forum to be useful. However, it is difficult or impossible for us to engage with folks privately. We don't have time to do both, and our commitment is help folks using the Forums.

    Do not hesitate to read all of the threads, join in the discussions, offer your own experiences and information, and ask questions to increase your knowlege. Seek out blogs from those who write in a manner that you appreciate, and consider reviewing the Database Design Resources for additional guidance and help.

     
Help us improve MSDN.
Visit our UserVoice Page to submit and vote on ideas!
Make a suggestion

Dev centers

  • Windows
  • Office
  • Visual Studio
  • Microsoft Azure
  • More...

Learning resources

  • Microsoft Virtual Academy
  • Channel 9
  • MSDN Magazine

Community

  • Forums
  • Blogs
  • Codeplex

Support

  • Self support

Programs

  • BizSpark (for startups)
  • Microsoft Imagine (for students)
United States (English)
  • Newsletter
  • Privacy & cookies
  • Terms of use
  • Trademarks
logo © 2019 Microsoft