Everything SQL related and then some
With the recent debates on the US presidential election we felt it presented a good opportunity to do some text analytics on the second presidential debates. We used the links in the reference section below to do most of the analysis and the results are presented as is. The intention of the post is to…
I was asked this question the other day on linkedin and figured it might be good to write a post on it considering the confusion around the topic. The question was I always read that in case of multiple execution paths, execution plan is saved for the first ever executed path. So if my SP…
Recently there was a requirement for organizing columns from certain dimensions into individual entities within the presentation layer of powerview and powerbi. The approach that was taken was to create additional dimension tables that reference only those subset of columns. Similar to the diagram below. While the above design will do the job, we see…
I am currently facing an issue where profiler is running a trace on SSAS and the trace can’t be stopped from within SSMS profiler since it keeps throwing the below message. Here is a very good link to identify and stop traces that are currently running on SSAS using XMLA commands. Unfortunately this hasn’t worked…