can a database be shrunk to 0 bytes, if not, why? : Sql server administration

0 Answers  

---

Describe in brief sql server monitoring ways.

0 Answers  

---

How are the unique and primary key constraints different?

0 Answers  

---

What is Trigger?

3 Answers   Misys,

---

Explain filtered indexes?

0 Answers  

---

---

How to write a query with a full outer join in ms sql server?

0 Answers  

---

What is constraints and its types?

0 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,

---

Can you explain different types of locks in sql server?

0 Answers  

---

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,

---

Explain about system stored procedure?

0 Answers  

---