Quote:

If I was a compiler-with-ability-to-create-indexes-as-I-need-it – what would I do to make The Ideal Execution Plan™ for this request?

Another Quote:

When we have that ideal-execution-plan – we still need to convince our SQL compiler to use it

Quote:

to realize how our queries are working – we need to start thinking in terms of so-called “execution plans”.

Another Quote:

it can be faster to use Table Scan rather than Index-Scan+fetch over such a low-selectivity index

Quote:

You DO need access control for your CSRs.

Another Quote:

This approach means that we can have our cake (have tree-like structures to express access rights) and eat it too (have very fast SQL for checking access)

Quote:

for MOGs, support becomes one of the very important parts of the picture, often on par with Content and Graphics.

Another Quote:

the quality of support when using synchronous support methods such as live chat/phone support tends to be significantly worse compared to asynchronous support such as e-mails/tickets