Viewing 5 posts - 1 through 5 (of 5 total)
SELECT dbo.Product.Id, dbo.ProductStock.AvgCostPrice
FROM dbo.Product
LEFT OUTER JOIN dbo.ProductStock ON dbo.Product.Id = dbo.ProductStock.ProductId
WHERE dbo.Product.Family = '0001' AND dbo.Product.Number = '043001' AND (dbo.ProductStock.BranchId = 13)
This will never give a result because there...
July 29, 2011 at 4:04 am
I'm confused with the results i get from the dm_db_missing_index_details.
If i understand correct i should add the indexes in de included_columns column.
While it shows indexes that we already made.
So which...
July 19, 2011 at 7:37 am
Viewing 5 posts - 1 through 5 (of 5 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy