TSQL interview questions you ask [closed]

Question

Google search turns up some links to tsql questions. I was wondering what would SO experts would ask in an interview for TSQL.

Answer 1

Here are some of the most common questions I've been asked as an ASP.Net developer with strong SQL Server skills:

• Name and describe the different kinds of JOINs
• What is COALESCE?
• Explain primary and foreign keys
• What would you do to optimize slow-running queries?
• What is the difference between DELETE and TRUNCATE?

Answer 2

There are a bunch of questions here: SQL Server Quiz, Can You Answer All These?

A biggie is of course how can you code to minimize deadlocks

Take the code below for example, 80% of people get that wrong

What will be the output of the following?

SELECT 3/2

Answer 3

In SQL query section (to extend DOK):

• How would you handle NULL problems? (ie. NULL - 25 = ?)
• Variations for CASE in SELECTs (pros/cons)
• User function vs. stored procedure performance
• .NET/SQL integration (pros/cons)
• How would you and why chain SQL queries? (via god-query, view, stored procedures etc.)