Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
SQL Server - Database Design - Best Practices
September 25, 2009
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.
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
.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
Posted Date: December 13, 2009 Points: 5
Go through the following links,
To post reply
Related Questions Related Questions
Image store in Database SQL SERVER
Performing search on MS SQL Server 2008 database
Taking incremental backups from MS SQL Server 2008 Database
How to insert data of selected checkboxlist control in database.. (sql server)
Sql Server 2005 to sql 2000 database conversion
BACK UP SQL Server Database
Find the foreign key in all the tables in a Sql Server Database
How to implement oracle database with sql server?
upload video ((.wmv,.avi,.flv)unlimited size)in asp.net using sql server database(does not save fold
Upload the database in server
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend