What are Window Functions? Window functions are a class of SQL functions. They perform calculations across a set of table rows related to the current row. Unlike aggregate functions (e.g., SUM, COUNT), window functions do not collapse rows into a single result. Instead, they calculate values for each row while maintaining row granularity. A window […] The post Window Functions in SQL Server appeared first on Technology with Vivek Johari ..read more

When SQL Server compiles and executes a SQL batch, it does not compile each line of code individually. Instead, it processes the batch as a whole. This creates an execution plan for the entire query or set of statements in the batch. Here’s how it works in more detail: 1. Compilation vs. Execution 2. Processing […] The post How SQL Server Handles SQL Batch Execution appeared first on Technology with Vivek Johari ..read more

Data modeling is essential for effective database design, serving as a blueprint for data structure and management. It improves data integrity, performance, and scalability. Key components include conceptual, logical, and physical models. Best practices involve understanding business needs, normalizing data, defining keys, and ensuring security while documenting the model for future reference. The post Top Data Modeling Best Practices for Efficient Databases appeared first on Technology with Vivek Johari ..read more

This article explained about measures for securing data in SQL Server at various levels to protect data from unauthorized access and breaches. The post Securing data in SQL Server appeared first on Technology with Vivek Johari ..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 […] The post Best Practices in SQL Coding appeared first on Technology with Vivek Johari ..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 […] The post How to approach for performance tuning of a Complex SQL Query appeared first on Technology with Vivek Johari ..read more

This article explain key concepts and best practices related to NULL value in SQL which help in mastering the NULL value in SQL Server. The post Mastering NULL value in SQL Server appeared first on Technology with Vivek Johari ..read more

In SQL Server, Change Data Capture (CDC) is a powerful feature that tracks changes (inserts, updates, and deletes) made to The post Understanding CDC in SQL Server appeared first on Technology with Vivek Johari ..read more

The post Happy New Year 2024 appeared first on Technology with Vivek Johari ..read more

Top Interview Questions on SQL NULL value Introduction In this article, I am going to explain NULL value in SQL and the frequently asked top SQL interview questions on SQL NULL value SQL NULL value In SQL, NULL is defined as unknown value or yet to be define value.  For example, if an user has appeared for 5 exams and he got marks for 4 exams but last exam result is still awaited, we can’t place 0 value in last exam column. In this case we put NULL value in the last column and later replace it with the actual marks. Also since NULL value is considered as unknown, we can’t compare one NULL ..read more