sp_helpdb "database name"

What are mdf,ndf,ldf files and how to see the data in those
files?

Question Posted / sankar

Answer Posted / sankar

Is This Answer Correct ?

40 Yes

20 No

Please Help Members By Posting Answers For Below Questions

Describe in brief sql server monitoring ways.

1102

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1124

Explain having clause and where clause?

1096

What are tables in sql server?

1097

Why we need to use secondry database file? though, we can do same work using primary database file also.

7009

What does it mean to be in union?

981

What are system databases into sql server (2005/2008) : sql server database administration

1053

How to execute a sql statement using odbc_exec()?

1218

What are the characteristics of modern DBMS?

1140

What is sub-query in sql server? Explain its properties.

1134

Can you move the resources after pausing the node? : sql server database administration

1167

What is the fillfactor concept in indexes?

1035

What is the difference between getdate and sysdatetime?

1062

What you can do to delete a table without the delete trigger firing?

1012

What is difference between view and materialized view?

987