Answer / Vipin Chaudhary

Partitioning in SQL Server Analysis Services (SSAS) is a method used to break down a large cube into smaller manageable pieces called partitions. This improves processing performance and response time for the cube by parallelizing calculations. Implementing partition involves creating partitions within a dimension or a fact table, defining the partition function and filter criteria for each partition, and then associating these partitions with the corresponding cube object. The syntax for creating a partition is CREATE PARTITION FUNCTION followed by CREATE PARTITION SCHEME and finally ALTER DATABASE SET PARTITION FUNCTION and ALTER TABLE with SWITCH TO PARTITION commands.

Explain microsoft sql server functions?

1 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

Why de-normalization required?

1 Answers  

---

Can we add a cpu to sql server?

1 Answers  

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

1 Answers  

---

What are the indexes in sql server?

1 Answers  

---

What is usually the first word in a sql query?

1 Answers  

---

How do you create type- insensitive operator?

1 Answers   EXL,

---

What stored by the model?

1 Answers  

---

How you can find out if an index is useful to the optimizer?

1 Answers  

---

What is the use of tempdb? What values does it hold?

1 Answers   Abacus,

---

What is difference between stored procedure and function?

3 Answers   L&T,

---