What are key, name and value columns of an attribute? : sql server analysis services, ssas

0 Answers  

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---

What is resource db in sql server?

0 Answers  

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---

What is page in sql server?

0 Answers  

---

What are the database roles? : sql server security

0 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

Explain the concept of recursive stored procedure.

0 Answers  

---