You have a countless number of decisions to make when designing a database. The following resources are just the tip of the iceberg, but they provide some key database design best practices.
This chapter from the book Beginning Database Design describes various factors affecting database performance tuning, as applied to different database models.
Working with schemas in SQL Server 2005
TIP :If you're managing too many databases with too many objects, it may be time to take advantage of SQL Server 2005's ANSI SQL ...
>>
SQL Server collation conflict fixes
TIP :Fixing SQL Server collation conflict errors when using temp tables in an application and your database collation differs from ...
>>
Database design resources
ASK THE EXPERTS :I'm trying to build an archive of documents, (it may be called a digital library), and could use some help in setting up the ...
>>
Using Microsoft SQL Server triggers
TIP :Not sure why or when to use SQL Server triggers? This series breaks down the basics, including design considerations and ...
>>
SQL Server development shop best practices
TIP :Successful SQL Server development shop best practices, such as creating stored procedures, are explained by Hilary Cotter.
SQL Server's DaVinci code for data modeling
TIP :If you're not aware of all the hidden gems in SQL Server 2000 Enterprise Manager, expert Jeremy Kadlec identifies one toolset ...
>>
Optimizing SQL Server 2000 settings
TIP :Some SQL Server configuration settings must be changed from their defaults to maximize your database transactions per minute. ...
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
