SQL

SQL

Query and shape relational data with confidence. Learn SELECTs, joins, window functions, indexing, transactions, normalization, and performance tuning. Get practical recipes for reporting, analytics, and application data access patterns.

Ask a question or start a discussion

Article Video EBook

2

Answers

Database first approach

Nikitha Elangovan

Nikitha Elangovan

4d

257

2

SQL

SQL Cheatsheet: A Simple and Complete Guide

Rinki

Aug 07

524

2

SQL

Essential SQL Commands Every Beginner Should Know

Vinay Reddy Thadakala

Vinay Reddy Thadakala

Aug 05

715

3

SQL

How to Create Table & Insert Records in Microsoft Fabric Data Warehouse SQL Endpoint

Abiola David

Jul 15

6.4k

2

SQL

Differentiate MySQL and MSSQL

Sangeetha S

Jul 08

5.7k

1

2

Answers

What is the difference between temp tables and table variables in SQL?

Muhammad Imran Ansari

Muhammad Imran Ansari

Jun 12

580

SQL

Table Sharding in SQL: Types, Examples, and Best Practices

Ayush Gupta

Jun 10

977

4

SQL

Database Fragmentation: Understanding, Managing, and Mitigating

Ayush Gupta

Jun 06

1.6k

6

SQL

Horizontal vs Vertical Partitioning in SQL

Ayush Gupta

Jun 05

1.3k

5

SQL

Understanding DBCC Commands in SQL Server: Use Cases and Importance

Ayush Gupta

May 31

1.2k

4

SQL

SQL Server Transaction Locks: Identification & Resolution

Ayush Gupta

May 28

1.2k

5

SQL

Database Dictionary (1-2-1) --- Using Dynamic SQL Script

George

May 16

1.5k

5

SQL

NoSQL vs. SQL: Which One to Use

Tural Suleymani

Tural Suleymani

May 02

1k

3

SQL

Understanding Change Data Capture (CDC) and Its Types

Jay Krishna Reddy

Jay Krishna Reddy

Apr 30

1k

1

SQL

Schedule SSIS Jobs Step by Step with Screenshots

U T

Apr 14

872

1

SQL

Top 20 SQL Best Practices Every Developer Should Follow

Divyank Soni

Apr 03

1.3k

9

SQL

SQL Optimization: Filter Data Before or During a JOIN?

Shubham Sidnale

Shubham Sidnale

Mar 31

1.7k

3

0

Answer

What is an INDEX in SQL Server? How does it improve query performance?

Muhammad Imran Ansari

Muhammad Imran Ansari

Mar 24

426

SQL

Understanding Parameter Sniffing in SQL Server

Siddhesh Chavan

Siddhesh Chavan

Mar 24

876

3

SQL

Explaining Aggregate Functions in SQL

Morteza Mousavi

Morteza Mousavi

Feb 14

654

7

1

Answer

Combine 2 columns and display result

Ramco Ramco

Feb 11

409

0

3

Answers

What is a Primary Key, Foreign Key, and Composite Key?

Tharunkumar Magudeeswaran

Tharunkumar Magudeeswaran

Feb 09

548

0

3

Answers

Materialized view vs Table with SP

Tharunkumar Magudeeswaran

Tharunkumar Magudeeswaran

Feb 05

560

0

SQL

Reduce NULL Storage in SQL Server with Sparse Columns

Dashrath Hapani

Dashrath Hapani

Feb 05

1.9k

5

3

Answers

SCD type 6 in sql

Tharunkumar Magudeeswaran

Tharunkumar Magudeeswaran

Feb 03

569

0