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...
Hi Friends, Here's something interesting about Management Studio 2005 (SSMS) When you launch SQL Server Management Studio 2005 on the server, it takes a couple of minutes (more than 5 mins in some case) before it starts up and another few minutes to connect.
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...
