You should still never shrink a database (at the db level), only specific db files (at the file/file_id level).

One must also consider the enormous difficulty of what the MS folks are trying to do.

I get asked all the time about "(simple) rules for tuning indexes" since that is...

Or this instead?:

;WITH src
AS (SELECT s.PK
          ,MAX(CASE WHEN s.ColName = 'Col1' THEN s.Value END) AS Col1Value
  ...

I AM NOT A SQL LICENSING EXPERT.

But as I understand the licensing, if you do ANY production work AT ALL on the instance, then you cannot use Developer Edition for...

I'd use REVERSE because it's considerably less overhead.

SELECT BANAME, RIGHT(BANAME, CHARINDEX(' ', REVERSE(BANAME)) - 1) AS BANAME_VALUE
FROM #sample

Personally I think I'd rather see the days as columns in the same row, i.e. a column for Monday, a column for Tuesday, etc.., with one per month and one...

Thanks for the test data!  Sorry if I seemed difficult, but I help on up to dozens qs a day, and I just don't have to do data prep for...

By default, I think Oracle timestamp only has 6 digit precision for sub-seconds (FULL DISCLOSURE: I haven't been an Oracle DBA since Oracle 8).  Try cutting the sub-seconds from 7...

Hmm, decent start, but I can't query against it.

I need an actual INSERT statement, that works, like this:

CREATE TABLE #data ( customer int NOT NULL, myDateTime datetime NULL );

INSERT INTO...

Phil - Correct.  Devs want it all in dev.

Ken - AWESOME  "INSTEAD OF"  Why didn't I think of that.  Is a trigger to delete  ##  history table records...

Phil - Correct.  Devs want it all in dev.

Ken - AWESOME  "INSTEAD OF"  Why didn't I think of that.  Is a trigger to delete  ##  history table records WHEN...

That's from the ROLLUP.

The one with NULL, NULL is the global dayname total, so all Mondays, Tuesdays, etc., regardless of year, month.

The one with NULL, YEAR is supposed to be...

Well, you fixed it, but glad I helped in some way :-).

Is your msdb data or log file full?

Do you see any errors in the SQL error log that could be related to the issue?

Agree with Ken.  Use a trigger to only write the data you want in the table to begin with.

The only thing Ken left out was a:

SET NOCOUNT ON

at the start...