blogs.conchango.com

Jon Axon, Chris Webb, Mosha Pasumansky, Greg Galloway, Darren Gosbell  (and I although not as much as these guys!) have released some very interesting and useful MDX sprocs.  Check out http://www.codeplex.com/Wiki/View.aspx?ProjectName=ASStoredProcedures Enjoy!  

A colleague of mine once asked me to do a “Number of Days since Last Incident” calculated measure (sounds like fun!).  Basically, he had a measure called Incidents and wanted a running count of days since the last incident. E.g.Date        Incidents        ...

I am naturally interested in MDX stored procs so I tried them out.  I have often wondered how they compare to SQL CLR.  I hereby commit myself to (trying to) do a few blog posts in this space!  Here are some findings regarding when to use them.It is well known that the strengths of SQL CLR for real-life scenarios are as ...