1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

Can we linked SharePoint to a SQL database?

0 Answers   Sans Pareil IT Services,

---

what is a mixed extent? : Sql server administration

0 Answers  

---

what is index seek and index scan?

2 Answers  

---

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

What is the difference between coalesce() & isnull()?

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

Ms sql server index?

0 Answers  

---

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

---

How to find the second highest salary of an employee?

0 Answers  

---

What is xdr?

0 Answers  

---