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.
Read More...
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
Read More...
