Wednesday, April 24, 2019

[Preview] Limitations of SQL Server 2019

Limitations of MS SQL Server 2019 :

Image Credit :- smallbizclub
  • The ALL SELECTED DAX function is not yet supported.
  • RLS (Row Level Security) defined on the calculation-group table does not yet supported. 
  • Object Level Security defined on the calculation-group table is not yet supported.
  • Details Rows expressions referring to calculation items are not yet supported.
  • MDX is not yet supported.

DAX stands for Data Analysis Expressions.

DAX is a formula language and it contains functions, operators, and constants that can be used in a formula or expression to calculate and return one or more values. 

MDX stands for Multidimensional Expressions.

It is a query language for Online Analytical Processing (OLAP) using with database management system. Same like SQL, it is a query language for OLAP cubes.

MDX is also one of the calculation language, with syntax similar to spreadsheet formulas.

Major limitation:

It only supported queries that used vector-based (batch execution mode), which required the use of a column store index (which works best with analytical workloads, more than transaction processing).

Previous Post
Next Post

post written by: