What's new in T-SQL for Denali?

Ok, I'm probably being dumb, but I can't find a summary saying 'here is the new stuff you can do in T-SQL in Denali'.

There is obviously NEXT VALUE FOR, and support for paging - but is there a definitive 'this is what's new' post somewhere?

more ▼

asked Dec 03, 2010 at 08:18 AM in Default

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

Matt - you really missed out not seeing Tobias Ternstrom from the SQL Programming Team (he is lead on programability -> T-SQL, CLR etc.) at the PASS Summit.

He showed the programability enhancements like THROW and the replacement for the borken SET FMTONLY. He is a great presenter and really funny.

Dec 03, 2010 at 12:46 PM WilliamD

@WilliamD - Yeah, I know. It's the fact that the MSDN missed out THROW which leads me to wonder if there is a more definitive resource...

Dec 03, 2010 at 01:07 PM Matt Whitfield ♦♦

Nah - definitive resources for stuff on an unfinished product. Even the MSDN stuff says that it is open to change, so no dice I think.

Dec 03, 2010 at 01:17 PM WilliamD

Well, yeah, CTP1 isn't what RTM will be. But is the question 'what have you actually shipped' so hard to answer?! ;)

Dec 03, 2010 at 02:55 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

I liked this concise article from Aaron Bertrand.

For example, dual monitor support is new.

One part that's missing, at least so far according to Aaron, is the "bread crumb" feature that let's us click on an error message and it takes you to the error in the sproc. I especially liked that feature! ;0)

[Edit] The link mentioned above is hardly comprehensive. At times I wonder if I have reading comprehension problems! Anyway, you may have seen this and it doesn't claim to be an exhaustive list, but maybe this is more relevant to what you're asking.

more ▼

answered Dec 03, 2010 at 08:59 AM

avatar image

2.6k 24 27 31

See... that one is missing THROW as well...

Dec 03, 2010 at 01:09 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

You can get answers from this link.

more ▼

answered Dec 03, 2010 at 08:58 AM

avatar image

1.4k 3 20 7

Yep - knew about that one, but the way that THROW is added in by a MSFT peep in the Community Content section irks me...

Dec 03, 2010 at 01:08 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

In fairness Mark, I have written many blog posts focusing on different features introduced in Denali, including one on THROW. My list isn't comprehensive yet either (for example, I haven't yet blogged about AlwaysOn or the FMTONLY replacements). Here are a couple of links that might be useful to Matt.

This is a list of all the posts I've written and tagged with "denali" - this includes a slide deck of a "What's New in Denali" presentation I gave for the Philadelphia SQL Server User Group this week:


And here is an article on THROW specifically (which, as has been noted, did not make it into the CTP1 Books Online):


Just to clear up any misunderstanding, the Books Online process is not a simple "just throw a web page up there." In can often take weeks or longer to publish a simple page, since it has to be updated in several other places (all deep links, table of contents, index, etc) and it also has to be translated (the CTP and Books Online ship in more than just English). Not saying THROW shouldn't be there, but during the early beta phase we have to compromise. If it's a choice between getting the product with some docs missing, and waiting for complete docs (which will never happen during dev, because dev and doc do not move at the same speed), I know what I would vote for.

more ▼

answered Dec 10, 2010 at 02:31 PM

avatar image

905 3 6

@AaronBertrand - Thanks - the thing i was looking for wasn't a Books Online section - or a series of posts - just a single blog post or something like that, maybe from one of the SQL Engine team, basically summarising what's new in T-SQL. Even just a dump of the differences in the BNF between 2008 and 2011 would be invaluable.

Dec 13, 2010 at 12:17 AM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

I have compiled a large list of features (around 60+) and blog posts and articles explaining each feature. You can find it here: What is new in SQL Server Denali

more ▼

answered Jan 30, 2011 at 06:24 PM

avatar image

Jacob 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 03, 2010 at 08:18 AM

Seen: 2450 times

Last Updated: Dec 03, 2010 at 08:18 AM

Copyright 2018 Redgate Software. Privacy Policy