Performance

SQL Performance Tuning tips for newbies

April 15, 2024 by Esat Erkec

The purpose of this article is to give newbies some basic advice about SQL performance tuning that helps to improve their query tuning skills in SQL Server.

An overview of SQL Server monitoring tools

December 12, 2023 by Hadi Fadlallah

This article explains some of the popular SQL Server monitoring tools and techniques.

How to obtain SQL Execution Plans using different methods

June 30, 2022 by Esat Erkec

In this article, we will learn various methods of how to get an SQL execution plan of a query.

How to overcome parameter sniffing problems in ad-hoc queries

June 17, 2022 by Esat Erkec

The purpose of this article is to provide insights into how parameter sniffing occurs for an ad-hoc query and how it affects their performance.

Unrevealed tips of SQL Server Statistics

June 13, 2022 by Esat Erkec

In this article, we will explore some internal working principles of SQL Server statistics.

SQL Server statistics from a different perspective

June 10, 2022 by Esat Erkec

The goal of this article is to throw light on the less-known points about SQL Server statistics.

Microsoft SQL Server Trace Flags and usage details

April 13, 2022 by Esat Erkec

In this article, we will explore Microsoft SQL Server trace flags with all aspects, and we will learn also how to use them.

5 reasons to consider on your Query Performance degradation

April 7, 2022 by Esat Erkec

This article gives fundamental insights into which 5 reasons can cause to drop off the query performances in SQL Server.

SQL Server Dedicated Administrator Connections for Azure SQL Database

March 29, 2022 by Rajendra Gupta

This article explains SQL Server Dedicated Administrator Connections and how you can use it for Azure SQL Database.

SQL Server Database Parameterization option and its Query Performance effects

February 18, 2022 by Esat Erkec

The goal of this article is to give details about the database query parameterization feature and explain its effects on query performance.

SQL Server Trivial Execution Plans

February 3, 2022 by Esat Erkec

In this article, we will go through the details of the trivial execution plans and we will also tackle some examples about the trivial plans to explore effects on query performance.

Behind the scenes of the SQL Delete Statement

January 31, 2022 by Esat Erkec

In this article, we will explore the details of what happens behind the scenes when a SQL delete statement is executed.

Monitoring SQL Server TempDB with Dynamic Management Views

December 29, 2021 by Esat Erkec

In this article, we will learn how we can detect which operations cause to fill up SQL Server tempdb through the dynamic management views.

SQL Update statement Performance Tips

December 7, 2021 by Esat Erkec

The SQL update statement is used to modify an existing record or records in a table and it is commonly widely used in databases applications. In this article, we will examine the update statement in terms of the performance perspective.

SQL Server Trace Flags and how they impact the SQL Server Query Optimizer behavior

December 2, 2021 by Esat Erkec

In this article, we will learn some query hints and trace flags that impact the query performance and also influence the SQL Server query optimizer’s default execution plan generation algorithm.

Hybrid Buffer Pool in SQL Server 2019

November 23, 2021 by Rajendra Gupta

This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019.

SQL Server Extended Events tips

November 17, 2021 by Esat Erkec

This article aims to provide some beneficial tips about SQL Server extended events that make it easier to create and use event sessions.

Transfer Stored Procedures between master databases on SQL Server instances using SSDT 2017

November 9, 2021 by Nisarg Upadhyay

This is the second article in the series of Migrating SQL Server Objects using SSDT 2017. In this article, we will learn how to copy user stored procedures created in the SQL Server master database.

SQL TOP statement performance tips

November 9, 2021 by Esat Erkec

In this article, we will discuss the performance details of the SQL TOP statement, and we will also work on a performance case study.

Using SQL Server Extended Events to monitor query performance

November 1, 2021 by Esat Erkec

In this article, we will explore how we can use SQL Server extended events to monitor query performance in SQL Server.

How to use SQL Check Constraints

October 15, 2021 by Esat Erkec

This article intends to give comprehensive information about the usage and other details of SQL check constraints.

Performance impact analysis of enabling Transparent Data Encryption (TDE) on SQL Server

October 14, 2021 by Manvendra Singh

Transparent Data Encryption (TDE) encrypts database files to secure your data. It also encrypts the tempdb database to secure your data in a temporary space. The process of encryption and decryption adds additional overhead to the database system. Even non-encrypted databases hosted on the same SQL Server instance would have some performance degradation because of tempdb encryption. Today I will show you performance impact analysis using few simple T-SQL statements by comparing their stats gathered before and after enabling TDE.