bigator

Archive for the ‘DMX’ Category

MERGE your knowledge from EXPERTS – “Project BOTTICELLI”

Hi guys, I am just about to write an introduction of “Project Botticelli” for you; but they gave their introduction in very nice and precise manner so I decided to extract that and put it here for your quick reference. (Excerpt from https://projectbotticelli.com/about-project-botticelli-ltd) “Project Botticelli Ltd is a small company offering online training by business […]

bigatorJune 6, 2014 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , ,  · Posted in: Business Intelligence, Data Mining, DMX, Excel, MDX, Pivot Table, Power Pivot, SQL Server, SSAS, Suggestion, Training

MDX and DAX Query Formatter …. is back :)

Hi Friends, Just to share with you quickly that “MDX and DAX Query Formatter” site is back online. Here is the link: http://formatmdx.azurewebsites.net/ Thanks, Khilit

bigatorMay 13, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , ,  · Posted in: Business Intelligence, Data Mining, DMX, General, Interview QA, MDX, Query Tuning, SQL Server 2012, SSAS

What is OLAP Database ? What is FASMI?

Hi guys, i was reading an article and came across this term “FASMI“. i have done a little bit of RnD to find out its head & tail. This is what it means: FASMI is an acronym of “Fast Analysis of Shared Multidimensional Information“. A database when called “OLAP Database” if it satisfies following FASMI […]

bigatorSeptember 7, 2012 · bigatorKhilitchandra Prajapati · bigator3 Comments
bigatorTags: , , , , , ,  · Posted in: Business Intelligence, Data Mining, DMX, General, Interview QA, MDX, Pivot Table, Power Pivot, Query Tuning, SQL Server, SQL Server 2012, SSAS, Training, Tutorial

What ?? There is a “Ghost” in SQL Server !!!

Yes, it’s a cleanup process available as a part of SQL Server Storage Engine. It runs in background to cleanup ghost records. If you can remember … “When we create a clustered index then it stores actual data/records at the leaf level of the index.” And SQL Server marks/declares a record as a ghost records […]

bigatorMarch 23, 2012 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , , ,  · Posted in: DMX, Dynamic Management Views, SQL Server

A Set of Boon Tools – SSAS DMVs in SQL Server 2012

Hi All, As you must have heard or started using DMVs (Dynamic Management View) available in SQL Server to get information about local server operations and server health. But today I would like to focus specially on DMVs for monitoring SSAS (SQL Server Analysis Services) and dig-down to find out how powerful it can be. […]

bigatorMarch 1, 2012 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , ,  · Posted in: DMX, Dynamic Management Views, Quick Tips, SQL Server, Uncategorized


bigator