Why we need to use secondry database file? though, we can
do same work using primary database file also.
Answer Posted / sagi.rahul
Secondary files can be used to spread data across multiple
disks by putting each file on a different disk drive which
will improve i/o.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Name few of the dcl commands in sql?
What is sql server used for?
Is it important for a database administrator to understand the operating system and file access?
What is an active database?
Do you know what is xpath?
What is the Disadvantage of indexed sequential file.
What is data block and how to define data block size?
Explain differentiate between a having clause and a where clause?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is ms sql server reporting services?
What is a recursive stored procedure in sql server?
How can you stop stored procedures from recompiling?
What are the different types of data sources in ssrs?
Explain sql delete command?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?