Varun Dhawan's Blog

Hands-on with SQL Server
Welcome to MSDN Blogs Sign in | Join | Help

News

Browse by Tags

All Tags » Performance   (RSS)
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. Read More...
How To: Improve SQL Server Management Studio Start-up Time
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...
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 Read More...

Page view tracker