I see now that it is doing a group by Having at the end.

FROM ACCOUNT_OWNERSHIP_DOC_SUMMARY AS AccountOwnershipDocSummary02 WHERE ((AccountOwnershipDocSummary02.ACCOUNT_MODIFIED_MANUFACTURER_ID IN (SELECT AccountOwnershipDocSummary02_ACCOUNT_MODIFIED_MANUFACTURER_ID0 FROM (SELECT AccountOwnershipDocSummary02.ACCOUNT_MODIFIED_MANUFACTURER_ID AS AccountOwnershipDocSummary02_ACCOUNT_MODIFIED_MANUFACTURER_ID0 FROM ACCOUNT_OWNERSHIP_DOC_SUMMARY AS...

Yes I know it is for upgrading to a new version of sql server. Have you run the sql 2014 upgrade advisor successfully? My mention of...

Apparently nobody uses this Microsoft Tool, and I can see why. I upgraded my local sql 2012 installation to SP3 and ran the tool against that. Got the...

Many variables here. Sometimes fear is a perfectly good reason to stay put, especially if you have a family. Look at our economy since 2008 and how many...

Nobody's seen this error? Remote registry service is running, although not sure why that would matter when running locally.

Thanks Luis, that worked. I was doing replace all in Notepad++ but not getting the right combinations.

Odd quotation marks Should look like " or '

select ‘CREATE CREDENTIAL ‘ + name + ‘ WITH IDENTITY = ”’...

I'm not sure we really have a good way to test a production load in QA. Always been a problem. The other obvious questions are whether...

To prove the need to raise cost threshold for parallelism ( CTP ), I took a query from the prod plan cache with a cost of 35. It has...

Sounds like, based on our hardware and oltp/reporting mix in the same database, I can just try CTFP 25 in QA and see how it goes. Of course, QA...

We don't run production on VMs ( yet ). The query came from here:

[/url]

Thanks Guru. The trick is "proving" to management that we need to increase the value, AND that it won't hurt anything. I have a number of QA environments,...

Yes and in our case anyway, the compiled values are blank. I may look at some things like patindex and charindex as a way to coax out a...

I'll look into extended events, but usually server side tracing is a last resort -- and I realize it has to be done with a scalpel in production.

I usually...

Plan attached for tables ordered large to small in the "except" lines, with hint.

--50k in QA with tables large to small option merge join 02:34

-- 50k in...