Isolation Levels Overview

What a better time to talk about isolation than now… SQL Server implements six distinct isolation levels that are fundamentally distinguished by the way they approach potential problems caused by concurrency. Each isolation level maintains a specific balance between integrity and performance, that is materialized by the occurrence, or not, of certain concurrency phenomena. Dirty … Continue reading Isolation Levels Overview

Performance Woes & Wows #3 Full-Text Search

In the previous post of Performance Woes & Wows, we’ve discussed the reason why using a LIKE predicate along with a leading wildcard can really hurt the performance of our queries. Accordingly, we saw how the use of just a trailing % wildcard will produce much more efficient searches. Nevertheless, it’s likely that we can’t … Continue reading Performance Woes & Wows #3 Full-Text Search

Follow My Blog

Get new content delivered directly to your inbox.