1000 Plus SQL Server Interview Questions and Answers

1000 Plus SQL Server Interview Questions and Answers

SQL THE ONE Book Preview

1000 Plus SQL Server Interview Questions and Answers

The book “SQL THE ONE” contains 1000 Plus SQL Server Interview Questions and Answers. This post takes you through the SQL THE ONE book preview and insights. SQL Server interview questions are categorized into 12 chapters which makes interview preparation easier. Below is the category wise question count:

Please click on the chapter name to view the top questions.

 

Chapter Total Questions
Chapter – 1: SQL Server Architecture 40 +
Chapter – 2: SQL Server Installations and Upgrades 100 +
Chapter – 3: SQL Server Security 70 +
Chapter – 4: SQL Server Backup & Restore 50 +
Chapter – 5: SQL Server Log Shipping 30 +
Chapter – 6: SQL Server Database Mirroring 40 +
Chapter – 7: SQL Server Replication 60 +
Chapter – 8: SQL Server Failover Clustering 70 +
Chapter – 9: SQL Server ALWAYSON 90 +
Chapter – 10: SQL Server Concurrency & Locking 50 +
Chapter – 11: SQL Server Performance Tuning 250 +
Chapter – 12: SQL Server DBA General 180 +

There are total 1000 Plus SQL Server Interview Questions and Answers available in this book and you would see most of the questions are answered with lengthy explanation which gives you more insights of the specific topic. Usually in any interview you might find a chain questions which means a question comes from the previous question answer. “SQL THE ONE” is not just for interview preparation it also helps you to quickly revise and understand the SQL Server concepts. For any comments / Feedback / concerns please reach us on sqltheone@gmail.com.

Visit here for more details about the book availability and formats

Posted in High Availability, Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , | 13 Comments

Top 30 SQL Server DBA Interview Questions

Top 30 SQL Server DBA Interview Questions

SQL THE ONE

Top 30 SQL Server DBA Interview Questions

There are total 185 questions are answered under SQL Server DBA category in the book “SQL THE ONE”. In this chapter we can see questions and answers on DBCC, Common, Snapshots, Transaction Log, Shrink, Boot Page, XML, Triggers, Identity, DBA Responsibilities and Database Design. Below are the Top 30 SQL Server DBA Interview Questions:

1. How to know the estimated TEMPDB space required for running CHECKDB command?

2. We are using In-Memory feature for one of our production database. The database contains memory-optimized tables. Can we run DBCC CHECKDB on this database? Does it support?

3. What are the most common issues a SQL DBA should deal with as a part of DBA daily job?

4. How to recover a database that is in suspect stage?

5. What is your approach in AUTO_GROWTH option while creating a new database?

6. Which operation is faster COMMIT or ROLLBACK? Why?

Continue reading

Posted in Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , | 1 Comment

Top 40 SQL Server Performance Tuning Interview Questions

Top 40 SQL Server Performance Tuning Interview Questions

SQL THE ONE

Top 40 SQL Server Performance Tuning Interview Questions

There are total 254 questions are answered under SQL Server Performance Tuning category in the book “SQL THE ONE”. In this chapter we can see questions and answers on Indexes, Statistics, Performance Monitoring, Query Tuning, Scenarios, Partitions, In-Memory OLTP and TEMPDB. Below are the Top 40 SQL Server Performance Tuning Interview Questions:

1. What is the difference between composite index and covering index?

2. Do we need to create a covering index for all queries? If not on which basis we have to create covering index?

3. Any idea about filtered index? Why indexed views when we can achieve the same with filtered index?

4. Is there any difference between disabling CLUSTERED and NON-CLUSTERED Index?

5. There is a non-clustered index IX_1 available on table T. I have created a duplicate index IX_2. Now can you tell me which is the index is chosen by query optimizer and why?

6. Let’s say I have a table like: Tab (Col1, Col2, Col3, Col4, Col5, Col6, Col7). I created a clustered index and a non-clustered index like Clustered On (Col1, Col2) and Non-Clustered index on (Col1, Col2). Can you explain the B-Tree structure?

Continue reading

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | 7 Comments