Answer Posted / gayathri

Every query is submited it will be compiled & then
executed.where as stored procedure is compiled
when it is submitted for the first time and this compiled
content is stored in something called procedure cache,
for subsequent calls no compilation,just execution & hence
better performance than query.
In Query we can execute only 1 statement. Stored Procedure:
In Stored Procedure we can execute Batch of Queries

What are the dis_advantages of stored procedures, triggers, indexes?

2210

---

Explain the properties of the relational tables?

986

---

What is the process of normalising?

991

---

Are semicolons required at the end of sql statements in sql server 2005?

979

---

Explain about service Broker functions?

1025

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1622

---

How to verify a user name with sqlcmd tool?

1066

---

How to use wildcard characters in like operations in ms sql server?

1123

---

When is update_statistics command used?

1029

---

What is the purpose of data source?

1025

---

In which sql server version report builder introduced?

148

---

What do you mean by cardinality?

897

---

What does nvl stand for?

938

---

What does select 1 mean?

919

---

Do you know clustered and non-clustered index?

972

---