I want to create a DB in production server. In the DB 5 tables will consists lakhs of records.
We are using SQL Server 2005 Enterprise Edition
To produce the better performance i want to create 5 Data Files for 5 tables.Is my approach is right or wrong.
Waiting for valuable replies.
View Complete Post