Set the maximum query time
Set reasonable memory maximum in SQL 2000
1. Several a few tables that are often queried in your table, that is, transversely divided 2, divide different types into several tables, vertical sections 3, and commonly used construction index 4, servers put a few Hard disk, put data, log, index panel, can improve IO throughput 5, optimizer, optimize your query 6, consider redundancy, this can reduce connection 7, can consider establishing a statistics, is real-time generation total Table, this can avoid counting each time 8, test with extreme data