Answer Posted / thirumal reddy

where clause used to impose conditions in any dml operation
ex:
selct * from emp where empid=10
having clause used to impose conditions on group data
ex:

select sum(sal),avg(sal),count(*) from emp
having avg(sal)>2000

Explain the use of containers in ssis?

892

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1148

---

How to set database to be read_only in ms sql server?

956

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

938

---

What is an execution plan? How would you view the execution plan?

1014

---

In what version of sql server were synonyms released?

908

---

What is merge join?

1127

---

What is the difference between a local and a global temporary table?

1055

---

What is the difference between composite index and covering index?

902

---

Do you think BCNF is better than 2NF & 3NF? Why?

1226

---

How would you go about developing a ssrs report?

159

---

What is the difference between indexing and hashing?

1080

---

Where do you find the default Index fill factor and how to change it?

1016

---

Explain the properties of subqueries in sql server?

1019

---

What is the meaning of resultset type_scroll_insensitive?

912

---