Creating a database as you've described is a lot of work, and as others have mentioned their might be better alternatives than a relational database. (or at least the typical structure for a ...

For this example, I’m choosing the AdventureWorksLT sample database as the source (Figure B). The next step is to create a server to host your SQL database.

1. Index by workload, not by table Many people make the mistake of just guessing at some indexes to create when they are creating database tables. Without an idea of how the tables are going to be ...