Answer Posted / Shekher Mishra

{"To prevent an attribute from processing in SSAS, you can set its processing options to 'Do Not Process'. This can be done using the Attribute Processing dialog box or by modifying the XMLA script of your cube."}

How to convert numeric expression data types using the cast() function?

1160

---

How raid can influence database performance?

1133

---

Disadvantages of the indexes?

1235

---

What is the primary use of the model database?

1163

---

How to enter binary string literals in ms sql server?

1260

---

What is the difference between for xml raw and for xml auto?

1130

---

Is it possible to have clustered index on separate drive from original table location?

1054

---

List the ways in which dynamic sql can be executed?

1105

---

How do I find the sql server version?

1119

---

How efficient you are in oracle and SQL server?

1270

---

How do I create a trace in sql server?

1129

---

Can one drop a column from a table?

1101

---

Does view occupy space?

1039

---

How to convert character strings into numeric values?

1203

---

How do I find query history in sql server?

1040

---