Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

---

How to use column default values in insert statements in ms sql server?

0 Answers  

---

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

What are the difference between clustered and a non-clustered index?

0 Answers  

---

---

When I run the sql server 2000 setup, it just hangs. What do I do?

0 Answers  

---

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

---

If user is owning any SQL Objects, can we drop that user

0 Answers  

---

How to create user defined functions with parameters?

0 Answers  

---

What is primary key index?

0 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

What are the new features in sql server 2016?

0 Answers  

---