Welcome to MSDN Blogs Sign in | Join | Help

News

  • Visit the SQL Server Best Practices site (http://sqlcat.com) for real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level.

Browse by Tags

All Tags » Query performan... » Resource Utilization   (RSS)
How to warm up the Analysis Services data cache using Create Cache statement?
Goal This document describes how to build Create Cache commands. Create Cache for Analysis Services (AS) was introduced in SP2 of SQL Server 2005. It can be used to make one or more queries run faster by populating the OLAP storage engine cache first. Read More...
Posted: Thursday, April 26, 2007 2:55 AM by Nicholas Dritsas | 14 Comments
Filed under: , , , , ,
Best SQL Server 2005 MDX Tips and Tricks - Part 1
Overview SQL Server’s 2005 Analysis Services has introduced several changes to the MDX queries syntax that can lead to better performance than the equivalent AS 2000 queries. Here is a list of tips and tricks as well as best practices on how to get better Read More...
Posted: Thursday, October 12, 2006 4:42 AM by Nicholas Dritsas | 2 Comments
Filed under: , , , , ,
Page view tracker