Answer Posted / amrish kumar

USE DataBaseName
GO
SELECT name,physical_name,size,max_size
FROM sys.master_files
WHERE database_id = DB_ID('DataBaseName');
go

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1079

---

How to loop through result set objects using mssql_fetch_array()?

1021

---

What command would you use to create an index?

984

---

What is the fastest way to permanently delete a 1 million row table named customers?

1155

---

Why use identity in sql server?

1012

---

What is sql server profiler trace data file?

1052

---

What do you understand by coalesce in sql server?

1002

---

Which is the latest version of sql server and when it is released?

1031

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112

---

how to avoid cursors? : Sql server database administration

906

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

913

---

Explain how to maintain a fill factor in existing indexes?

929

---

Define full outer join in sql server joins?

916

---

Explain temporary table vs table variable by using cursor alternative?

945

---

What is bcp? When does it use?

874

---