Writing where clause has been easiest thing. Most of the time we learn this as a first thing in SQL. I have often seen that many times a simple question with where one has to write about where clause they often fail or get confused. Let us see how many different way you can write following where clause related question - How can you write a WHERE Clause to search names between A-J?

Every time when developer attempts to update the TableA the table is not updated but instead TableB is updated. After a while confused developer figured out the reason for the same – it was trigger created on the table. What are the different types of triggers inside SQL Server 2008 R2 edition?

DBA had to restore its database on new server runs a query to validate the data. The same query on the same database started to give different results. After a quick research he figured out that collation was different of both the database. What is Collation and Collation Sensitivity inside SQL Server?

I noticed very long stored procedure in the production database. This database creating temporary tables, using insert and select statement. When I asked the purpose of the stored procedure, I realize they should have just used OUTPUT clause. What is the OUTPUT clause inside SQL Server?

Have you ever faced situation when you trying to retrieve any data and the query keeps on waiting on the data and eventually times out. One of the reasons for the same can be locking. What are the different types of locks inside SQL Server 2008 R2?

ANSI ISOLATIONS levels are very important part of any database. There are two database servers both have different isolations levels. Due to the same different results are returned to the users. Let us help them by educating regarding various isolations levels and their various behaviors with example. What are the different ANSI ISOLATION Levels? What is the additional ISOLATION Level with SQL Server and explain its behavior?

What is an IDENTITY Value? What are the different ways to get IDENTITY values and properties of IDENTITY Values? If you are going to answer that identity value is ever increasing, is it possible to have identity value ever decreasing value?

A SQL developer got surprised when he learned that he does not have to use cursors to calculate ranks in SQL Server 2008. He can now just use newly introduced ranking functions. What are the different RANKING functions inside SQL Server 2008 R2 and what are the new functions introduced inside SQL Server 2012?

It is saying that where you should use nail, you should not use sword. Every little tool has its own usage and its own purpose. What are the differences of CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX) datatypes?

Performance tuning expert often encounter situation where it is difficult to figure out why certain activities are happening behind the scene in SQL Server Engine. Every action has some root cause and understanding the same is the key to be successful performance tuning expert. Here is one question which often puzzles many - When are the non-Clustered Indexes automatically rebuilt?