Interested to Buy Any Domain ? << Click Here >> for more details...
Why we need to use secondry database file? though, we can
do same work using primary database file also.
- 2 Answers
- 6751 Views
- Microsoft, I also Faced
- E-Mail Answers
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
Difference between LEN() and DATALENGTH() in sql server ?
Can you explain various data region available in ssrs with their use?
List the different types of collation sensitivities in sql server?
How to make a remote connection in a database?
How to create new tables with "select ... Into" statements in ms sql server?
What are date and time data types in ms sql server?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
what type of index will get created after executing the above statement? : Sql server database administration
What is the use of keyword with encryption. Create a store procedure with encryption?
in the physical file layout, where should the transaction log be stored in relation to the data file?
How to use subqueries with the exists operators in ms sql server?
What are partitioned views and distributed partitioned views?
How is foreign key related to primary key?
How can I tell if sql server is 32 or 64 bit?
What are the types of table?
