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 - 2004-02-17 : 08:23:43
|
| farid writes "If I have a high level of inserts,updates,and deletes in my databas, which parameters of the mdf and ldf files do I need to change?Thank you." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-17 : 08:25:21
|
| You don't change any of their "parameters", as these files are handled by SQL Server automatically. You can set up filegroups to distribute data across multiple drives and files, which can increase performance. Without more information on your database though, it will be difficult to provide a more detailed answer. Can you post more information on how many tables you have, how much data is in them, and what kind of application your database is supporting? |
 |
|
|
|
|
|
mdf and ldf files