SQL Server Query Analyser Intellisense: Keeping up to Date
The new IntelliSense in SQL Server 2008 is fantastic, and makes SQL development and maintenance much easier.
However, sometimes it can be annoying, as changes and additions are not always immediately reflected in the IntelliSense.
I recently got told about the ability to refresh the IntelliSense cache, using the keyboard shortcut Ctrl+Shift+R. This reloads the data behind the IntelliSense, meaning that your recent changes are picked up and available for you to use.