I am proud on readers of this blog. One of the reader asked asked question on article SQL SERVER – Delete Duplicate Records – Rows and another reader followed up with nice quick answer. Let us read them both together.
SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader’s Article
This article has been written by blog reader and SQL Server Expert Praveen Barath in response to my previous article SQL SERVER – Optimization Rules of Thumb – Best Practices. Well Query Optimizations rules are not limited. It depends on business needs as well, For example we always suggest to…
Read MoreSQL SERVER – Optimization Rules of Thumb – Best Practices
There are few rules for optimizing slow running query. Let us look at them one by one see how it can help. Rule # 1 : Always look at query plan first. I always start looking at query plan. There is always something which catches eyes. I pay special attention…
Read More
SQL SERVER – Converting Subqueries to Joins
There is always more than one way to do one thing in any programming languages. In SQL Server there is always more than one way to achieve same result set. It is quite often I see that developers write subqueries in place of joins or joins in place subqueries.
SQL SERVER – Join Better Performance – LEFT JOIN or NOT IN?
First of all answer this question : Which method of T-SQL is better for performance LEFT JOIN or NOT IN when writing a query? The answer is: It depends! It all depends on what kind of data is and what kind query it is etc. In that case just for fun guess one option LEFT JOIN or NOT IN. If you need to refer the query which demonstrates the mentioned clauses, review following two queries for Join Better Performance.
SQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks
Read my article published at SQL Server Magazine Surface Area Configuration Tools Reduce Exposure To Security Risks [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – 2005 – Mechanisms to Ensure Integrity and Consistency of Databases – Locking and Row Versioning
Today I was going through Book On Line while researching something, I come across one interesting small article about two mechanisms to ensure integrity and consistency of databases – 1) Locking 2) Row Versioning Let us see their definition from Book Online Itself. Locking Each transaction requests locks of different…
Read More