Is there a way how to 'inject' a cardinality estimation to a SQL Server optimizer (any version)?
i.e. something similar to Oracle's cardinality hint.
My motivation is driven by the article ', How Good Are Query Optimizers, Really?', where they test the influence of the cardinality estimator on a selection of a bad plan. Therefore, it would be sufficient if I could force the SQL Server to 'estimate' the cardinalities precisely for complex queries.
 Leis, Viktor, et al. "How good are query optimizers, really?"How good are query optimizers, really?".
Proceedings of the VLDB Endowment 9.3 (2015): 204-215.