Why there is a need to use secondary database file when the same work can be done with primary databse files?

Posted By: Avi

Date: 1 October 2010 11:40:07 AM

Answer:

Secondary files can be spread over multiple disks which will enhance the I/O operations.
Posted By: avibtech	Date: 1 October 2010 11:40:07 AM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website

Country

Notify me when new Answers are added

Enter the text as shown in the image

What is the purpose of the checkpoint?

Whenever an operation is performed in SQL Server it is not committed directly to the database.All th....

Category: SQL Server

Date: 10/1/2010 12:04:08 PM

Dirty pages in SQL server are the data pages which have been modified and are still lying in the buf....

Category: SQL Server

Date: 10/1/2010 12:03:08 PM

Yes, the logs can be used to fetch the deleted table.For this one has to use some some external tool....

Category: SQL Server

Date: 10/1/2010 12:02:08 PM

With the help of @@version one can determine the Service pack installed on th SQL Server. For this y....

Category: SQL Server

Date: 10/1/2010 12:01:08 PM

Lots of options exists to move the data or databases. Depending on our requirements we can opt for t....

Category: SQL Server

Date: 10/1/2010 12:00:08 PM

View All Questions >>

Signup for our weekly email newsletter