Carlo, you are right!

use tempdb
go

CREATE TABLE NewTable (record BIT);
GO

DECLARE @tsql nvarchar(max);

Set @tsql = N'SELECT SUM(CAST(record AS INT)) from NewTable';
SELECT * FROM sys.dm_exec_describe_first_result_set(@tsql, null, 0);

Set @tsql = N'SELECT...

The answer should be: I get the two statements concatenated together, not the strings are concatenated, because there is no execution!

Same for me!

Just try to insert a

Set implicit_transactions off;

just after the Rollback;

Nice question, but you should end the statement with a semicolon, so that the next statement will work if it contains a cte, too!

I've chosen "Add a WHERE clause to your CREATE STATISTICS DDL", but all options are wrong. But the explanation is "You can use a WHERE clause with expression(s) just as...

But this is not true for Basic Availability Groups, isn't it?

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-2016
An Always On basic availability group can be created on any two SQL Server 2016 Standard...

Setting the database offline as the first step and bringing it back online at the end would be a good idea!

Hi Steve,
in your solution the Group by is missing.

GROUP