Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)
If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...
2024-11-29 (first published: 2014-04-07)
50,238 reads
SQL LIKE SEARCH
Blogs
Focus on Core Skills
By Brian Kelley
Core skills depends on the position, but the point is that ensuring you have...
A New Word: Zverism
By Steve Jones
zverism – n. the wish that people could suspend their civility and indulge in...
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
Forums
Move Files SSIS Task
Hi I have a task in my SSIS package that moves files from source...
Migrating mission critical database from SQL on Prem to Azure SQL
We are migrating our environments to Azure, it will be a mix of SQL...
The Inefficiencies of Kubernetes
Comments posted to this topic are about the item The Inefficiencies of Kubernetes
Question of the Day
The Backup Space Needed
How do I calculate the amount of space needed for I/O buffers during a backup operation?
See possible answers