• An Index Reduces Performance of SELECT Queries (Video)
  • 3 Common Mistakes to Kill SQL Server Performance (Video)
  • SQL Server Performance Tuning Made Easy – In-Person (Video)
  • SQL Server Performance Tuning Made Easy – Online (Video)
  • 3 Performance Tuning Tricks you Always Wanted to Know (Video)
  • Secrets of SQL Server-Database Worst Practices (Video)
  • Kick Start! SQL Server 2017/2019 Performance Tips and Trick (Video)
SQL SERVER - 2005 - Performance Dashboard Reports elearning

Instant Learning ~
SQL Server Performance Tuning Practical Workshop for EVERYONE

Learn Now
Free Learning Videos
  • An Index Reduces Performance of SELECT Queries (Video)
  • 3 Common Mistakes to Kill SQL Server Performance (Video)
  • SQL Server Performance Tuning Made Easy – In-Person (Video)
  • SQL Server Performance Tuning Made Easy – Online (Video)
  • 3 Performance Tuning Tricks you Always Wanted to Know (Video)
  • Secrets of SQL Server-Database Worst Practices (Video)
  • Kick Start! SQL Server 2017/2019 Performance Tips and Trick (Video)
Upcoming Events
SQL SERVER - 2005 - Performance Dashboard Reports elearning

Instant Learning ~
SQL Server Performance Tuning Practical Workshop for EVERYONE

SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX

We can use either CHARINDEX or PATINDEX to search in TEXT field in SQL SERVER. The CHARINDEX and PATINDEX functions return the starting position of a pattern you specify. Both functions take two arguments. With PATINDEX, you must include percent signs before and after the pattern, unless you are looking…
Read More
Menu