We run the following statement and even though the correct set of records was being chosen by the FROM statement the SET statement was only working on random records. Why?
SET tblOrder.Archive = 0
FROM dbo.tblAllocationDetail INNER JOIN
dbo.tblOrder ON dbo.tblAllocationDetail.lngInvoiceTanID = dbo.tblOrder.lngOrderID
WHERE (dbo.tblAllocationDetail.lngAllocationID IN
FROM dbo.tblOrder AS tblOrder_1 INNER JOIN
dbo.tblAllocationDetail AS tblAllocationDetail_1 ON tblOrder_1.lngOrderID = tblAllocationDetail_1.lngInvoiceTanID
WHERE (tblOrder_1.Archive = 0)))
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.