The codes look ok.  Something else must be causing your issue.

You can use a query to see which table the view is currently pointing at:

SELECT referenced_schema_name, referenced_entity_name

FROM sys.sql_expression_dependencies

WHERE referencing_id = OBJECT_ID('dbo.Clients')

Also, I'd suggest creating a log table in which you...

I don't think so, I think 0 should mean your query accessed no partitions.  If it had accessed all of them, the total number of partitions should be there.

Review the...

I would never combine these tables.

I'd be much more concerned with determining the best clustered keys for each table.  Or whether, perhaps, they would best be heaps (individual rows are...

Can you post directly usable data, i.e., CREATE TABLE and INSERT statements.

I don't think so. ...

I don't think so.  Where did...

CREATE TABLE #table_1 (
    last_updated date NOT NULL,
    type_desc varchar(30) NULL,
    size_bytes bigint NULL,
    used_bytes...

Other than some advanced troubleshooting cases like Jonathan says, there is no reason you should use NOLOCK in your code.

NOLOCK probably does not do what you think it does. ...

All indexes are tuned to their best (for the current statement)

I'd rather see the actual indexes and the actual query plan for myself.

For example, how many rows are in #GRatings...

No usable sample data, so I can't test it, but this should give you the results you want:

SELECT $month_of_year, $day_of_month,

SUM(CASE WHEN status ='success' THEN 1 ELSE 0...

• This reply was modified 6 years, 2 months ago by ScottPletcher.

True, but even better would be...

True, but that table only has 75K rows.  Create an index with only CommodityID and CommodityName and, yes, SQL will still have to do an index scan, but the overall query...

To help resolve this problem across the board, for all your queries, you really need to re-cluster the CommoditySupplier table.  This is a classic case of the "default clustering by...

WHERE DS.IsActive = 4 AND Std.DepartmentId IS NULL