Troubleshooting problems with MDS in SQL Server 2017 If you have problems with SQL Server 2017 Master Data Services (MDS), review this troubleshooting checklist to find potential solutions. 1. When you expand the Entities folder on the Manage Groups page in MDS, you may notice that it takes a long time to display all the entities under the folder. In...
Tag: Cumulative Update package
Troubleshooting SQL Server 2014 Indexes (Part 2)
Troubleshooting SQL Server 2014 Indexes (Part 2) If you have problems with SQL Server 2014 indexes, review this troubleshooting checklist to find potential solutions. 1. The error occurs when you try to create indexed view on a partitioned table that has a clustered columnstore index. This is the error message text: “Internal Query Processor Error: The query processor could not […]
Troubleshooting problems with indexes in SQL Server 2012
Troubleshooting problems with indexes in SQL Server 2012 If you have problems with indexes in SQL Server 2012, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 index bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...