The answer to performance question like this one is often "it depends". For one thing "name contains 'ram'" is not legal SQL syntax, so it depends on what you mean....

I don't really know what PageMemorySize might be; I don't see it in my Task Manager. Which OS and bitness are you on? What exactly does "SELECT @@version" report?

But as...

So type the correct name. Don't forget the instance name, if it is a named instance.

You say that you are on a different network, so the server you are trying...

Doesn't the dropdown permit you to type a name?

I'm sorry, I don't know where in Excel this dropdown may be hiding, so I can't test myself.

In all seriousness, how do you expect us to be able to say whether this is OK or not without no knowledge about your system or what the impact would...

It would also be interesting to see what they were doing in the rest of the query for that particular use of a Numbers table.

Actually, I had to rewrite the...

Here is another example based on what I found to day:

SELECT char(n) FROM numbers WHERE n BETWEEN acsii('A') AND ascii('Z')

In the actual example I found when from...

I dug around in the system I work with daily and I found:

 join numbers n on n.n between p.startYM/100 and p.endYM/100

The values where would be something...

Sorry about the incorrect section reference. The time-based tables are in chapter 4.

I guess that in many cases where we are using sequence, we want a sequence, and what number...

Typically, I have table with the sequences I need, at least if I need them in more than one place in the database.

I discuss time-based tables in my article here:...

how often have you needed to generate a sequence that started with something other than "1" or "0"?

I guess about every time when I wanted a sequence of something time-based:...

SSMS does not seem to have any specific category for variables. I don't know if a third-party product like Red Gate's SQL Prompt may offer this.

No, and your question is based on a fundamental misconception about numbers in computers. You are confusing what is stored with how it is presented.

Numbers in a computers are stored...

The easiest way is to upgrade to SQL 2019 and put the database in compatibility mode 150. I would expect in that case that the function will be inlined which...

If this is an interview assignment? A bit hefty in that case. Or is a class assignment, like the final one?

In any case, it sounds like you something you are...