I believe TF 8757 disables the trivial plan, for your experimentations. Paul White has an excellent Optimizer Deep Dive blog series, worth the read.

Paul White: Page Free Space

Best of...

Glad to hear they work for you. Nice! Also, you may wish to be careful with your autogrowth settings to avoid unnecessary VLFs being created. You'll generally...

Well... using your query, you just had a couple of syntax errors.

IF OBJECT_ID('tempdb..#HoldforEachDB') is not null BEGIN DROP TABLE #HoldforEachDB END

CREATE TABLE #HoldforEachDB

(

[Server] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[DatabaseName] [nvarchar](1000)...