I think something like this will do.  And you can change the "INNER JOIN" to "LEFT OUTER JOIN" if you want to show all times ranges for every Q and...

SELECT Convert(datetime, Left(dr_value, 10), 101) as Converted_Date from dr_tracking ;

Focus first on logical I/Os, as that's usually the culprit one way or another.

If you can run the code at will, then add this statement at the start of the...

What is the data of "yourcolumn" (the original column)?

If it's already datetime, and you just want to strip the time off, then do this instead:

DATEADD(DAY, DATEDIFF(DAY, 0, yourcolumn), 0)

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, 11 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...