Answer / amrish kumar

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

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

---

can a table be moved to different filegroup? : Sql server administration

0 Answers  

---

What are orphan records?

0 Answers  

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---

Do you know concepts and capabilities of sql server?

0 Answers  

---

What do you mean by a Composite primary key?

0 Answers   Genpact,

---

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

---

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

---

What is collation sensitivity? Explain different types.

0 Answers  

---