Tips for improving performance of wildcard search SQL

https://social.technet.microsoft.com/wiki/contents/articles/31238.t-sql-improve-the-performance-for-like-wildcard-by-changing-the-collation.aspx

http://www.sqlservercentral.com/blogs/dwainsql/2014/03/26/getting-an-index-seek-to-speed-up-like-string-searches/
https://sqlperformance.com/2017/02/sql-indexes/seek-leading-wildcard-sql-server

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s