Browse by Tags

SSAS: Utility to check you have the correct data types and sizes in your cube definition

This blog describes a tool I developed which allows you to compare the data types and data sizes found in the cube’s data source view with the data types/sizes of the corresponding dimensional attribute. Why is this important? Well when creating named queries in a cube’s data source view, it is often...

Posted to Sparks from the Anvil (Weblog) by DrJohn on Thu, Mar 15 2012
SSAS: Utility to export SQL code from your cube's Data Source View (DSV)

When you are working on a cube, particularly in a multi-person team, it is sometimes necessary to review what changes that have been done to the SQL queries in the cube's data source view (DSV). This can be a problem as the SQL editor in the DSV is not the best interface to review code. Now of course...

Posted to Sparks from the Anvil (Weblog) by DrJohn on Fri, Feb 24 2012
Working with SSAS traces and the dreaded Textdata in SSMS

For good or bad i regularly work with SSAS traces that i have saved to a table and many years ago i was regularly frustrated by the fact that the contents of the textdata column containing the query is always truncated at 65535 characters. You may think 65535 characters should cover most queries but...

Posted to Andrew Calvett (Weblog) by ACALVETT on Sat, Feb 4 2012
SSAS Crash Dump behavior

In SSAS 2005, when an exception occurs, you will always get a crash dump generated in the log directory of the instance and this could potentially lead to a lot of crash dumps consuming resources and a lot of work for the person who has to analyse the contents of each dump. One of the benefits of this...

Posted to Andrew Calvett (Weblog) by ACALVETT on Tue, Jan 17 2012
SSAS - What is running ?

I saw a tweet today from respected blogger john sansom asking how a SQL DBA should attempt to performance tune SSAS. I've been through a similar scenario - and one of the tools I developed as part of my troubleshooting was my own 'SSAS version' of sp_who. I've written a stored procedure...

Posted to Steve Hindmarsh's SQL Blog (Weblog) by steveh99999 on Thu, Dec 15 2011
SQL Server Training in the UK–SSIS, MDX, Admin, MDS, Internals

If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb. Why this company rather than any others? Training based on real world experience by the best in the business. The key to Technitrain...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Nov 23 2011
Introduction to MDX–Training–London

if you are looking to work with Analysis Services then you need to learn MDX and there is no better person to learn it from than Chris Webb Chris is a Microsoft MVP and a leading expert on MDX. He is the co-author of two books, "MDX Solutions" (second edition) and "Expert Cube Development...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Oct 5 2011
Extreme load and “the operation has been cancelled”

There are many reasons why SSAS may generate an operation has been cancelled but i want to take you through a new, although rare, one that i recently discovered. To set the scene I had been tuning the Process Index phase on one of our servers so we could fit a full reindex of a 1.8TB cube comfortably...

Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Sep 18 2011
Two new Analysis Services Blogs

Please welcome two new bloggers Pete Adshead and Christian Bracchi to the blogosphere! These guys truly know what it means to build enterprise class highly scalable Analysis Services Solutions and you now how the opportunity to read about their experiences. Don’t miss out!

Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Sep 18 2011
SSAS 2008 R2 Operations Guide

What can i say but WOO HOO! The SSAS 2008 R2 Operations Guide has been published so download your copy now! This document should be considered essential reading and contains over 100 pages of high quality information for configuring, testing and operating an Analysis Services server. Finally i consider...

Posted to Andrew Calvett (Weblog) by ACALVETT on Thu, Jun 2 2011

Page 1 of 6 (58 items) 1 2 3 4 5 Next > ... Last »