261
SQL Server Interview
SQL Server Internals & Administration
SQL Server interview questions covering sql server internals & administration.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
262
Why can tempdb become a performance bottleneck?
263
How should tempdb data files be configured?
264
What is the SQL Server transaction log?
265
What is write-ahead logging (WAL)?
266
What is a checkpoint?
267
What are VLFs in the transaction log?
268
Why should transaction log files be pre-sized appropriately?
269
What is log truncation?
270
What is the buffer pool?
271
What is the plan cache?
272
What are wait statistics?
273
What are some common SQL Server wait types?
274
What is Extended Events?
275
What is the system_health Extended Events session?
276
What is SQL Server memory pressure?
277
What is max server memory?
278
What are SQL Server data files and log files?
279
What are filegroups?
280