A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2
This blog post is part 2 of the earlier written article SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best by Paulo R. Pereira. Paulo has left excellent comment to earlier article once again proving the point that SQL Server Engine is smart…
Read MoreSQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best
This is followup post of my earlier article SQL SERVER – Convert IN to EXISTS – Performance Talk, after reading all the comments I have received I felt that I could write more on the same subject to clear few things out. First let us run following four queries, all…
Read More
SQL SERVER – Convert IN to EXISTS – Performance Talk
In recent training one of the attendee asked if I can show a simple method to convert IN clause to EXISTS clause so it impacts performance. Here is the simple example.
SQL SERVER – Disabled Index and Update Statistics
When we try to update the statistics, it throws an error as if the clustered index is disabled. Now let us enable the clustered index only and attempt to update the statistics of the table right after that. Let us learn about Disabled Index and Update Statistics.
SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions
To learn any technology and move to a more advanced level, it is very important to understand the fundamentals of the subject first. Today, we will be talking about something which has been quite introduced a long time ago but not properly explored when it comes to the isolation level.…
Read More
SQL SERVER – Find Most Expensive Queries Using DMV
The title of this post is what I can express here for this quick blog post. I was asked in recent query tuning consultation project, if I can share my script which I use to figure out which is the most expensive queries are running on SQL Server. This script is very basic and very simple, there are many different versions are available online. This basic script does do the job which I expect to do – find out the most expensive queries in SQL Server Box.