SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
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.
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.
SQL SERVER – Choose Right Edition of SQL Server Express for Your Application
SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition
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.