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


Top 5 Contributors of the Month
david stephan

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
Hi,

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.

Shravya.

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

Hi,
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

http://stackoverflow.com/questions/387339/database-design-best-practices

http://www.interaktonline.com/Support/Articles/Details/Design+Your+Database-Best+Practices+in+Database+Design.html?id_art=24&id_asc=220

TO Avoid Mistakes
http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

Mark As Answer if this solve your problem
Warm Regards,
Venkat
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
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

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