Analysis Services Tabular or Multidimensional? A performance comparison
Can SSAS Multidimensional be faster than SSAS Tabular for distinct counts on large datasets?
We’ve all seen how fast the SSAS Tabular model can work – it’s an in-memory, heavily […] Continue Reading…
SSAS Tabular performance – NUMA update
How does the SSAS 2012 Tabular model performance change when you add more CPU sockets / NUMA nodes?
In my last post (SSAS Tabular NUMA and CPU Cores Performance) I […] Continue Reading…
Renaming an SSAS Tabular Model
I came across a frustrating problem today. I’d just finished processing a large tabular cube (SQL Server 2012), which had taken 11 hours in total.
On trying to connect to […] Continue Reading…
SSAS Tabular – NUMA and CPU Cores Performance
[UPDATE] After further investigation, I found that the tests in this post were inacurate and the results unreliable. Updated NUMA test results here
In my last post (SSAS Tabular Performance […] Continue Reading…
SSAS Tabular performance – DefaultSegmentRowCount
I’m currently investigating a poorly performing Tabular model, and came across some interesting test results which seem to contradict the advice in Microsoft’s Performance Tuning of Tabular Models white […] Continue Reading…
Dimension ProcessAdd in SSAS
When you have very large dimensions in SQL Server Analysis Services (SSAS) cubes, the time taken to process them can cause a problem. This post builds upon an excellent […] Continue Reading…
LogParser Performance Inserting into SQL Server
Recently I’ve been using LogParser a lot to import log files, such as W3C logs from an IIS web server. The distasteful format of these files is made palatable […] Continue Reading…
SQL Relay Interview
A while back Richard Douglas interviewed me regarding my role as Chair of the SQL Relay 2013 conferences.
You can read the resulting interview here!
There’s only two weeks to go […] Continue Reading…
SQL Relay 2013
SQL Relay 2013 is only a month away!
If you’ve not signed up yet to SQL Relay 2013 then you’d better get in there quick, as 2 of the 8 […] Continue Reading…
MDX Between Start Date and End Date
How do you use MDX to find the number of items between two dates, when the start date and end date are different role playing dimensions?
I had an interesting […] Continue Reading…
The Frog Blog
Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.
This is a collection of thoughts, ramblings and ideas that we think would be useful to share.
Authors:
| Alex Whittles (MVP) |  |
| Reiss McSporran |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
| Liam McGrath |  |
