SQL Server Topics

Basics

Please watch below 4 minute video, if you are new to my blog.

SQL Complete Course videos

SQL & DBMS

RDBMS

Data, Types of Data & NoSQL

Page in sql server

Datatype

How to Install SQL Server

Step by Step How to Install SQL Server, SSMS & Azure Data Studio ?

SQL Commands

SQL commands (DDL | DML | DCL | TCL | DQL)

Purge Data | Archive Data

Delete millions of records

Constraints

Check 

NOT NULL

Default 

Table level constraint & Column Level Constraint

keys

Primary key

Foreign key

Unique key

Primary key, Unique Key, & Foreign Key Summary

joins 

Identity

Stored Procedure 

Function

View 

Cursor

DML Trigger

DDL Trigger

Logon Trigger

Temp Table 

Table variable

CTE

Derived Table

Exception Handling / Error Handling

Transaction and ACID properties 

How to Debug SP Stored procedure / SQL Code

Index 

SQL Queries

How to Understand Database

While loop

Running Sessions in SQL Server

Suspended Sessions in SQL Server

When to rebuild or reorganize Index in SQL Server

How to Check Index Read, Write, Seek, Scan and Size.

Last Executed queries on sql server

Foreign Key List

Table Record Count and Size of Table

Index Size

Index Progress