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

In this article, we will explore how we can use SQL Server extended events to monitor query performance in SQL Server.
Read more »This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database.
Read more »In this article, we will learn how to use SQL LEFT function with straightforward examples.
Read more »This article intends to give comprehensive information about the usage and other details of SQL check constraints.
Read more »This article explores the Causality tracking option in the SQL Server Extended Events session(XEvents) and its usefulness in troubleshooting performance issues.
Read more »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.
Read more »In this article, we will learn how to monitor SQL Server blocking issues with different methods.
Read more »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.
Read more »This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances.
Read more »This article explains the internals of the Ghost cleanup task for SQL Server Databases.
Read more »This article explores the MSDB SQL Database maintenance and cleanup process essential for every DBA.
Read more »Azure 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 »This article intends to give some useful tips on usage details of the SQL connection strings.
Read more »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.
Read more »This article explores auto-update SQL Server Statistics asynchronous configuration for Azure SQL Database and On-premises SQL instance.
Read more »In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled.
Read more »This article will mention in which conditions the query optimizer decides to recompile to queries and how it affects the SQL query performance.
Read more »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 »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.
Read more »This article explores Persist sampling rate feature for automatic SQL Server statistics update.
Read more »In this article, we will go through some details about SQL Server statistics.
Read more »This article intends to give information about the SQL Server filtered indexes and their performance impacts.
Read more »In this article, we will explore some secrets about SQL Table Variables.
Read more »In 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 »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.
Read more »© Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy