Skip to content

SQLGrease SQL Server Performance tips

Performance tuning tips from the SQLGrease team

  • Blog Home
  • About Me
  • Contact Me
  • SQL Grease Home Page

Unindexed Foreign Keys

Do you have locks being caused by unindexed foreign keys?

August 3, 2017August 2, 2018 ~ franklinyamamoto

When you define tables with foreign key constraints, SQL Server must check that the foreign key constraints will not be violated during DML operations.  If the foreign key columns are not indexed, there are two scenarios that will cause table locks to be placed on the foreign keyed table: During any delete operation During any […]

Read More

See how SQLGrease can help fix your deadlocks

 

Subscribe to our mailing list

* indicates required

Follow @sqlgrease

Recent Posts

  • Filtered indexes and the new parameter sniffing option (spoiler alert it doesn’t help)
  • Negative blocking session ids
  • Query store doesn’t work on read replicas
  • Improving performance of your RIGHT query
  • Improving performance of your LEFT query
  • Perform RTRIM and LTRIM in your code not in your queries
  • Performance of parameterized LIKE queries with new parameter sniffing option
  • Don’t use UPPER in WHERE unless you really need it
  • Estimate rows Vs Estimated rows to be read what’s the difference
  • Performance implications of using DATEDIFF function in WHERE
  • Performance implications of using ISNULL vs IS NULL
  • Connecting to a read only replica with SSMS
  • Index seeks on date and CONVERT
  • Fixing an implicit type conversion without a code change
  • Dealing With “Bad” Plans
  • Making Queries With Leading Wildcards Faster
  • Creating a database per customer VS single database for all customers (SQL Server)
  • What’s filling up tempdb?
  • Plan guides made easy
  • Tuning Substring Query Without Changing the Query
~