Welcome to EMC Consulting Blogs

Browse by Tags

• .NET
• BI
• DAX
• Excel
• MDX
• recursive
• SQL
• SQL CLR
• SQL Server
• SQL Server 2005
• SQL Server 2005 - Relational
• SQL-CLR
• SSAS
• XML
• Yukon

• Days Since Last Event: TSQL vs. MDX vs. DAX

  I have often had to report the “days since last event”. I’m going to do it here using a variety of query languages and compare them. Consider the following TSQL query on AdventureWorksDW - and the output below. SELECT d . FullDateAlternateKey , COUNT Read More... Posted 15 January 2011 02:17 by christian.wade | 3 Comments Filed under: MDX, SQL Server, SSAS, TSQL, Excel, BI, DAX Attachment(s): Days Since Last in DAX.zip

• SQL Server Standard - Recursive Hierarchies to XML

  I wrote an article for the September 2006 issue of SQL Server Standard magazine: The version that was finally published was a very cut down version with minimal code snippets. This was for obvious reasons; they had to fit the content onto small columns Read More... Posted 20 September 2006 15:21 by christian.wade | 2 Comments Filed under: SQL Server 2005 - Relational, SQL-CLR, SQL Server 2005, Yukon, SQL Server, .NET, XML, SQL CLR, SQL, TSQL, recursive