What are mdf,ndf,ldf files and how to see the data in those
files?
Answer Posted / padma
When we create a db,the create command will create a data
file with an Extension .mdf,as well as a transaction log
file with extension .ldf
Any additional or secondary data files have .ndf extension
| Is This Answer Correct ? | 121 Yes | 22 No |
Post New Answer View All Answers
What is the difference between cartesian product and cross join?
What is transact-sql language?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is conditional split?
How to find the service pack installed? : sql server database administration
What is xml datatype?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
Explain mixed authentication mode of sql server?
What is a covered index?
What is the cartesian product of table?
Can you explain important index characteristics?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
Explain why variables called the most powerful component of ssis?
How to drop existing indexes in ms sql server?
How do you delete duplicate rows in sql server?