Also...

so maybe I need to rethink how I have structured my tables. I don't have a binary win_loss in the game data which you will see. I put...

This might give you some helpful ideas.  It also contains minimum sample data to show you how data can be posted.   I used a Season table to determine the Season...

If you're willing to get rid of the PIVOT in favor of a cross-tab approach (which IMHO is preferable anyway), then try this:

SELECT
    [Type],...

Getting carried away with the semicolons, and attempting to use two WITHs for one SELECT:

:WITH cte AS (
    SELECT [cntSRVLDAPLOADAVERAGE]
    FROM...

• This reply was modified 3 years, 3 months ago by ScottPletcher.

ignore, duplicate post

Apologies on the mistake about COMPRESS.

I know you think that 2016 is magic after the first insert.  The documentation says that new pages will be minimally logged. ...

Apologies on the mistake about COMPRESS.

I know you think that 2016 is magic after the first insert.  The documentation says that new pages will be minimally logged.  I'll...

Apologies on the mistake about COMPRESS.

I know you think that 2016 is magic after the first insert.  The documentation says that new pages will be minimally logged.  I'll have...

Using a loop to break things up into sections will cause the every section except the first to be FULLY LOGGED, which takes as much as 3 times longer...

Ooh, I accidentally left off one critical pre-step:

(0) Pre-allocate enough log space to handle the INSERTs.  How much total log space you'll need depends on whether minimal logging is available...

If none of your tables have indexes, you should start there, and fast!

First, review the missing index stats to see which column(s) should be used in the clustered index.  That...

You could also consider using a brand new filegroup, with at least two files, for the new/replacement table, which will reduce any interference with other filegroups.  Then again, you're stuck...

Not that I know of.

You could increase the log size to match the size it was originally if you wanted to.  That may take some time as log space must...

I'll assume that when you refer to "primary index" on the original table you mean "clustering index".  That is critical for copying the data (whereas a (nonclustered) primary key is...