Good question. I have used Alt-Ctrl-Shift to select a block in SQL for years but this is much better. Yes using just Alt works in SQL Server just need to...

I think the question could be ambiguous as I took it that you only wanted the backup to occur on the Secondary hence I choose Secondary_Only.

"I want to set the...

I tried this against a SQL Server 2008 R2 database and both 1 and 5 brought back the bracketed records. Luckily I choose answer 1.

No it's a good bit of code which I have used for our lottery syndicate at work.

Thanks for providing it.

Shouldn't the code be:

SELECT TOP 5

SV.number AS Number

INTO #numbers

FROM master.dbo.spt_values SV

WHERE SV.type = 'P'

AND SV.number BETWEEN 1 AND @RegularRangeEnd

ORDER BY NEWID();

And

SELECT TOP 1

SV.number AS MegaNumber

INTO #mega_number

FROM master.dbo.spt_values SV

WHERE SV.type =...

I think the variables should be used in the script in place of 75 and 15.

As I haven't used In Memory tables yet I did a search on this I found the following:

https://blogs.technet.microsoft.com/dataplatforminsider/2016/01/06/json-in-sql-server-2016-part-2-of-4/

Which implies that ISJSON is available in SQL Server 2016 for...

Yep some more context please.

I went for NEWID as the others are available in AZURE but NEWID isn't.

Ok so don't use windows calculator to try to calculate this. I can now see my mistake.

Good question, poor calculator skills.

I make 92m. Bigint 2^63-1 (9,223,372,036,854,775,807) / 100,000,000 = 92,233,720.36854775.

How do we get 92billion? Am I missing something?