What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

0 Answers  

---

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

---

What is difference between joins and subqueries?

0 Answers  

---

Can we hide the definition of a stored procedure from a use?

0 Answers  

---

Does union all remove duplicates?

0 Answers  

---

---

why SQL server is more used to store database rather than Access

2 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

---

Why is DML provided?

1 Answers   Ernst Young, Thomson Reuters,

---

Can a table be created inside a trigger?

0 Answers  

---

How to create logins using windows Authentication mode?

2 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---