In this article, we will explore how we can use SQL Server extended events to monitor query performance in SQL Server.
Read more »
Performance tuning
Automatic Index advisor in Azure SQL database
October 26, 2021This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database.
Read more »
SQL LEFT function in queries
October 22, 2021In this article, we will learn how to use SQL LEFT function with straightforward examples.
Read more »
How to use SQL Check Constraints
October 15, 2021This article intends to give comprehensive information about the usage and other details of SQL check constraints.
Read more »
SQL Server Extended Events Causality Tracking
October 14, 2021This article explores the Causality tracking option in the SQL Server Extended Events session(XEvents) and its usefulness in troubleshooting performance issues.
Read more »
Performance impact analysis of enabling Transparent Data Encryption (TDE) on SQL Server
October 14, 2021Transparent 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.
Read more »
Monitoring SQL Server blocking problems
October 12, 2021In this article, we will learn how to monitor SQL Server blocking issues with different methods.
Read more »
A SQL Interview Question: Define Deadlocks with an example
October 7, 2021In 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.
Read more »
Min and Max memory configurations in SQL Server Database instances
October 6, 2021This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances.
Read more »
The ghost cleanup task for SQL Server Databases
October 6, 2021This article explains the internals of the Ghost cleanup task for SQL Server Databases.
Read more »
MSDB SQL Database Maintenance and Cleanup
October 4, 2021This article explores the MSDB SQL Database maintenance and cleanup process essential for every DBA.
Read more »
DTU and vCore based models for Azure SQL Databases
September 27, 2021Azure SQL Database is a popular choice for migrating your database from on-premises to cloud infrastructure. It enables you to move to a fully managed Platform as a Service (PaaS) with desired performance and cost-effectiveness.
Read more »
SQL Connection Strings tips
September 24, 2021This article intends to give some useful tips on usage details of the SQL connection strings.
Read more »
SQL Server Stored Procedure Recompile Options
September 15, 2021This 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.
Read more »
Auto Update SQL Server Statistics Asynchronous configuration for Azure SQL Database
September 7, 2021This article explores auto-update SQL Server Statistics asynchronous configuration for Azure SQL Database and On-premises SQL instance.
Read more »
SQL Server Stored Procedure Recompilation Factors
September 6, 2021In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled.
Read more »
SQL Query recompilations and query performance effects
September 1, 2021This article will mention in which conditions the query optimizer decides to recompile to queries and how it affects the SQL query performance.
Read more »
Internals of Physical Join Operators (Nested Loops Join, Hash Match Join & Merge Join) in SQL Server
August 30, 2021Introduction
There are three types of physical join operators in SQL Server, namely Nested Loops Join, Hash Match Join, and Merge Join. In this article, we will be discussing how these physical join operators are working and what are the best practices for these different joins.
Read more »
Fundamentals of SQL Server Statistics
August 27, 2021In 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.
Read more »
Persist sampling rate for automatic SQL Server statistics updates
August 27, 2021This article explores Persist sampling rate feature for automatic SQL Server statistics update.
Read more »
Deep Dive into SQL Server Statistics
August 23, 2021In this article, we will go through some details about SQL Server statistics.
Read more »
Introduction to SQL Server Filtered Indexes
August 17, 2021This article intends to give information about the SQL Server filtered indexes and their performance impacts.
Read more »
A deep dive into SQL Table Variables
July 28, 2021In this article, we will explore some secrets about SQL Table Variables.
Read more »
SQL Server Performance Tuning: Resolving Last Page Insert Contention
June 25, 2021In this article, we will focus on one major SQL Server performance issue that we may experience during heavy data insertion in a table.
Read more »
SELECT INTO TEMP TABLE statement in SQL Server
June 21, 2021In 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.
Read more »