Microsoft SQL Server Development Customer Advisory Team

Process only one partition so you can browse the cube

If you want to browse the cube and validate dimensions, hierarchies and calculations using the data from only one partition, here is what you can do. Deploy the new cube solution, run a process structure for the cube and then process only one of the partitions. Read More...

Using unformatted cell values it may improve query performance

If a report does not use formatted cell values, query time can be reduced. An example is a Reporting Services report that does its own formatting and therefore would not use the formatted values from SSAS. By returning only the value of the cell and not Read More...

Create a default measure in AS2005 cubes

In some cases, it is not obvious or easy to create a default measure in AS2005 cubes. In fact, there is no default measure by default, which can lead to long query times for queries that specify no measures. We have seen slow behavior with several query Read More...

SQLCAT tracks at 2007 SQL PASS

As you may already know from Brian Moran's SQL Server Magazine article " SQLCAT to Offer Six Sessions at PASS ", the SQLCAT team will be providing 6 SQLCAT tracks at the 2007 SQLPASS event in Denver this year. Below are the SQLCAT tracks schedule. (The Read More...

New Best Practices Article

Scale-Out Querying with Analysis Services Using SAN Snapshots Read More...