How to create a stored procedure with a statement block in ms sql server?

0 Answers  

---

Is the order of columns in the set clause important in ms sql server?

0 Answers  

---

Explain optimistic and pessimistic concurrency?

0 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

What is the difference between composite index and covering index?

0 Answers  

---

---

How to list all schemas in a database?

0 Answers  

---

Define inner join in sql server joins?

0 Answers  

---

Tell me what is difference between clustered and non clustered index?

0 Answers  

---

What is policy based management (pbm)? : sql server database administration

0 Answers  

---

What is compression - row-level and page-level compression?

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

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

12 Answers   TCS,

---