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

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.

How to gain advanced T-SQL programming skills

August 11, 2021 by Esat Erkec

This article aims to provide various tricks that help to gain advanced T-SQL programming skills.

Using Stored Procedures with Return Values

August 6, 2021 by Esat Erkec

In this article, we will learn how we can use a Stored Procedure with return values with all details.

How to calculate Subtotals in SQL Queries

July 30, 2021 by Esat Erkec

In this article, we will learn how to calculate and add a subtotal in SQL queries.

A deep dive into SQL Table Variables

July 28, 2021 by Esat Erkec

In this article, we will explore some secrets about SQL Table Variables.

File Validation in SQL Server with xp_fileexist

July 6, 2021 by Esat Erkec

In this article, we will explore the xp_fileexist extended stored procedure usage and other details. At the same time, we will take a look at alternative methods to this procedure.

SQL Server Performance Tuning: Resolving Last Page Insert Contention

June 25, 2021 by Esat Erkec

In this article, we will focus on one major SQL Server performance issue that we may experience during heavy data insertion in a table.

SELECT INTO TEMP TABLE statement in SQL Server

June 21, 2021 by Esat Erkec

In this article, we will explore the SELECT INTO TEMP TABLE statement, its syntax and usage details and also will give some simple basic examples to reinforce the learnings.

Usage details of the SET STATISTICS TIME ON statement in SQL Server

June 14, 2021 by Esat Erkec

With the help of the SET STATISTICS TIME ON statement, we can easily report the execution time statistics of a query. In this article, we will learn how to report the query execution time statistics through this statement.

SQL Server Deadlocks with Foreign Keys

May 27, 2021 by Esat Erkec

In this article, we will try to find out the answer to the question of “Does a foreign key lead to a deadlock?”

Working with SQL NULL values

May 19, 2021 by Esat Erkec

This article will explain what problems can occur when working with SQL NULL values and it also gives some solution recommendations to overcome these issues.

SQL Server Performance Tuning tips for beginners

May 12, 2021 by Esat Erkec

This article intends is to give helpful SQL Server performance tuning advice to those who want to learn performance tuning.

Impact of SQL Variables on Performance

May 10, 2021 by Esat Erkec

In this article, we are going to learn how SQL variables negatively affect query performance and also examine the causes of this issue.

Hidden secrets of SQL Server Foreign Keys

April 21, 2021 by Esat Erkec

This article will describe the effect of SQL Server foreign keys on query plans which are created by the query optimizer.

Understanding Execution Plans of the SQL Server Insert statement

April 16, 2021 by Esat Erkec

In this article, we will learn how to interpret an execution plan of a SQL Server insert statement.