.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

SQL Server - Database Design - Best Practices

Posted By: Shravya     Posted Date: September 25, 2009    Points:2   Category :Sql Server

We are developing an ASP.NET application and carrying out the database design too.

Kindly let me know if you know any best reference document for SQL Server database design - best practices.

Thank you.


Author: Venkat             
Posted Date: September 25, 2009     Points: 5   

I will recommend you to read this articles o have better under standing about the best database practices..which includes normalization and more

Some points
.Learn as much as you can about problem domain. You can't create good data model without knowing what you're designing for
.Have good knowledge about data types provided by your database provider
.How to properly use normalisation and design tables
.Performance: when and how to apply indexes, how to write efficient queries etc.
.When and how to use different DB objects like views, procedures, functions, triggers



TO Avoid Mistakes

Mark As Answer if this solve your problem
Warm Regards,
Author: Abhisek Panda             
Posted Date: December 13, 2009     Points: 5   

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend