Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

Run a SQL Server Job on Conditions of Different Job

Run a SQL Server Job on Conditions of Different Job Hi Friends yesterday i got a mail from my project manager, regarding a job. Which is scheduled for 6:00 PM on daily basis. But he want to implement some conditions for it. Scenario: Actually I have configured a job in SQL Server which is executed

How to Extract Only Date from Getdate in SQL Server

How to Extract Only Date from Getdate in SQL Server Hi friends, in this post we will learn How to Extract Only Date from Getdate in SQL Server or you can say that How to return the date part only from a SQL Server datetime. Sometime we have requirement of only date part from our datetime datatype or

The index cannot be reorganized because page level locking is disabled

Executing the query “ALTER INDEX [cndx_PrimaryKey_WorkflowLog] ON [dbo]…” failed with the following error: “The index “cndx_PrimaryKey_WorkflowLog” (partition 1) on table “WorkflowLogBase” cannot be reorganized because page level locking is disabled. Summary: Recently one of my server index reorganize job start failing. I checked the index name and then enable the page level locks on that

The specified report server URL could not be found.Verify the syntax of the URL and that the report server exists.

The specified report server URL could not be found.Verify the syntax of the URL and that the report server exists. Hi friends yesterday I got a call from my remote team, that they are not able do deploy reports on report server from their system. They told me that error they are facing is: The specified

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,