Potentially leading to less efficient implementations or missed opportunities for optimization. In this blog post, we’ll explore three such Overutilized features.
SQL SERVER – Convert Cursor to Set Based Insert
In this blog post, we will focus on the issue of cursor-based inserts and demonstrate how to convert them into set based operations.
SQL SERVER – Replacing a Cursor with a Common Table Expression
Let us learn today – How I was able to improve the query performance by replacing the cursor with a common table expression (CTE).
SQL SERVER Heaps: Understanding Their Benefits and Limitations
In this article, we will delve into the use cases for SQL Server heaps, scenarios where caution should be exercised, and effective management techniques.
11 Essential Tips for Avoiding Common SQL Server Performance Tuning Mistakes
This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.
SQL SERVER – SET NOCOUNT – Impact on Stored Procedure Performance
Recently, I solved a huge performance problem for one of my clients by just adding the SET NOCOUNT inside the stored procedure.
SQL SERVER – Script to Kill All Inactive Sessions – Kill Sleeping Sessions from sp_who2
A third party app kept connections open and hurt a client’s performance. While they waited for a patch, we used this script to kill all inactive, sleeping sessions.