Re: Partition???

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Dave Wickert [MSFT]" <dwickert@xxxxxxxxxxxxxxxxxxxx>
Date: Sun, 21 Aug 2005 19:06:33 -0700

Since you are just getting started, I would suggest three resources:
1) BOL has a good discussion of partitioning
2) SQL Server 2000 Resource Kit (if you can't get it from your local
bookstore, then try and locate someone in your organization which has a
TechNet subscription. The SQL RK is one of the resource kits that TechNet
re-distributes. The SQL RK has an entire chapter on AS partitioning.
3) The AS Performance Guide
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx

Good luck !
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Paul" <paul_mak@xxxxxxxxxxx> wrote in message
news:%23fJ%23voMpFHA.3036@xxxxxxxxxxxxxxxxxxxxxxx
>I am new to Analysis Service. What is Partition in Analysis Service? How to
>make good use of this? What suitations I should apply partition in OLAP
>cubes? Thanks.
>

.

References:
- Partition???
  - From: Paul

Prev by Date: Re: Multiple .Cab files?
Next by Date: MDX query locked up through http connection
Previous by thread: Re: Partition???
Next by thread: RE: Backing up AS
Index(es):
- Date
- Thread

Relevant Pages

Re: Question on permissions for base tables of Materialized view and mv logs
... PCT not supported with this type of partitioning ... SQL> create materialized view dis_eul.dis_mv ... NOCACHE ... NOPARALLEL ...
(comp.databases.oracle.server)
Re: Validating Surrogate Keys
... the importance of partitioning -- two resources. ... There is an entire chapter in the SQL Server 2000 Resource Kit on this ... SQL BI Product Unit ... Assuming that have an index built on the dimension tables using ...
(microsoft.public.sqlserver.datawarehouse)
Re: Critique of Robert C. Martins "Agile Principles, Patterns, and Practices"
... since all the SQL is concentrated in one place rather than spread out and duplicated. ... From my point of view it is significantly less since I can forget about the SQL and Schema while dealing with the business rules and interface. ... The partitioning of the code in the Payroll example is just that, ... There are many reasons why such a separation might be beneficial. ...
(comp.object)
Re: Critique of Robert C. Martins "Agile Principles, Patterns, and Practices"
... wrap the SQL. ... forget about the SQL and Schema while dealing with the business rules ... The partitioning of the code in the Payroll example is just that, ... such a separation might be beneficial. ...
(comp.object)
Re: Dave W. - where can I get SQL server 2000 resource kit
... find someone in your company who has a Technet subscription. ... produces a Resource Kit CD/DVD which has all of the Microsoft Resource Kits ... SQL BI Product Unit ... >>> Jim ...
(microsoft.public.sqlserver.olap)