Answer Posted / vial

stored proceure compiles only once and stores in database
managemant system so it is optimized for best performance
while sql query compiles every time and executes using dbms
driver so its performance decreses

What is factless fact table? : sql server analysis services, ssas

1018

---

What are the five characteristics of good data?

908

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

941

---

What is the use of @@spid?

993

---

What stored by the model? : sql server database administration

945

---

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

997

---

What is normalization and its types?

1019

---

Explain error and transaction handling in sql server?

1002

---

Write query to return all rows sql?

1047

---

Tell me what do we need queues in sql service broker?

981

---

How to convert a unicode strings to non-unicode strings?

1094

---

What is SQL Azure Federations?

112

---

What is key attribute?

925

---

What are the requirements for sql server 2016?

878

---

What stored by the master? : sql server database administration

1095

---