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

Is sql server 2016 free?

977

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2410

---

What are different types of roles provided by ssrs?

156

---

What are various limitations of the views?

1090

---

How to create a simple user defined function in ms sql server?

1068

---

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

1199

---

What are relationships and mention different types of relationships in the dbms

1011

---

Where to find ntwdblib.dll version 2000.80.194.0?

1007

---

What is the default port for SQL Server over a firewall?

1141

---

What is a functions and types in sql server?

1144

---

What is the cpu pressure?

1107

---

Where is my database stored on the hard disk in ms sql server?

1106

---

Is it safe to delete log files?

969

---

What is create command?

1019

---

Explain transaction server distributed transaction?

1035

---