Question : I am looking at implicit conversions in my stored procedures and the biggest one I have in my […]
Tag: cardinality-estimates
Slow query – big difference between estimated and actual rows
Question : At my work, we have a problem with a search query. If I don’t include the lookup into […]
Query with Variable not estimating right
Question : I have a query with several joins that is not performing well. After a lot of triage, I […]
Query slower after upgrade from sql server 2008R2 to 2014sp2
Question : I recently upgraded from SQL Server 2008R2 to 2014SP2 and upgraded the databases to the compatiblity level 120. […]
Inserting with implicit type conversion causes warning for cardinality estimates
Question : I noticed this while doing some performance testing recently. When I insert a value into a column that […]
No IMPLICIT_CONVERSION warning in this query plan
Question : Take the following minimally complete and verifiable example1 code: USE tempdb; DROP TABLE IF EXISTS dbo.t; GO CREATE […]
Estimated vs. Actual Row counts in a trivial case
Question : I’m working on optimizing some queries in a database I’ve inherited. I’m not permitted to disclose the query, […]
Bad estimations in execution plan [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
How to improve row estimate of 1 row in join for newly inserted data
Question : A custom statistic exists for the CacheId column of a table. After an overnight statistics update: Statistics for […]
Estimated vs. Actual Row counts in a trivial case
Question : I’m working on optimizing some queries in a database I’ve inherited. I’m not permitted to disclose the query, […]