The correct cardinality estimation using table variable
Hi Friends, In my previous blog post, we have seen that SQL Sever estimates number of rows in a table variable was 1. Now the question is, Is there any way …
Read MoreTag: OPTIMIZATION
SQL Server – Did you know about Trace Flag 4136 ?
Hi Friends, Parameter Sniffing, in general, is a good thing and your queries can benefit from that. Here are some of my blogs posts that you can read to get some …
Read MoreWhat is TRIVIAL PLAN in SQL Server?
Hi Friends, SQL Server’s Query Optimizer is one of the most complex components in the DB engine. The job of the optimizer is to produce the cheapest execution plan for a …
Read More