Tags » SQL Interview Questions And Answers

Interview Question of the Week #027 - Move TempDB from One Drive to Another Drive When Low Disk Space

I am often invited to attend various interviews and once in a while, I see practical questions discussed in the interview. Here is one of the important interview question which is related to TempDB. 345 more words

SQL Authority

Interview Question of the Week #026 - 64 Bit Vs 32 Bit Confusion

I often see people getting lost between 64 bit and 32 bit operating systems and application conversation. There are plenty of individuals still today, not sure what is the difference between them as well what runs on what platform. 102 more words

SQL Authority

Interview Question of the Week #025 - How to Implement Paging in SQL Server?

Here is a very popular question when SQL Server interview consists of live coding example.

Question: How to implement paging in SQL Server? Explain with the help of script. 190 more words

SQL Authority

Interview Question of the Week #024 - What is the Best Recovery Model?

Here is one of the most popular questions I often see people asking on the internet.

Question: What is the best recovery model for my database? 277 more words

SQL Authority

Interview Question of the Week #023 - Error Handling with TRY...CATCH

Here is one of the most popular question I see people discussing in SQL Interviews.

Question – How do you handle errors with the help of TRY…CATCH? 308 more words

SQL Authority

Interview Question of the Week #022 - How to Get Started with Big Data?

Big data is one of the most popular subject in recent time and everybody wants to get started on this subject. During recent interviews there are plenty of the questions with related to Big Data. 286 more words

SQL Authority

Interview Question of the Week #021 - Difference Between Index Seek and Index Scan (Table Scan)

Question: What is the difference between Index Seek and Index Scan?

Answer: Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table. 244 more words

SQL Authority