Tag: Performance

All the articles with the tag "Performance".

• Deep Dive

  When a VARCHAR Isn't a VARCHAR

  9 Jul, 2026

  Implicit conversions in T-SQL are silent and legal, and they can turn an index seek into a full table scan without any obvious cause.

• Deep Dive

  NOLOCK Isn't Free

  14 May, 2026

  NOLOCK is one of the most misused hints in T-SQL. Here's what it actually does, what it risks, and when it might be worth it.