When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,

---

How to work on DTS?what is the main requirement?

1 Answers   Getit, ivan,

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

how can i view structure of table in sql server? tell me that query.

10 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---

Why use “pivot” in sql server?

0 Answers  

---

How do I find the size of a sql server database?

0 Answers  

---

What do I need to start working with sql studio? : sql server management studio

0 Answers  

---

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 count groups returned with the group by clause in ms sql server?

0 Answers  

---