February 2008 Entries

SSAS 2008 - small DMV improvement
I was just checking the DMVs in SSAS 2008 CTP6 to see if they had changed between CPT5 & 6. Particularly in regard to the list of limitations that Vidas posted. As far as I can tell the only thing that appears to have changed is that "SELECT DISTINCT" now appears to work. Technorati Tags: Analysis Services, DMV ......

Posted On Friday, February 22, 2008 9:21 AM | Comments (0)

SSAS 2008: Displaying Hierarchical data from DMVs
I just noticed an interesting thing about the schema rowsets when queried using the new DMV syntax and that is that you can drill into hierarchical data - cool. This probably comes out of building the DMV syntax on top of DMX which seems to make a bit of use of nested tables ......

Posted On Friday, February 22, 2008 7:29 AM | Comments (0)

SSAS 2008: What's new in the Schema Rowsets?
I was asking myself this question recently and while I could not find anything in Books Online, it is not too hard to figure this out for ourselves. The following comparison was run between SSAS 2005 SP2 and the February CTP (CTP6) of SSAS 2008. I really love the way that you can discover the metadata in SSAS, all I had to do is to run a DISCOVER_SCHEMA_ROWSETS XML/A command against each server and then use XMLNotepad 2007 to compare the resulting XML. In the SQL Server 2008 you should find that ......

Posted On Thursday, February 21, 2008 2:56 PM | Comments (2)

CTP6 and CU6 are now available - Follow-up
Just a quick follow-up on Chris Webb's recent post about the release of CTP6 for SQL 2008 and CU6 for SQL 2005. Chris mentions that there is still no suggestion that SP3 for SQL Server 2005 is in the works despite having released 6 cumulative update packs. If you would like to see a Service Pack 3 you can add your voice to the push for SP3 by voting for it on connect here: https://connect.microsoft.c... The other interesting thing about the release ......

Posted On Thursday, February 21, 2008 1:51 PM | Comments (0)