Tips for using indexed views in SQL Server 2017 Keep the indexes on the views as narrow as possible. Because each index takes up disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Try to create indexes on...
Tag: OLAP
Troubleshooting SQL Server 2016 Analysis Services problems (Part 2)
Troubleshooting SQL Server 2016 Analysis Services problems (Part 2) If you have problems with SQL Server 2016 Analysis Services (SSAS 2016), review this troubleshooting checklist to find potential solutions. 1. When you run an MDX query in SSAS 2016, the following error may occur: “Dimension attribute was not found”. This problem occurs when the MDX query requests a dimension property,...
Troubleshooting SQL Server 2016 Analysis Services problems (Part 1)
Troubleshooting SQL Server 2016 Analysis Services problems (Part 1) If you have problems with SQL Server 2016 Analysis Services (SSAS 2016), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 Analysis Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server...
Troubleshooting SQL Server 2014 Analysis Services problems (Part 3)
Troubleshooting SQL Server 2014 Analysis Services problems (Part 3) If you have problems with SQL Server 2014 Analysis Services (SSAS 2014), review this troubleshooting checklist to find potential solutions. 1. If you use SSAS 2014. When you run a Multidimensional Expressions (MDX) query against a Many-To-Many dimension, the memory consumption increases very quickly, and surpasses HardMemoryLimit after some time. In […]
Troubleshooting SQL Server 2014 Analysis Services problems (Part 2)
Troubleshooting SQL Server 2014 Analysis Services problems (Part 2) If you have problems with SQL Server 2014 Analysis Services (SSAS 2014), review this troubleshooting checklist to find potential solutions. 1. The error occurs when you process a partition in a measure group in SQL Server 2014 Analysis Services. This is the error message text: “Errors in the high-level relational engine. […]
Troubleshooting SQL Server 2014 Analysis Services problems (Part 1)
Troubleshooting SQL Server 2014 Analysis Services problems (Part 1) If you have problems with SQL Server 2014 Analysis Services (SSAS 2014), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 Analysis Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server […]
Attribute Discretization Part I: Introduction and Overview
Attribute Discretization Part I: Introduction and Overview This is the charter article of the SSWUG Elemental SQL Server Analysis Services Multidimensional 2012 series. – In this and subsequent parts of the article, we will introduce attribute discretization in SQL Server Analysis Services (“SSAS”) – Multidimensional, focusing upon the purpose and benefits of this capability, which, as we shall see, affords...
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 4
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 4 After gaining an overview and performing the preparation for the four-parts of this article in Part 1, we introduced the COUNTROWS() function in Part 2. Then, in Part 3, we explored another DAX function, FILTER(). As we shall see in this, Part 4, of our...
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,...
SQL Server: Database Design Basics – (Part 1)
SQL Server: Database Design Basics – (Part 1) Author: Basit A. Farooq In this article, you will learn about database design concepts. The database design concepts discussed in this article focus almost exclusively on OLTP requirements. OLAP design is beyond the scope of this article. Database design process According to Wikipedia, the term database design can be used to describe...