SQL Server Education (by the geeks, for the geeks)
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 …
The correct cardinality estimation using table variable Read MoreHi 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 …
SQL Server – Did you know about Trace Flag 4136 ? Read MoreHi 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 …
What is TRIVIAL PLAN in SQL Server? Read More