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

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

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,

AlwaysOn Availability Groups SQL Server

AlwaysOn Availability Groups SQL Server In this post we will learn about AlwaysOn Availability Groups SQL Server. AlwaysOn Availability Groups was first introduced in SQL Server 2012. AlwaysOn Availability Groups SQL Server is the successor of Database mirroring which was introduced with SQL Server 2005 SP1, Database mirroring is a great feature for High Availability and Disaster Recovery,

Delete Hibernation File hiberfil.sys

Delete Hibernation File hiberfil.sys Hi friends in this post we will show you how to turn off hibernation in windows 7 or Delete Hibernation File hiberfil.sys. Hibernation is a power-saving state designed primarily for laptops. Which puts your work and settings in memory and uses a minimum amount of power. Hibernation uses the least amount of power

Change Domain Name in Email ID SQL SERVER

Change Domain Name in Email ID SQL SERVER Recently my organization has changed his domain name, so this will also effect our HR portal. Because our HR portal is authenticate users from AD(Active Directory) also checks users status in HR database which reside on SQL SERVER. My manager asked me to change domain name from

The permissions granted to user ‘Domain\User’ are insufficient for performing this operation. (rsAccessDenied)

The permissions granted to user ‘Domain\User’ are insufficient for performing this operation. (rsAccessDenied) Hi friends in my previous post I had installed SQL Server 2016 – With Reporting Services. So I think a go through is must from reporting services, Although I am looking what Microsoft introduced new on Reporting Services. But after configuration end