What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

---

System variable and temporary variables

0 Answers   Wipro,

---

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

---

Explain linked server in sql?

0 Answers  

---

---

What is 1nf normalization form?

0 Answers  

---

What are the differences between ms sql server & oracle?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What have included columns when we talk about sql server indexing?

0 Answers  

---

Explain what is the main purpose of having conversation group?

0 Answers  

---

Which table keeps the locking information?

0 Answers  

---

How to end a stored procedure properly in ms sql server?

0 Answers  

---