Common SQL Interview Questions and Answers
January 6, 2023If you are working on SQL programming or learning SQL or how to write queries and looking to test your knowledge or prepare for any SQL interview, the below article can help you.
Search Results for: in memory
Hybrid Buffer Pool in SQL Server 2019
November 23, 2021This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019.
SSIS Merge Join vs. Merge Transformation
September 28, 2021SSIS Merge Join and Merge transformations are two similar components used to combine two input data sources into one output. This article explains both transformations and illustrates when and how to use each one of them.
A deep dive into SQL Table Variables
July 28, 2021In this article, we will explore some secrets about SQL Table Variables.
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.
Common Table Expressions for Database Developers
June 24, 2021Introduction Though the Common Table Expressions (CTE) were introduced to SQL Server more than a decade ago with the SQL Server 2005 version, still this is not much utilized by database developers due to the unawareness. This article provides what and how you can utilize the CTE effectively and efficiently.
Automatic Pause and Resume of an Azure SQL database
April 2, 2021Azure SQL Database is an Infrastructure-as-a-Service component for migrating your on-premises SQL Server to cloud infrastructure. We always look for performance, cost, and scaling resources while we plan resources in the cloud. Many times, we do not want our databases running 24*7*365. Suppose you have a development or training database. Your developers work during the […]
MySQL Recursive Queries
March 18, 2021Introduction As we lever MySQL to build database solutions, we might need to build a MySQL recursive query. In an earlier Database Journal article, I showed how to solve an integer parsing problem with SQL Server recursion. This article will show how to solve that same problem with MySQL recursion, highlighting the strong and weak […]
Using Automatic Plan Correction for Query Tuning
March 4, 2021In this article, we will learn what is plan regression and how we can fix this issue with help of the Automatic Plan Correction feature.
How to prepare for the Exam DP-300: Administering Relational Databases on Microsoft Azure
September 14, 2020In this article, we will show how to prepare yourself for the DP-300 exam: Administering Relational Databases on the Microsoft Azure certificate exam.
Working with Pandas Dataframes in Python
August 19, 2020In this article, I am going to explain in detail the Pandas Dataframe objects in python. In the previous article in this series Learn Pandas in Python, I have explained what pandas are and how can we install the same in our development machines. I have also explained the use of pandas along with other […]
How to rollback using explicit SQL Server transactions
June 17, 2020In this article, we will explore the process of rollback an explicit SQL Server transaction. We will also explore the difference between explicit and implicit transactions.
SQL Server TempDB database and Latch Contention
May 13, 2020In this article, we will learn latch contention issues that we might experience in the SQL Server TempDB database. We will also discuss reasons and the solution method of these latch contention issues. Especially, we will mention the Memory-Optimized TempDB Metadata feature that was introduced with the SQL Server 2019.
An overview of ETL and ELT architecture
April 21, 2020This article explains what the basic features and differences between ETL and ELT are. I’m also going to explain in detail what an ELT pipeline is and a relevant architecture for the same in Azure. So far, we have come a long way dealing with ETL tools which basically are Extract, Transformation and Load technique […]
An overview of the SQL cursor @@FETCH_STATUS function
January 23, 2020SQL cursor is one of the most popular database objects. It is used to retrieve data from the result set of an SQL query one row at a time. Even if the cursor is not recommended from a performance perspective, they are still widely used especially when handling a small amount of data.
An overview of the SQL table variable
October 16, 2019This article explores the SQL Table variables and their usage using different examples.
SSIS XML Destination
October 11, 2019Until now, Microsoft has not included the XML Destination component in SQL Server Integration Services (SSIS). Many years ago, this component was requested on the Microsoft connect website, but it was closed as “Won’t fix.” For this reason, many workarounds and third-party components were created. In this article, we’ll talk about these components and some […]
SQL Server Database Metrics
October 2, 2019Summary There is a multitude of database metrics that we can collect and use to help us understand database and server resource consumption, as well as overall usage. This data can include hardware statistics, such as measures of CPU or memory consumed over time. We can also examine database metadata, including row counts, waits, and […]
SQL Server CHECKPOINT, Lazy Writer, Eager Writer and Dirty Pages in SQL Server
August 22, 2019Database administrators should be aware of the internal SQL Server processes such as the dirty pages, SQL Server CHECKPOINT, Lazy writer process. This is a very common question that you might come across in SQL DBA technical interviews as well on all levels such as beginner, intermediate and expert level.
Monitoring SQL Server deadlocks using the system_health extended event
August 12, 2019Performance monitoring is a must to do the task for a DBA. You should ensure that the database performance is optimal all the time without any impact on the databases. Performance issues act like an open stage, and you need to look at every aspect such as CPU, RAM, server performance, database performance, indexes, blocking, […]
Clustered Index vs. Heap in SQL Server
June 21, 2019Summary There are few topics so widely misunderstood and that generates such frequent bad advice as that of the decision of how to index a table. Specifically, the decision to use a heap over a clustered index is one where misinformation spreads quite frequently.
SQL varchar data type deep dive
May 29, 2019In this article we’ll review the SQL varchar data type including a basic definition and overview, differences from varchar(n), UTF-8 support, Collation, performance considerations and more.
Implementing a manual SQL Server Audit
January 25, 2019A SQL Server audit can be performed using various number of methods. This includes using the built-in SQL Server Audit feature, using third party tools from the SQL Server market or simply perform the audit task using the legacy methods manually. In the previous article of this series, SQL Server audit overview, we discussed the […]
Using SQL Power Doc to Discover, Diagnose and Document SQL Server
January 21, 2019This article will provide an overview of SQL Power Doc, a powerful script to document SQL Server, including pre-requisites, purpose, installation, processing and output.
CRUD operations in SQL Server
December 10, 2018CRUD operations are foundation operations every database developer and administrator needs to understand. Let’s take a look at how they work with this guide.