What's the best way to prepare for a technical interview focusing on T-SQL? [closed]

As it currently stands, this question is not a good fit开发者_如何学JAVA for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 11 years ago.

I have a job interview coming that will focus on T-SQL and general SQL competency.

Any suggestions on how to prepare for this?

---

I always ask a question that can be solved either set-based or with a cursor to see if they know not to use the cursor. I'd want to see explicit joins and not implicit joins in any code samples. I'd want to see that you don't use select *. I'd ask about performance tuning. I'd want to know if you understand the difference between the various join types.

Here are some basic types of query patterns you should know and be able to discuss or provide sample code for : What are some useful SQL statements / usage patterns that should be known by all developers who may touch the Back end side of the project?

---

Read up on

• Normalization and it's forms.
• Indexing
• Table relations
• Keys
• DataTypes
• Transactions
• Locks
• Constraints
• UDF's

---

Take a look at SQL Server Quiz, Can You Answer All These?

---

Here are a couple of websites that list questions that others have encountered (along with the answers):

Sybase Interview Questions

Sybase tips