From my perspective, one of the best things about SQL Server 2008 is the new intellisense/auto complete. But, if you’ve had SSMS (SQL Server Management Studio) open for a while as you add and remove objects, you might notice that your intellisense fails to pick up some of your new objects, which can be a bit frustrating. Turns out the items in autocomplete get cached when you first open up SSMS. To reload/refresh the cache just use the following keyboard shortcut.

CTRL+Shift+R

You’ll need to give it a few seconds afterwards to finish refreshing, but your new objects should show up in intellisense moving forward.

You can also refresh your cache by going to

Edit -> Intellisense -> Refresh Local Cache (CTRL+Shift+R)

While we’re on the topic of keyboard shortcuts, I might as well throw this link in. (Although oddly enough this shortcut isn’t properly listed.)

http://msdn.microsoft.com/en-us/library/ms174205.aspx