Esat Erkec

Author
Recent Posts

Esat Erkec is a SQL Server professional who began his career 8+ years ago as a Software Developer. He is a SQL Server Microsoft Certified Solutions Expert.

Most of his career has been focused on SQL Server Database Administration and Development. His current interests are in database administration and Business Intelligence. You can find him on LinkedIn.

View all posts by Esat Erkec

How to become a SQL Server Developer

May 20, 2022 by Esat Erkec

In this article, we will talk about what SQL Server developers do and which main skills are required to get a job as a SQL developer.

How to write readable T-SQL queries

May 18, 2022 by Esat Erkec

This article intends to give some beneficial suggestions that help to write a more readable T-SQL query.

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 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.

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.

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.

SQL Syntax Checker Tools

October 27, 2021 by Esat Erkec

In this article, we will look at the 2 different SQL syntax checker tools that help to find the syntax errors of the queries without executing them.

SQL LEFT function in queries

October 22, 2021 by Esat Erkec

In this article, we will learn how to use SQL LEFT function with straightforward examples.

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.

Monitoring SQL Server blocking problems

October 12, 2021 by Esat Erkec

In this article, we will learn how to monitor SQL Server blocking issues with different methods.

A SQL Interview Question: Define Deadlocks with an example

October 7, 2021 by Esat Erkec

In this article, we will try to find out an answer to the “Could you Define Deadlocks with a Simple Example” question that might be asked for the database administrator interviews.

SQL Connection Strings tips

September 24, 2021 by Esat Erkec

This article intends to give some useful tips on usage details of the SQL connection strings.

SQL Server Stored Procedure Recompile Options

September 15, 2021 by Esat Erkec

This article intends to give comprehensive details on how we can use the recompilation options of SQL Server stored procedures and how they behave when we use these recompilation options.

SQL Server Stored Procedure Recompilation Factors

September 6, 2021 by Esat Erkec

In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled.

SQL Query recompilations and query performance effects

September 1, 2021 by Esat Erkec

This article will mention in which conditions the query optimizer decides to recompile to queries and how it affects the SQL query performance.

Fundamentals of SQL Server Statistics

August 27, 2021 by Esat Erkec

In this article, we will take a glance at the fundamentals of SQL Server statistics and discover their interaction with the query processing steps with simple examples.

Deep Dive into SQL Server Statistics

August 23, 2021 by Esat Erkec

In this article, we will go through some details about SQL Server statistics.

Introduction to SQL Server Filtered Indexes

August 17, 2021 by Esat Erkec

This article intends to give information about the SQL Server filtered indexes and their performance impacts.