Monthly Archives: July 2013

Round function in MDX

SQL Server 2005-2012 In most cases you will want to perform a round-operation of your MDX query results by applying a format string. Alternatively, you may want to use client functionality (for example formatting capabilities in Excel) to show the … Continue reading

Posted in Allgemein | Leave a comment

Considerations for the distribution key for distributed tables on PDW (part 2)

PDW v1/PDW 2012 In my last post I started with two important considerations for the distribution key: Skew (data being equally distributed) Distribution compatibility (table joins for most typical queries are supported in an optimal way) So, here are the … Continue reading

Posted in Allgemein | Leave a comment

Considerations for the distribution key for distributed tables on PDW (part 1)

PDW v1/PDW 2012 In a previous post I briefly touched the question how to choose a good distribution key for a PDW distributed table. And also in this post I promised to get back to this topic in more detail … Continue reading

Posted in Allgemein | Leave a comment