Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-02 : 09:12:51
|
| Jaidev writes "how should i design my tables in SQLSERVER to handle 100 user accessing 5,00,000 rows and how can i improve performanceThanksJaidev" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-02 : 09:20:11
|
| Here on SQL Team there are:Database design articles: http://www.sqlteam.com/FilterTopics.asp?TopicID=100Performance articles: http://www.sqlteam.com/FilterTopics.asp?TopicID=103Books Online also discusses table design, index design, and performance considerations (using filegroups, partitioning data, etc.) Your best bet would be to read about what SQL Server is capable of, then examining your data requirements, and see where the two converge. You can then decide the best approach to designing your database.One thing to keep in mind, is to TEST and MONITOR your database design. Don't just design it and leave it alone afterwards. Performance tuning is an ongoing process that never truly ends. |
 |
|
|
|
|
|
MultiUser Application