Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: cardinality-estimates

Datetime to formatted Date Implicit Conversion

By adminPosted on September 27, 2023

Question : I am looking at implicit conversions in my stored procedures and the biggest one I have in my […]

Slow query – big difference between estimated and actual rows

By adminPosted on September 26, 2023

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

By adminPosted on August 15, 2023

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

By adminPosted on August 4, 2023

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

By adminPosted on July 29, 2023June 24, 2022

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

By adminPosted on July 19, 2023

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

By adminPosted on June 23, 2023

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]

By adminPosted on June 10, 2023

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

By adminPosted on March 9, 2023

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

By adminPosted on February 1, 2023

Question : I’m working on optimizing some queries in a database I’ve inherited. I’m not permitted to disclose the query, […]

  • 1
  • 2
  • 3
  • …
  • 8

Recent Posts

  • connect SQL server file (mdf) with R tool [closed]
  • Database running out of space
  • Postgres backup PITR strategies [closed]
  • Installing SQL Server 2014 Enterprise in Windows 7 Ultimate 64 Bit Incompatibility Error
  • CPU Time Slower in SQL Server 2014 than in SQL Server 2008 R2 [closed]
  • Postgres doesn’t use expression index for group by
  • Suggestions for type of DB to use (Elasticsearch vs MongoDB vs Hadoop)
  • Creating Indexes to optimize query
  • Does joining to the same table twice have a predictable performance impact
  • Can we prevent table from update directly but allow update using trigger from another table?
  • Querying ‘random’ Oracle data via openquery in SQL Server returning the same data for multiple runs
  • The implications of lack on indexes on supporting a large production database
  • How to limit work_mem on PostgreSQL
  • Select max(pk) instead of sequence.nextval
  • Query detailing differences between rows for a large amount of data
  • How to combine `delete` and `insert` operations in one statement?
  • Slow SQL Server database on a specific server [duplicate]
  • How to model the relationship between these three tables
  • Error when migrating MySQL 8 to SQL Server 2019
  • multiple MYSQL full text indexing for innodb and memory + disk efficiency

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding