DEV Community

Advance SQL Server Database Series' Articles

Back to Sardar Mudassar Ali Khan's Series
How to create and configure a linked server in SQL Server Management Studio

How to create and configure a linked server in SQL Server Management Studio

13
Comments
2 min read
When we use indexes in SQL Table

When we use indexes in SQL Table

Comments
2 min read
Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement

Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement

6
Comments
1 min read
Why do we use indexes in the database SSMS?

Why do we use indexes in the database SSMS?

Comments
2 min read
Link Server in SSMS

Link Server in SSMS

Comments
1 min read
How we can use order by Query with a database table without using the Column name

How we can use order by Query with a database table without using the Column name

Comments
1 min read
Database server communication and data migration from one database to another server database in SQL server

Database server communication and data migration from one database to another server database in SQL server

Comments
2 min read
Why do we NOLOCK AND LOCK in SQL server with an example

Why do we NOLOCK AND LOCK in SQL server with an example

1
Comments
1 min read
Why do we NOLOCK in SQL server with an example

Why do we NOLOCK in SQL server with an example

3
Comments
1 min read
Maximizing Database Efficiency Mastering Query Optimization in SQL

Maximizing Database Efficiency Mastering Query Optimization in SQL

2
Comments
2 min read
Unveiling the Robust Architecture of SQL Server A Comprehensive Overview

Unveiling the Robust Architecture of SQL Server A Comprehensive Overview

Comments
2 min read
Materialized View to improve the performance of complex queries?

Materialized View to improve the performance of complex queries?

5
Comments
3 min read