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 |
francis_lemos
Starting Member
4 Posts |
Posted - 2011-12-27 : 19:23:26
|
Hihow come my Adventureworks database doesn´t have any .ndf files?are these files only available for SQL Server 2008 entreprise ?should I create them? can I create them?thx |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-08 : 19:43:15
|
When a database created by user only two file created at that time known as mdf and ldf file. If you know that your database going to be grow more then a normal database then to increases the performances we always add the secondary file know as .ndf..But such small sample database its not required .ndf file also its not mandatory for a database creation.Sr Sql server DBA/Artitech |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-08 : 23:20:02
|
In cases where your apply partitioning on tables, the partitions will be stored in different file groups and files corresponding to them will also be having .ndf extensions.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-09 : 04:52:53
|
quote: Originally posted by biswajitdas If you know that your database going to be grow more then a normal database then to increases the performances we always add the secondary file know as .ndf.
Just adding secondary files is not guaranteed to improve performance, there are lots of other considerations. Also, performance is not the only reason one would split a database into multiple files.--Gail ShawSQL Server MVP |
|
|
|
|
|