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
sardarmudassaralikhan profile

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

#sql #sqlserver #database #linkserver
14
Comments
2 min read
When we use indexes in SQL Table
sardarmudassaralikhan profile

When we use indexes in SQL Table

#sql #sqlserver #database #indexes
Comments
2 min read
Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement
sardarmudassaralikhan profile

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

#sql #sqlserver #sqlservermanagemnet #database
7
Comments
1 min read
Why do we use indexes in the database SSMS?
sardarmudassaralikhan profile

Why do we use indexes in the database SSMS?

#webdev #sqlserver #database #programming
Comments
2 min read
Link Server in SSMS
sardarmudassaralikhan profile

Link Server in SSMS

#webdev #programming #sqlserver #database
Comments
1 min read
How we can use order by Query with a database table without using the Column name
sardarmudassaralikhan profile

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

#webdev #programming #sql #database
Comments
1 min read
Database server communication and data migration from one database to another server database in SQL server
sardarmudassaralikhan profile

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

#webdev #programming #sql #databse
Comments
2 min read
Why do we NOLOCK AND LOCK in SQL server with an example
sardarmudassaralikhan profile

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

#webdev #programming #database #sql
1
Comments
1 min read
Why do we NOLOCK in SQL server with an example
sardarmudassaralikhan profile

Why do we NOLOCK in SQL server with an example

#sql #sqlserver #database #softwaredevelopment
4
Comments
1 min read
Maximizing Database Efficiency Mastering Query Optimization in SQL
sardarmudassaralikhan profile

Maximizing Database Efficiency Mastering Query Optimization in SQL

#sql #sqlserver #softwaredevelopment #dataengineering
2
Comments
2 min read
Unveiling the Robust Architecture of SQL Server A Comprehensive Overview
sardarmudassaralikhan profile

Unveiling the Robust Architecture of SQL Server A Comprehensive Overview

#programming #sqlserver #database #dataengineering
Comments
2 min read
Materialized View to improve the performance of complex queries?
sardarmudassaralikhan profile

Materialized View to improve the performance of complex queries?

#sqlserver #database #sql #programming
6
Comments
3 min read