This procedure will get all the objects performing committed reads. It will fetch all the objects (Procedures, Functions, Triggers, View etc.) that doesn't uses the NOLOCK and SET ISOLATION LEVEL READ UNCOMMITTED. It may be helpful in performance tuning assignments and to resolve / minimize the frequent blockage and deadlock issues.
Tag: Performance Tuning
usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
This procedure will get all the stored procedures and triggers missing the use of SET NOCOUNT ON. It may be helpful in performance tuning assignments.
Probing Columnstore Indexes
This article was first published on: 2020-03-14. This article will probe the performance benefits of columnstore indexes, on a transactional (OLTP) workload for real-time analytics. We'll cover examples from each of the followings - Pivot, Aggregate Functions, Analytic Functions, Ranking Functions and Window Functions.
Clustered Index Key – Natural or Surrogate?
This article will follow a practical approach to choose the right candidate for clustered index. It'll investigate through the best practices recommended for clustered index, with the help of an experiment.
Performance Tuning with Computed Columns
Computed Column can be utilized to optimize the query performance. It can be leveraged, to make the query sargeable, to make proper use of available indexes. In this article, we'll perform a test to see, how computed columns can help in performance tuning.
SQL Server Carpenter 