I don't see why you'd need more then 150GB of RAM for a 31GB table.  If that's "the big table" in the db, presumably the entire is only 50 or...

Agreed.  You really want to have all the dbs having the same owner.

We would need DDL for the tables and some cardinality info (how many rows for each condition).

But, overall, IF that is a consistent query pattern, you should cluster the table...

I prefer the 2nd approach, but for the 1st approach:

The processed_flag should be a bit, 0/1, rather than a full char (y/n).  If you already have a bit column(s) in...

Need sample data that is directly usable, that is, CREATE TABLE and INSERT statement(s), not just a splat on the screen.

D'OH, sorry, that should be:

CAST(GETDATE() AS date)

You've already got restrictions based on @LOOK_BACK_PERIOD in the WHEREs, it would just be more efficient to pre-filter rather than waiting until some processing has been done on all the...

Did you add the WHERE condition for the TXN_DATE?  If you have a long history in the table, that would help the most.

Then try an index on (txn_date, company) include...

Need the DDL for the table to sure of more specific recommendations for best speed, but, assuming you will keep a long history in this table:

(1) Either: (A)...

Need the DDL for the table to sure of more specific recommendations for best speed, but, assuming you will keep a long history in this table:

(1) Either:

(A) cluster the table...

I've done similar set ups.  Dynamic SQL is definitely a good choice here.  To keep the FilterAttribute column consistent, I suggest you use a different column to control include or...

The *data* file drives should be 64K.  Log file drives should still be 4K.  If you mix data and log files on the same drive, you'll want to use 64K.

SELECT T3.SYMBOL,
T3.TRADE_DATE,
(AB30_C + AB30_P + AB30_G + AB30_R + AB30_Y) / NULLIF(SUM(CASE WHEN AB30_C = 0 THEN 0 ELSE 1 END + CASE WHEN AB30_P = 0...

I would think you would want four ids:

drive full path (other than drive, of course) filename extension

When new data comes in, you'd pre-add any new ids before loading the...

I would think you would want four ids:

drive

full path (other than drive, of course)

filename

extension

When new data comes in, you'd pre-add any new ids before loading the main table.  That way...