Query Performance and Partition Scans in SSAS

July 17, 2011

This blog is SUPER SUPER excited, because for the first time, after four years, we have a guest! I met Mr. Kobi Deutsch in the SQL Explore Convention held about two weeks ago. During a session we both took there, he mentioned something I wasn't aware and I thought maybe I'd bring it to you as well. So, I'm leaving the stage for Mr. Deutsch: Sometimes, when we check the MDX requests in the Profiler, we see that there is a partition that was scanned and loaded into memory although it is not suppose to be touched at all.How...

Error Processing a Cube: Key cannot be null. Parameter name: key

July 13, 2011

I recently opened a new project in SSAS 2008 R2. After finishing developing the cube, I deployed and processed it on the server. I got a really weird error message that meant, unfortunately enough, nothing to me: "Key cannot be null. Parameter name: key" So what's a girl to do? Well actually, I remember that every so often when I was developing a cube, I would have a problem with the data connection. The default I had defined for me when I opened a new connection was .Net Provider\SqlClient Data Provider. And somehow the default definition would always create an error...

SQL Server 2008 R2 SP1 download released

July 12, 2011

Yes, you read it right, Service Pack 1 to SQL Server 2008 R2 was just released. This service pack (as ever) is a bundle of all the cumulative updates thus far for SQL Server 2008 R2. It includes, amongst others, the following things:DMVs for increased supportabilityDAC Framework for improved database upgradesDisk space control for PowerPivot   And while you're looking into the SQL Server 2008 R2 SP1 download, you can also check out the Denali CTP3 download as well (they've been busy as hell in that team lately ;))
no comments