Search
Search
Dark mode
Light mode
Explorer
Home
❯
04 Databases
❯
01 SQL Server
❯
03 Query Writing and Optimization
Folder: 04-Databases/01-SQL-Server/03-Query-Writing-and-Optimization
20 items under this folder.
Apr 11, 2026
01 - SELECT and Query Basics
sql-server
tsql
query-writing
Apr 11, 2026
02 - Data Types, Conversion, and Null Handling
sql-server
tsql
query-writing
Apr 11, 2026
03 - Joins, Subqueries, and APPLY
sql-server
tsql
query-writing
Apr 11, 2026
04 - Common Table Expressions and Temporary Objects
sql
sql-server
tsql
cte
tempdb
Apr 11, 2026
05 - Window Functions
sql-server
tsql
query-writing
Apr 11, 2026
06 - Numeric and Aggregate Functions
sql-server
tsql
query-writing
Apr 11, 2026
07 - String Functions and Pattern Matching
sql-server
tsql
query-writing
Apr 11, 2026
08 - Date and Time Functions
sql
sql-server
tsql
date
time
time-zone
Apr 11, 2026
09 - JSON, XML, and Semi-Structured Data
sql
sql-server
tsql
json
xml
semi-structured-data
Apr 11, 2026
10 - INSERT, UPDATE, DELETE, and OUTPUT Patterns
sql-server
tsql
query-writing
dml
Apr 11, 2026
11 - MERGE and Upsert
sql-server
tsql
query-writing
merge
upsert
Apr 11, 2026
12 - SARGable Queries
sql-server
tsql
query-writing
performance
sargable
Apr 11, 2026
13 - Execution Plans
sql
sql-server
tsql
Apr 11, 2026
15 - System Functions and Session Metadata
sql-server
tsql
query-writing
Apr 11, 2026
18 - Race Conditions
sql-server
tsql
concurrency
Apr 11, 2026
19 - Stored Procedures, Dynamic SQL, and Error Handling
sql
sql-server
tsql
stored-procedures
dynamic-sql
transactions
sql-injection
Apr 11, 2026
20 - Query Store Regressions and Plan Forcing
sql
sql-server
tsql
query-store
performance
Apr 08, 2026
13 - Wait Stats Analysis
performance
sql
sql-server
tsql
Apr 08, 2026
16 - Blocking and Locking
sql-server
tsql
Apr 08, 2026
16 - Deadlock Detection and Prevention
sql-server
tsql