You had me up until the point when management began listening to the DBA. After years of being proved right in the end, I still have to fight with...

I happen to use AD groups for security for all database users. However, I cannot eliminate SQL Logins because we have too many vendor applications that require the use...

I've tried both, unsuccessfully.

Enterprise Edition. Agent was working until we changed the service account.

Thank you for your response. However, the KB refers to SQL Server 2008 or SQL Server 2008R2 and I am having this issue with SQL Server 2012 SP2.

The question was more for general knowledge. The actual query is coming from vendor software, resulting in a large number of deadlocks. Unfortunately, I can't change the query...

You are correct. Using IS NULL does result in a SARGable predicate. Must be something with the data that is making it use a clustered index scan when...

It is the table I detailed.

Full table DDL, including indexes and trigger definitions

CREATE TABLE [dbo].[lead_ext_attributes]

(

[lead_id] [INT] NOT NULL

, [ExtValue11541] [NVARCHAR](100) NULL

...

<deadlock-list>

<deadlock victim="processde6c988">

<process-list>

<process id="processde6c988" taskpriority="0" logused="276" waitresource="OBJECT: 5:1913773875:3 " waittime="100" ownerId="15379852" transactionname="user_transaction" lasttranstarted="2014-07-07T20:36:51.157" XDES="0x800d2ff0" lockMode="X" schedulerid="11" kpid="1820" status="suspended" spid="72" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2014-07-07T20:36:51.057" lastbatchcompleted="2014-07-07T20:36:51.057"...

I think Daniel does raise some interesting points. I regularly track missing indexes and unused indexes to see if any indexes need to be created or dropped. I...

I am often amazed by the number of people who will plagiarize another's work merely to create a blog post or comment. I find this most often when someone...

Thanks all. Your answers confirmed what I believed to be correct.