SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 2

This article is follow up of my previous article SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup. Please do read my previous article before continuing further. I have described there two different methods to reduce query execution cost. Let us compare…
Read More

SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER

SQL Server never stops to amaze me. As regular readers of this blog already know that besides conducting corporate training, I work on large-scale projects on query optimizations and server tuning projects. In one of the recent projects, I have noticed that a Junior Database Developer used the query hint Force Order; when I asked for details, I found out that the basic concept was not properly understood by him.

Read More

SQLAuthority News – Community TechDays in Ahmedabad – A Successful Event – Oct 3, 2009

Community TechDays at Ahmedabad was a great successful event. In fact, this can be considered the biggest event held in Ahmedabad thus far along with community. This event was held by Microsoft and PASS (Professional Association of SQL Server). The goal of this event was to dive deep into the world of Microsoft technologies and get trained on the latest from Microsoft. Well, we could successfully achieve the same and build real connections with Microsoft experts and community members.

Read More

SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition

Database Encryption in SQL Server 2008 Enterprise Edition SQL Server Technical Article Writers: Sung Hsueh Technical Reviewers: Raul Garcia, Sameer Tejani, Chas Jeffries, Douglas MacIver, Byron Hynes, Ruslan Ovechkin, Laurentiu Cristofor, Rick Byham, Sethu Kalavakur Published: February 2008 TDE does not replace cell-level encryption, EFS, or BitLocker. This white paper…
Read More

SQLAuthority News – SQL Server 2008 – The Other Side of Index – Community Tech Days

Community Tech Days are here Tomorrow in Ahmedabad on Oct 3, 2009. I will be presenting the session ‘SQL Server 2008 – The Other Side of Index’. I will be available there whole day if you want to meet and discuss SQL. I will be starting my session with following cartoon. You will have to attend the session in person to see what I am going to cover in the session.

Read More