Reports cannot be run because the Connector for Microsoft SQL Server Reporting Services, a required component for reporting, is not installed on the server that is running Microsoft SQL Server Reporting Services. Hi friends, today I had received an error on Microsoft Dynamics CRM 2011, it seems like some issue with CRM reporting extension. I […]
Author: Mandeep Singh
Index cannot be reorganized because page level locking is disabled Hi Friends, recently my Index reorganize job is failed. When I checked about error: “The index “cndx_PrimaryKey_AsyncOperation” (partition 1) on table “AsyncOperationBase” cannot be reorganized because page level locking is disabled.”. Solution: A DBA can resolve the above error message by enabling Page Level Locking on the index […]
SQL Server DBA Interview Questions & Answers Q: What are indexes and how much non-clustered indexes are there in SQL Server 2008 R2? Ans: An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. 999 non-clustered indexes in SQL Server […]
AlwaysOn Availability Groups SQL Server 2012 In this post we will learn how to configure AlwaysOn Availability Group in SQL Server. I am using SQL Server 2012 Enterprise edition here. On my previous post I have already discussed about introduction of AlwaysOn Availability Groups SQL Server. We have taken two Nodes here to configure AlwaysOn, […]