With all the cheerleading and the steady drumbeat of new features being released to Azure, it’s easy to lose track of the many cool and valuable new features released in the on-premises version of SQL ...

The quality of that query plan is wholly dependent on the quality of the cardinality estimates (i.e., an estimate of the number of rows of data involved in an operation), the order of the operations, ...