Categories
How To Article Technology - Tips

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

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 […]

Categories
Sql Server

Index cannot be reorganized because page level locking is disabled

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 […]

Categories
Sql Server

SQL Server DBA Interview Questions & Answers

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 […]

Categories
Sql Server

AlwaysOn Availability Groups SQL Server 2012

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, […]