Index usage by %Like% operator – Query Tuning

Ok, so this one is interesting. I was reading an Internal DL (Distribution Group) post on tuning %Like% operator performance. I find some confusion in various places about index selectivity of ‘%Like%’ operator, and I decided to do few test myself. Hopefully test details below can help a bit: Problem Statement: – While optimizing high…

2

Lock Pages in Memory in SQL Server 64-Bit

Hello All, Well after a long time of no writing, I finally found an interesting topic and also some time to write.   Lately, I’ve encountered couple of instances of Troubleshooting Memory Pressure on SQL Server 2005 64-Bit version. Doing some basic configuration check, one realizes that ‘Lock Pages in Memory’ Operating System Privilege is…

6