SQL Server Questions
SQL Server relational database management system (RDBMS); covers installation and configuration, T-SQL programming, indexing and query optimization, data modeling, data types, transaction handling, backup and recovery, replication, high availability (Always On), security, maintenance, and administration tasks specific to SQL Server.
EasyTechnical
0 practiced
Describe the role of tempdb in SQL Server and recommend best-practice configuration for a busy transactional server. Cover number and sizing of files, autogrowth settings, storage placement, and common pitfalls that lead to tempdb contention.
MediumTechnical
0 practiced
Design and implement row-level security for a multi-tenant SQL Server database so that each tenant only sees their own rows in shared tables. Describe the security predicate function and security policy, sample T-SQL statements, and how to debug and test RLS behavior.
HardTechnical
0 practiced
Your server is experiencing heavy PAGELATCH_UP waits on tempdb under parallel build and insert workloads. Explain root causes, how to diagnose whether allocation contention or latch contention is happening, and list concrete mitigations including tempdb file configuration, trace flags historically used, and schema/application changes.
MediumTechnical
0 practiced
An SSIS ETL load into a large SQL Server staging table is the slowest part of your pipeline. Describe techniques to optimize large data loads (50+ million rows) into SQL Server: include bulk loading options, minimal logging considerations, batching, table locking, and partition-based load strategies.
EasyTechnical
0 practiced
Describe SQL Server transaction isolation levels and their trade-offs. State the default isolation behavior in a modern SQL Server instance, explain 'READ COMMITTED' and 'SNAPSHOT' isolation, and give examples of concurrency anomalies (dirty reads, nonrepeatable reads, phantoms) that each level prevents or allows.
Unlock Full Question Bank
Get access to hundreds of SQL Server interview questions and detailed answers.
Sign in to ContinueJoin thousands of developers preparing for their dream job.