Don't drop the existing table.

Create a new, test (dummy) Quality table UNIQUEly CLUSTERED on ( Quality_Date, Quality_ID ).

CREATE TABLE dbo.Quality_Test ( ... )

CREATE UNIQUE CLUSTERED INDEX QUALITY_Test__CL ON dbo.Quality_Test (...

And again -- and for the last time, so as not to upset everyone --  you likely need to re-cluster the Quality table to get even more performance gains, and...

What almost always gives the best payback is to first do a review of all indexes on the table, particularly on the clustered indexes.  Until you have the best clus...

Because...

According to your sample data and results, the "Answer" you marked is not correct.  For example, you stated that '10000' should return a 1 -- "Anything between 00000...

Hopefully this should improve things.  As I noted before, it's very likely that re-clustering the Quality table would give you even more performance gains, as it would prevent a full...

In the first query, you need to specify a specific db to look at, or include the db name in the results.  The object_ids and index_ids are unique only within...

According to your sample data and results, the "Answer" you marked is not correct.  For example, you stated that '10000' should return a 1 -- "Anything between 00000 to 10000...

We need to see the DDL for the two tables, including all index definitions.

Btw, if the tables really were "properly indexed", you wouldn't be having big performance issues on this...

For the pure SQL part, technically this could theoretically perform better since it avoids using functions on the table columns:

WHERE (p.JCCo=@Company and p.Job=@Job AND Phase NOT LIKE...

So I'm looking for the most efficient way to pull the last 30 minutes of data from the table. This converts it to date\time I want to use DATEADD(s,t_stamp/1000,'1969-12-31...

Be careful with that!  If you need UTC and "kludge" it this way instead, it may...

To get a UTC calc, just substitute GETUTCDATE() for GETDATE() in my code.

Hmm, looks like UTC time.

Or something in the data -- i.e. it's not really ms since 1/1/70 -- or it's local time where the server is?!

I put no max time, so, yes, it would give you everything from then on.

If you want to limit to the then-current time, do this:

WHERE t_stamp >= DATEDIFF_BIG(MS, '19700101', GETDATE())...