The New TSQL Code snippets from SQL 11–Denali

I posted the features that I liked most before on my post about where to download the new CTP1 of SQL Denali.

One of them were TSQL Code snippets.

This post will have some screenshots about the new feature, and how to use it.

My opinion on this feature is that it is awesome, and it still needs improvement.

The MS books online of this feature is on this link.

So its Just Open up the new SQL Server Management Studio.

Open a New Query, and press 

Ctrl K + Ctrl X

You will see this window:

Now if you select Function and Create Multi-Statement Table Function

You’ll see this script being added to the window.

Note the highlighted areas, the current area I am editing is the schema, however if I edit for example the parameter name, it will be updated across the script.

It works a little like the Visual Studio .NET Snippets, however for developers the snippets are really more powerful, lets hope this feature gets improved, as the potential for this is Huge.

Well this was fun, hope this gets you excited about what's coming next on the next version of SQL.

Greetings for all,
The Developer Seer.

Refreshing the Intellisense cache in SSMS 2008

I'm currently using alot SQL Server Management Studio (SSMS) 2008, and often when I create a new table it doesn't appear on Intellisense, and after a little research I came across this website:

Source: Dan Jones (aka dtjones) refreshing the intellisense cache

by Dan Jones.

And learned why this happens, and how to fix it.

First how to Fix it: There's two ways, the quicker and what you'll want to know if you are a shortcut Ace (or wannabe) is Ctrl + Shift + R , the other way is to go to the Menu in: 

Edit -> IntelliSense (last option) -> Refresh Local Cache 

Then Why it happens: SSMS reads all this info on what tables exist's and other things and cache it locally (it doesn't check every time), if you create a table or anyone creates a new table on the database SSMS won't update his local cache, so you have to do this manually, a good point of observation is that sometimes SSMS does update the cache and it depends on some actions, to learn how does the SSMS cache work you can observe when does it reads his cache.

Hope it helped,

Good Luck

The Developer Seer.