Very cool, thanks!

Haven't found anything on my first question of using something like localhost in the server field. But I did find out about SQL Agent Tokens
https://docs.microsoft.com/en-us/sql/ssms/agent/use-tokens-in-job-steps?view=sql-server-2017

And in...

I suspect this join condition is the problem. It has to perform the casting and + 1, and *100 on every single record in the sas_output table. The dimdate table...

And after 6 hours and 18 columnstore indexes created, top 5 waits are:

wait_type  waiting_tasks_count  wait_time_ms

PAGEIOLATCH_SH    1641491    266954
RESERVED_MEMORY_ALLOCATION_EXT    3814428    259338
SOS_SCHEDULER_YIELD    3650643    191846
MEMORY_ALLOCATION_EXT    65909154    62201
IO_COMPLETION    45868    2028

Not cramped for space, got 500GB free still. I'm running the create columnstore index command again now, and ran the query below to look at waits

select * from...

Think I found the answer, found the links below that describe the need to increase the ms-DS-MachineAccountQuota attribute from its default of 10. I think the original error message...

Thanks everyone! Sticking with Windows. Didn't know about the linux HA issue, and that it's engine only for now (we'll need SSIS).

Another detail, this'll be two servers in an Availability Group actually.

That would work. We'd have to change each application to query that table to get connections strings though. Guess I was hoping for an easier way.

I read...

Good to know, thanks!

Is the below true? If so, that would support the 2nd config.

"data and tempdb should share LUNs because the IO pattern is a sequence of: read from data, then write...

Awesome, the statement below worked, thanks HowardW!

select

((select count(*) from table1) /

(select count(*) from table1))

from dual;