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

computed column

Tuning Substring Query Without Changing the Query

Image ~ March 24, 2020 ~ Eddy Djaja ~ Leave a comment

 Introduction The blog shows how to tune a query using substring in the WHERE clause. The tuning solution is to use indexing on a computed column. Performance Issue A General Ledger financial report execution in Financial system takes a long time finishing more than 4 hours. Performance Analysis The first step in the performance tuning […]

Read More

See how SQLGrease can help fix your deadlocks

 

What is SQLGrease?

Click Here To Find Out

Subscribe to our mailing list

* indicates required

Follow @sqlgrease

Recent Posts

  • 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
  • How to view query store id’s related to a sql/plan handle or query/plan hash.
  • How to change your default transaction isolation level in SSMS
  • Where did that execution plan come from?
  • Something you should know about query timeouts and sys.dm_exec_query_stats
  • How to remove a hint from a query without code changes
  • How to see what is in your buffer cache
  • Tempdb caching – What is it and how to take advantage of it
  • What happens with parameterized wildcards?
  • How SPLIT_STRING row estimates can affect performance
  • Index seeks and NULL values
  • Why do I have multiple plans for one query?
  • ASYNC_NETWORK_IO Wait, What is it? What causes it?
  • Join Hints – Careful, They Force Order!
  • How to view percent done for a long executing query
  • Indexes for dummies
  • Diagnosing: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time
~