You could start with this extended query, and find/analyse the rows having count(*) > 1.

select

purchaseorders.traderid,

suppliers.name,

stockbatches.partid,

allpartmaster.partdesc,

allpartmaster.prodgroup,

goodsreceiptitems.createddate,

stockbatches.warehouseid,

stockbatches.locationid,

stockbatches.quantity,

stockbatches.status,

stockbatches.batchnumber,

stockbatches.batchid,

stockbatches.origin,

stockbatches.unitvalue,

goodsreceiptitems.orderid,

COUNT(*)

from stockbatches

inner join allpartmaster on stockbatches.partid = allpartmaster.partnum

inner join goodsreceiptbatches on stockbatches.batchnumber = goodsreceiptbatches.stockbatchid

inner join...

You probably have a wide index scan, and indexe(s) don't contribute to the query. Can you post the execution plan and someone give you a good advise.

If you can use...

Fist powershell QotD, thanks.

Douglas Osborne-229812 (7/10/2014)

---

I ran one of my 'expensive' stored procedures with 'Include Actual Execution Plan.'

The output ( I green so I notice it - lol ) said I would speed...

Shaun Finnegan (7/6/2014)

---

Hi Igor, so the steps in the article resolved your issue? or did you have to change...

The following article should en-clear about

http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx

Once I had similar issue, and found this article useful

http://technet.microsoft.com/en-us/magazine/jj853293.aspx

It can be even used for random of N numbers of a table

like for e.g in this case:

SELECT TOP 2 *

FROM #Students

ORDER BY NEWID()

Thanks, a very good question.

Erland Sommarskog (7/3/2014)

---

Apparently, you have a transaction active in your application.

I seem to recall that I saw somewhere that MSOLAP does not support distributed transactions.

This should help

EXEC sp_serveroption LINKED_OLAP, 'remote...

Raghavendra Mudugal (7/3/2014)

---

+1

(did the same) Thank you...

ado-712642 (6/26/2014)

---

I had no idea power options would have an impact on that, I always though it had to do with battery powered computers. I have now set it...

TheSQLGuru (6/26/2014)

---

Sorry, but what you propose doing is, in my experience, DISASTROUSLY BAD!!!

1) No where did I see mention of things like "duplicate", "overlapping", etc. The missing...

An error has occured while opening a file, Error 00000005: Access is denied. , file "E:\GDr\Con\Da\X\xxxxxx.dat"".

What are you linking using SQL server login?

Simple maths, thanks!