Browse by Tags

Working with SSAS traces and the dreaded Textdata in SSMS
04 February 2012 22:06

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 once Excel gets to work it generates some huge queries! Fortunately... Read More...

by ACALVETT | with no comments

Filed under: Tools, Tips, SSMS, SSAS 2005, Analysis Services, SSAS, 2008, SSAS 2008 R2, 2008 R2, SSAS 2008, Trouble Shooting, Profiling

SSAS 2008 R2 Operations Guide
02 June 2011 14:59

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 this document so important i have made a rare exception and... Read More...

by ACALVETT | 1 comment(s)

Filed under: Tools, Tips, Performance, SSAS 2005, Analysis Services, SSAS, SSAS 2008 R2, 2008 R2, Operations Guide, SSAS 2008, Documentation