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

Tag: plan-cache

Why is parallelism not good in this query?

By adminPosted on September 13, 2023

Question : I was looking for missing indexes in the cached execution plans then I found a very nice article […]

Execution Plan Warnings cardinality xml data type

By adminPosted on July 10, 2023

Question : I have the following statements: — 1st DECLARE @AuditParameters XML = ( SELECT 1 AS AccountID, 2 AS […]

Is execution plan cached “better” for stored procedures than for a non-dynamic query?

By adminPosted on June 28, 2023

Question : Reading different explanations about execution plan caching by Microsoft SQL Server, I’m confused about the benefits of using […]

Execution Plan Warnings cardinality xml data type

By adminPosted on June 27, 2023

Question : I have the following statements: — 1st DECLARE @AuditParameters XML = ( SELECT 1 AS AccountID, 2 AS […]

What happens when a stored procedure executes one of two different queries based on an input parameter?

By adminPosted on June 10, 2023

Question : I have encountered a stored procedure that performs one of two different queries based on an input parameter. […]

Why does changing parameterization style result in lower plans in the plan cache when using sp_executesql?

By adminPosted on April 24, 2023

Question : Generally sp_execute sql will re-use cached plan, where as EXEC will create new plan for each parameter. In […]

How to see if index is being read “ordered” from DMVs

By adminPosted on April 2, 2023

Question : I have a table that is being used in many reporting queries. I would like to know how […]

Why query cache plan kept dynamic queries but not sp?

By adminPosted on March 27, 2023

Question : My company has some legacy system that uses quite a lot of dynamic queries (no parameters). In the […]

Need to maintain execution plans on SQL Server Upgrade 2017 to 2019

By adminPosted on March 11, 2023

Question : We are working on a performance issue and need to maintain the execution plans for troubleshooting. Need to […]

Parameter Sniffing – Running query in code vs in management studio

By adminPosted on March 2, 2023

Question : I just had a problem at work where a stored proc, being called by some C# code, was […]

  • 1
  • 2
  • 3
  • …
  • 7

Recent Posts

  • How to model an activity feed
  • trigram matching on a jsonb array
  • Trigger to prevent update when Flag value is 1
  • SQL, SQLCLR objects & effective memory utilization
  • Queries on Mongo Secondary are not equally distributed
  • Timezone offset displayed though it shouldn’t be stored
  • Use composite type to create new table
  • what is ‘#’ in create table statement?
  • how to avoid duplicated column in two different tables?
  • RMAN – Archivelog deletion policy ignored
  • Query runs quicker when column calculation is done after initial query
  • Generating Error when data size is larger then max text repl size
  • mysql: Is mysqladmin -p create equivalent to create database?
  • Recovering from removal of ibdata1 [duplicate]
  • Reviewing all code on a SQL Server Instance
  • Select query on 8 million records with greater and less than columns (Slow)
  • Database Performance Tuning
  • how to script out database users and permissions in all user databases in the instance [closed]
  • Is it possible to have a shared secondary Mongo DB instance between two replica sets..?
  • Does creating a unique constraint on a Postgres column remove the need to index it?

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