SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability

Microsoft TechNet frequently releases White Papers on SQL Server Technology. I have read the following two white papers recently. The summary of its content is here.

Analysis Services Query Performance Top 10 Best Practices

  1. Optimize cube and measure group design
  2. Define effective aggregations
  3. Use partitions
  4. Write efficient MDX
  5. Use the query engine cache efficiently
  6. Ensure flexible aggregations are available to answer queries.
  7. Tune memory usage
  8. Tune processor usage
  9. Scale up where possible
  10. Scale out when you can no longer scale up

Partial Database Availability

Writer: Danny Tambs
Download Word Document

As databases become larger and larger, the infrastructure assets and technology that provide availability become more and more important. The database filegroups feature introduced in previous versions of SQL Server enables the use of multiple database files in order to host very large databases (VLDB) and minimize backup time. In SQL Server 2005 specific files can be set to offline or online.

Reference : Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, ,
Previous Post
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – 15 Signs to Identify Bad DBA
Next Post
SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable

Related Posts

3 Comments. Leave new

Leave a Reply

Menu