cardinality-estimates Archives

How does the optimizer treat yet-unpopulated #temp tables when estimating cardinality?

By adminPosted on September 9, 2022

Question : I’ve been building stored procedures and can’t find any documentation on how the SQL Server optimizer handles #temp […]

By adminPosted on August 2, 2022

Question : When joining a master table to a detail table, how can I encourage SQL Server 2014 to use […]

By adminPosted on June 24, 2022

Question : I’m struggling with the tuning of one of the queries on our production SQL Server 2016 SP2. I […]

By adminPosted on June 6, 2022

Question : I am using SQL server 2014, but my database version is SQL server 2012. So I am trying […]

By adminPosted on June 5, 2022

Question : I have a query that runs in 800 milliseconds in SQL Server 2012 and takes about 170 seconds […]

By adminPosted on April 12, 2022

Question : I have a (anonymised) query plan There is a table (Object8) which has a high variation on the […]

By adminPosted on March 15, 2022

Question : I noticed this while doing some performance testing recently. When I insert a value into a column that […]

By adminPosted on March 12, 2022

Question : Context I have stumbled on an issue in SQL Azure where the Sort-operator is spilling over into TempDB […]

By adminPosted on February 17, 2022

Question : Trying to understand Couple of things in the above query plan. Why is there a Stream Aggregate in […]

By adminPosted on February 1, 2022

Question : On a server with 32GB we are running SQL Server 2014 SP2 with a max memory of 25GB […]