You could make the parameter that window/time range.

Obviously your underlying will have to change.

If it's always 30 days windows like your two examples suggest (is that sample really representative, or...

• This reply was modified 4 years, 1 month ago by ratbak. Reason: Corrected logic to add 30 days to @days for maximum OpenDate

So you're saying it's a good thing there isn't a BacklogUpdateTrackingTable?

🙂

Indexed views can't reference other databases - Tables must be referenced by two-part names, schema.tablename in the view definition.

Indexed views cannot contain common table expressions.

https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-ver15

https://www.brentozar.com/archive/2013/11/what-you-can-and-cant-do-with-indexed-views/

A couple of possible alternatives:

• Depending...

You have no explicit column(s) by which the data can be you reliably ordered and grouped. You have no ID, date, or other criteria for ordering or grouping the data.

Your sample...

Does csi_sample_specs have an index on csi_sample_id and spec_size (ideally including spec_amount if a nonclustered index)?

How slow is super slow? What is expected/needed execution time? Do other queries execute quickly?

What...

https://www.microsoft.com/en-us/download/details.aspx?id=57474 is just the Service Pack 3 installer.

https://www.microsoft.com/en-us/download/details.aspx?id=57473 has downloads for SQL Express and other components with SP3 integrated.

You probably just need the service pack (57474).

You're often better off using a UNION ALL to separate the cases into statements with their own sargeable where clauses -- e.g.,

SELECT ...
FROM ...
WHERE @Test = 'Yes'...

where len(r.portionkey)=len(m.portionkey)  

The functions are going to prevent SQL Server from using indexes effectively even if you had them. It also seems to indicate that portion...

You have no primary keys or indexes. SQL Server has to scan the table for every query/subquery/CTE.

Your datatypes seem questionable.

• Is PortionKey really ever unicode? Your example shows only ASCII...

What queries use those indexes? Do they (always) use the same columns as predicates (where clauses, joins, order bys)?

Any queries that use the index must use the first index key...

Unfortunately, you missed the requirement that the source and target tables must have identical indexes.

A case statement should do it:

    -- Change operators appropriately if not inclusive
    CASE WHEN Amount >= Column1 AND Amount <=...

Assuming you have a CreatedDateTime or equivalent that is always populated (e.g., has a default value & nobody explicitly sets it to null), yes, it seems possible.

You'd probably use a...

Based on To cool datacenter servers, Microsoft turns to boiling liquid => 3M Immersion cooling for data centers, it sounds like it's one of these: Fluorinert™ Electronic Liquids

It's extremely difficult to get even mostly right, and tends to be a trial and error process of discovering and fixing the logic for those that were mishandled... without breaking...