Answer Posted / poornima k

create table &t_name(&f_name1 &datatype1);

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

1017

---

What is an entity-relationship diagram (erd)?

1200

---

Why and when do stored procedure recompile?

972

---

What is merge statement?

1071

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

973

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1000

---

Can we deploy SSRS reports on our personal website?

168

---

What are built in functions?

993

---

Explain in brief how sql server enhances scalability of the database system?

971

---

How to change the name of a database user?

951

---

explain extended properties

979

---

Mention a few common trace flags used with sql server?

923

---

Does partitioning improve performance?

961

---

What is an expression in ms sql server?

1063

---

How can we solve concurrency problems?

1045

---