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-12-13 : 08:20:05
|
| Simon writes "Hello,I have a database that has a MDF file that's just over 7Gig. It's for an order and inventory management system. Should I create an NDF file? Can I designate certain tables within the database to a specific NDF file? I'm just affraid that the database is going to burst.Is there anyone who would be willing to work with us on our database (for a fee of course)?RegardsSimon" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-13 : 08:45:43
|
| http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8ynn.aspso 32 TB But you can get better performance by limitting the size of individual files. Depending on your disks it also may be better to spread them over different devices.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-12-13 : 09:44:04
|
quote:
Originally posted by AskSQLTeam
Simon writes "Hello,I have a database that has a MDF file that's just over 7Gig. It's for an order and inventory management system. Should I create an NDF file?
For 7 GB? Noquote:
Can I designate certain tables within the database to a specific NDF file?
Yesquote:
I'm just affraid that the database is going to burst.
For 7 GB? Noquote:
Is there anyone who would be willing to work with us on our database (for a fee of course)?
Absolutely. SQLTeam Consulting. At your service.Just curious, where are you located?RegardsSimon"[/quote]Brett8-) |
|
|
|
|
|
|
how big can a MDF file get?