If the Production.ProductInventory table is clustered on ProductId (and it almost certainly should be), and you specify a specific ProductId or a list of ProductIds, as in the WHERE clause...

Looking at the Clustered Index for the oeordlin_sql table, I'm a wee bit concerned (especially for insert and update performance) over having the leading column be in...

SELECT 
    J.Job, 
    J.Category,
    COALESCE(C.Value, C_All.Value) AS Value
FROM Job J
LEFT OUTER JOIN Category C ON C.Category =...

Sorry, no, I just need to get time to get back to it.  I should be able to do that tomorrow.

We have to reduce the overhead in the Write proc...

Actually, it depends on how the table is searched.

Do you often filter the rows by only type when SELECTing?  If so, then the clus index makes sense...

Looking at the Clustered Index for the oeordlin_sql table, I'm a wee bit concerned (especially for insert and update performance) over having the leading column be in the...

• This reply was modified 4 years, 4 months ago by ScottPletcher. Reason: Edited to improve clarity

What about that doesn't work?

If you don't want any data in the table, use TOP (0) and/or WHERE 1 = 0...

You're welcome.  Thanks for the feedback.

If you would mark it as the answer, it could help people looking at this later, as they will then know the q has been...

Our situation appears to be quite a bit different than yours (and no... neither is wrong, IMHO... they're just different because of different business requirements).  My best friend, who...

I think FULL OUTER JOIN is what you need here:

SELECT
    COALESCE(sales.mth, receipts.mth) AS mth,
    COALESCE(sales.yr, receipts.yr) AS yr,
   ...

Correct.  We never do multiple named instances on a server.  Heh... they still haven't found the body of the last person that tried to do that on our servers....

SQL Server will install some things on the C: / main Windows drive regardless of what you do.

The windows teams have a nasty habit of installing SQL Server on...

Better to script out the indexes; sp_helpindex doesn't show INCLUDEd columns, for one major failing.

A simple sys.sp_helptext on the view to show us its definition is fine.

You could do some major clean up on your existing code:

...6. Since Write_Error_Log is called *so many* times, need to see the code for it too. It needs to...

It also looks like you're querying a view for oeordlin rather than the actual table.  If you are using a view, the text for that view would help us a...