What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

---

What are the different editions available in sql server 2000?

0 Answers  

---

Is foreign key unique?

0 Answers  

---

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

---

What is rolap and its advantage? : sql server analysis services, ssas

0 Answers  

---

---

What is the recursive stored procedure in sql server?

0 Answers  

---

How do you load large data to the SQL server database?

2 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

---