Viewing 13 posts - 1 through 14 (of 14 total)
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...
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
December 22, 2015 at 7:13 am
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...
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
December 21, 2015 at 7:41 am
I've tried both, unsuccessfully.
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
December 15, 2015 at 8:34 am
Enterprise Edition. Agent was working until we changed the service account.
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
December 15, 2015 at 8:30 am
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.
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
December 15, 2015 at 7:53 am
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...
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
November 13, 2015 at 9:51 am
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...
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
November 13, 2015 at 9:33 am
It is the table I detailed.
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
July 17, 2014 at 9:13 am
Full table DDL, including indexes and trigger definitions
CREATE TABLE [dbo].[lead_ext_attributes]
(
[lead_id] [INT] NOT NULL
, [ExtValue11541] [NVARCHAR](100) NULL
...
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
July 17, 2014 at 8:53 am
<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"...
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
July 17, 2014 at 8:24 am
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...
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
June 26, 2014 at 5:39 am
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...
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
December 5, 2013 at 7:10 am
Thanks all. Your answers confirmed what I believed to be correct.
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
August 7, 2012 at 1:27 pm
Viewing 13 posts - 1 through 14 (of 14 total)