THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Tabular » PowePivot   (RSS)
Showing page 2 of 2 (13 total posts)
  • Optimize Many-to-Many with SUMMARIZE and Other Techniques

    We are still in the early days of DAX and even if I have been using it since 2 years ago, there is still a lot to learn on that. One of the topics that historically interests me (and many of the readers here, probably) is the many-to-many relationships between dimensions in a dimensional data model. When I and Alberto wrote the The Many to Many ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 1, 2012
  • A new SQL, a new Analysis Services, a new Workshop! #ssas #sql2012

    One week ago Microsoft SQL Server 2012 finally debuted with a virtual launch event and you can find many intro sessions there (20 minutes each). There is a lot of new content available if you want to learn more about SQL 2012 and in this blog post I’d like to provide a few link to sessions, documents, bits and courses that are available now or ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 14, 2012
  • String Comparison in #DAX

    In DAX you don’t have the LIKE operator and you have to use SEARCH instead. However, performance are not very good and it is better to use LEFT and RIGHT if you just need to compare the initial (or ending) match of a string. I just wrote an article about string comparison in DAX. During my exploration of LIKE replacement functions in DAX, I have ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 30, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement