One of my favorite new features with SQL Server 2008 is the addition of intellisense to the query windows in SQL Server Management Studio.  But I have been a little bit frustrated by its behavior at times.  For example, after I create a new table, I often want to write stored procedures that use that table.  But the query window would not show the table or its columns in intellisense.  Once I typed out the table and column names completely, they would have the red squiggly underline indicating that they were invalid.  The query would execute fine, but the red squigglies would remain. 

I just discovered that this problem was not overlooked by Microsoft.  They included a menu option to refresh the local cache for intellisense.  Find it under Edit > Intellisense > Refresh Local Cache, or just use the keyboard shortcut (Ctrl + Shift + R).  I probably should have found this sooner, and many of you may have already known about it, but for those of you who have felt the same frustation, I hope this helps.