Vik Trix

sql

Materialized Views in SQL Server

In SQL Server, a materialized view is a physical copy of a table that stores retrieved data from m…

byVikash Chauhan •May 29, 2024

System databases in Sql Server

SQL Server provides several default system databases, each serving a specific purpose. Here are the…

byVikash Chauhan •May 24, 2024

Temporary Tables vs Table Variable in Sql Server

Sure, I’d be happy to explain the differences between temporary tables and table variables in SQL S…

byVikash Chauhan •May 24, 2024

The magic table in sql server

Magic tables in SQL Server are special types of tables that are automatically created and managed b…

byVikash Chauhan •May 24, 2024

The window function in SQL with an example

SQL window functions are a powerful feature in SQL that allow you to perform calculations on a set o…

byVikash Chauhan •May 24, 2024

The order of execution of SQL clauses

When a SQL query is run, it doesn’t execute in the order it’s written. Here’s the correct order of e…

byVikash Chauhan •May 24, 2024

RANK() and DENSE_RANK() vs Row_Number() function in sql

Let’s understand the difference between RANK() , DENSE_RANK() , and ROW_NUMBER() functions in SQL w…

byVikash Chauhan •May 24, 2024

TRUNCATE vs DELETE in sql

In SQL Server, the TRUNCATE command is generally faster than the DELETE command for a few reasons…

byVikash Chauhan •May 24, 2024

Get identity column value from sql server

In SQL Server, there are several functions that you can use to return the value created in an identi…

byVikash Chauhan •May 24, 2024

sql query which returns all empolyees who has salry grater than ram salary

-- Assume we have a table called Employees with columns Id, Name, and Salary -- Assume there is onl…

byVikash Chauhan •May 17, 2023

sql query to delete duplicate based on employee name

-- Assume we have a table called Employees with columns Id, Name, and Salary -- Assume we want to k…

byVikash Chauhan •May 17, 2023

sql pagination to fetch 20 record for each page

-- Assume we have a table called Products with columns Id, Name, and Price -- Assume we want to ord…

byVikash Chauhan •May 17, 2023