What is partition, how will you implement it? : sql server analysis services, ssas
- 1 Answers
- 1141 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is acid mean in sql server?
Does view occupy space?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is an indexed view?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is temporary table in sql server? Why we use temp table?
What is the difference between upgrade and migration in sql server?
Why use identity in sql server?
What is sql or structured query language?
Where can you add custom error messages to sql server?
What is sql server query analyzer?
What is a coalesce function?
What are the source of constraints?
What is a view in sql?
Can one drop a column from a table?
