As most database developers would tell you, writing SQL code is a day to day activity.
Even if you are an ETL, Report, or App-dev developer, there is always some SQL that
must be written and it can be time consuming if you are unfamiliar with the underlying
schema.

Fortunately, Microsoft has now implemented Intellisense functionality in SQL Server 2008!
In case you are unfamiliar with Intellisense, this feature will suggest selectable objects on
the fly to help speed along your development.

Below are some examples of what to expect in this version:

If you open Management Studio and select New Query from the AdeventureWorks database,
type the word "select" and hit the Shift + spacebar to awaken Intellisense if it doesn't automatically
pop up.

In this example, typing select will allow you to choose from Databases, Functions, and Database
Schema objects. 

Choosing the Production schema, you can now choose among the tables and views
belonging to that schema.

Having chosen the Product table, we can now choose from the list of fields
that are contained in that table.

This feature will prove to be invaluable to those developers who spend any time at all
writing SQL code. It basically helps you learn the schema as you type! Wonderful!