The Perfect Mix of Technology & Knowledge
In today’s digital landscape, choosing the right database architecture is crucial for performance, security, scalability, and cost efficiency. The two primary options are on-premise and cloud-based database architectures. This article explores their differences, benefits, limitations, and use cases to help organizations make an informed decision. ☁️ What is Cloud Database Architecture? A cloud database is … Read more
🧾 What is a Ghost Record in SQL? In Microsoft SQL Server, a ghost record refers to a logically deleted row in a database table that has not yet been physically removed from its data page. Ghost records are part of SQL Server’s internal optimization mechanisms, designed to enhance performance and manage concurrency efficiently. 🔍 … Read more
An estimated query plan is a prediction based on available statistics whereas an actual query plan includes runtime execution details.
What are DMVs in SQL Server? Dynamic Management Views (DMVs) are system views in SQL Server. They provide insights into the internal workings of the database engine. These views expose details about the server’s health, configuration, performance, and activity. They enable database administrators (DBAs) to monitor, troubleshoot, and optimize SQL Server. DMVs are broadly classified … Read more
Temporal Tables in SQL Server Temporal Tables (also known as system-versioned tables) are a feature in SQL Server. They allow automatic tracking of historical changes to data over time. They maintain a history of all changes made to a table. This makes it easy to query past versions of data. You can also analyze trends. … Read more
This article explains Correlated subqueries which are a powerful SQL feature for handling row-specific comparisons and complex conditions.
In the context of database management, partitioning refers to the technique of dividing large tables or indexes into smaller, more manageable pieces to improve performance and manageability. There are two primary types of partitioning: vertical partitioning and horizontal partitioning. Vertical Partitioning Vertical partitioning involves splitting a table based on its columns, where each partition holds … Read more
The Actual Execution Plan and the Estimated Execution Plan in SQL Server provide insights into how a query will or has been executed. They differ in their purpose, generation, and details: 1. Purpose 2. Execution Requirement 3. Information Provided 4. Use Cases 5. Tools to Generate Plans 6. Common Scenarios Scenario Estimated Plan Actual Plan … Read more
For any programming language, just writing the code is not well enough. It should be written using the best practices for getting optimise performance . In this article, I will explain the disadvantages of writing code without using Best Practices in SQL Coding. Later, I will describe how best practices can be implemented in our … Read more
Performance tuning of a complex SQL query involves understanding its execution flow, optimizing query structure, and improving database interactions. In this article, I will discuss the approach which can be helpful for performance tuning of a complex SQL query. To understand the approach, we will going to use some examples. In these examples, we have … Read more
