Option (maxrecursion 0) SQL Server

Question

where is the bad idea to use this. Although there is a basic register and instruction that ultimately completes the recursion.

option (maxrecursion 0) 

Answer 1

You use it when you need to use it.

The important thing is that your recursion will end in the end ...

For example, this , which I found on the Internet (creates a date table), indicates that we are using MAXRECURSION