SQL Server

Design, secure, and tune SQL Server. Learn schema design, T-SQL, indexing, query plans, ETL, backups, replication, Always On, partitioning, security, and monitoring. Use scripts and checklists to keep databases reliable and fast.

Total Questions: 1.4k

Post
Article Video EBook

Show Thread for

Page Size

2
Answers

Scalar Value Function in SQL Server

4
Answers

Find Nth Highest Salary in SQL

5
Answers

Difference between DBMS and RDMS

3
Answers

Difference between CHAR and VARCHAR datatype in SQL Server

4
Answers

Materialized views vs Normal views

4
Answers

Fetching the data from different databases

4
Answers

Partitions in SQL server

2
Answers

View in SQL Server

4
Answers

SSMS WIndows authentications user change

3
Answers

SQL Server Agent

2
Answers

Referential integrity in SQL Server

3
Answers

Group by G/l Name

3
Answers

TCL Commands in SQL Server

4
Answers

We need to swap _exchange consecutive seats of students

3
Answers

Pattern Matching in SQL

3
Answers

Self-join, and how does it work in SQL Server

2
Answers

Difference between a correlated subquery and a nested subquery

2
Answers

Differences between the JOIN and APPLY operators

3
Answers

Relational Database in SQL Server

7
Answers

Difference between Truncate and Delete in SQL Server

- of 340