What are mdf,ndf,ldf files and how to see the data in those
files?
Answer Posted / visala
.mdf is extention of primary file,
.ndf is extention of secondary file,
.ldf is extention of log file,
sp_helpfile
| Is This Answer Correct ? | 116 Yes | 10 No |
Post New Answer View All Answers
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
Can we call stored procedure in trigger?
What is difference between cte and view?
What are the types of indexing?
What is query and its types?
What is set nocount on?
what is difference between NULL and ISNULL in SQL Server 2008?
Explain triggers?
Explain an automatic checkpoint
What is serializable?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Is the primary key column of a table an index in ms sql server?
What is use of except clause? How it differs from not in clause?
How to backup SQL Server Reporting Services ?
Tell me what is difference between clustered and non clustered index?