We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles.
SQL SERVER – Difference Between Update Lock and Exclusive Lock
I have often got this question on this blog as well in different SQL Training. What is the difference between Update Lock and Exclusive Lock? When Exclusive Lock is on any processes no other lock can be placed on that row or table. Every other process have to wait till…
Read More
SQL SERVER – Find Statistics Update Date – Update Statistics
Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). It is quite common to listen people talking about not optimal plan and expired statistics. Quite often I have heard the suggestion to…
Read More
SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit
During the SQL Server Optimization training, I enjoy teaching the Execution Plan. I am always sure that questions related to the estimated cost will be raised by attendees. Following are some common questions related to costs:
SQL SERVER – Initializing a Merge Subscription Without a Snapshot
During recent course of Disaster Recovery and Performance Tuning, I had very interesting conversation with students regarding Initializing a Merge Subscription Without a Snapshot and Initializing a Transactional Subscription Without a Snapshot. After the discussion when we were looking at MSDN pages one thing caught my notice was the note…
Read MoreSQL SERVER – Find Busiest Database
In my recent training I was asked to how to find which is the busiest database in any SQL Server Instance. What he really meant by this is which database was doing lots of read and write operation. To find the answer to this question I decided to look into…
Read MoreSQL SERVER – Fragmentation – Detect Fragmentation and Eliminate Fragmentation
Q. What is Fragmentation? How to detect fragmentation and how to eliminate it? A. Storing data non-contiguously on disk is known as fragmentation. Before learning to eliminate fragmentation, you should have a clear understanding of the types of fragmentation. We can classify fragmentation into two types: Internal Fragmentation: When records…
Read More