In my post, Why use aliases?, I spoke in favor of using a certain syntax in your SQL programming, particularly because SQL Server 2008 gives you almost no reason not to with integrated Intellisense.

One little note for those who may have run into a frustration while developing – Intellisense in SQL 2008 does not always refresh timely. This can be particularly annoying if you are in the middle of developing, make some schema changes and then try to write a script – intelllisense will not prompt you with the correct values, or tell you that objects and schemas do not exist.

Only two known ways to resolve this for now:

  • Main Menu: Edit > Intellisense > Refresh Local Cache
  • Or, shortcut keys: CTRL + Shift + R