Do you know the different ddl commands in sql?

0 Answers  

---

What is repeatable read?

0 Answers  

---

SQL Server Architecture ?

0 Answers   IBM, Sapient,

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

---

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 create user messages with print statements in ms sql server?

0 Answers  

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

What is user-defined function?

0 Answers  

---

What is tabulation?

0 Answers  

---

What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  

---

How to count rows with the count(*) function in ms sql server?

0 Answers  

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---