I came to SQL Server from using Access so this is why I am asking these questions... At the same time, algorithms in website search engines are mainly working with keywords so it seems that a large part of the recruitment process is candidates needing to make sure that they put the right one's in.

Just an additional question; what's the norm in working styles, if there is one? Do most developers use views to select as much of the query as possible and then modify the T-SQL or do they just type out the code straight off?