You can't include any columns in a clustered index (by definition it automatically includes all columns in the table anyway).

Just use the key column(s) you need.  It's OK, and often...

The DBA's right about the concurrency issue.  Also, you should really only create a clustered index on a temp table and it should be created before the table...

The DBA's right about the concurrency issue.  Also, you should really only create a clustered index on a temp table and it should be created before the table is loaded.

You...

You can reference a temp table in dynamic SQL.  Could you create a temp table and load it instead?

SELECT j.name AS running_job_name, 
    DATEDIFF(MINUTE, ja.start_execution_date, GETDATE()) AS duration_mins,
    ja.* 
FROM msdb.dbo.sysjobactivity ja
INNER JOIN msdb.dbo.sysjobs j ON j.job_id = ja.job_id
WHERE...

> Two synchronous replica in one region <<

The prod server must wait for the replicas to be in sync.  That could also be adding to delay in prod.

Typically you create only the clustered index prior to load, and any non-clustered indexes after the load.  That's generally the best-performing approach, although theoretically it could be different for a...

It's 16 Gb. My laptop from 10-11 years ago had double that amount of ram. My phone from 2010ish with its 480x800 resolution screen had that amount...

It's 16 Gb. My laptop from 10-11 years ago had double that amount of ram. My phone from 2010ish with its 480x800 resolution screen had that amount...

It's 16 Gb. My laptop from 10-11 years ago had double that amount of ram. My phone from 2010ish with its 480x800 resolution screen had that amount of storage.

Maybe...

A PK is not necessarily an irrelevant cost.  If I have 2B rows, for example, the "free" PK costs me at least 16GB of row and storage space.

Some tables simply...

SELECT 
    SUM(CASE WHEN t.create_date BETWEEN @v_from_date AND @v_to_date THEN t.max_column_id_used ELSE 0 END) AS tables_created,
    SUM(CASE WHEN t.modify_date BETWEEN @v_from_date...

In certain cases or usage situations, SQL Server will require a primary key.  One reason is that a primary key is guaranteed to be unique and non-NULL (that is, by...

Can you explain further why you want to allow this user to enable/disable system versioning?  As far as I am aware - the only reasons to temporarily disable versioning...

No.  Performance-wise they are exactly the same.