Denali features....

Which Denali/Juneo/Crescent features do you like the most?
more ▼

asked Nov 15, 2010 at 01:52 AM in Default

Håkan Winther gravatar image

Håkan Winther
15.7k 35 37 48

(comments are locked)
10|1200 characters needed characters left

8 answers: sort voted first
HADR, New Interface in SSIS, Sequence Objects in T-SQL Rocks!
more ▼

answered Nov 15, 2010 at 02:02 AM

Cyborg gravatar image

10.6k 36 40 45

Im sadly excited about the HADR feature!!!
Nov 15, 2010 at 07:02 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

In Denali I like the Sequence generator, throw exception and the new columnstore index.

The whole Crescent project is very exciting, and I look forward to see the CTP
more ▼

answered Nov 15, 2010 at 02:32 AM

Håkan Winther gravatar image

Håkan Winther
15.7k 35 37 48

I just Googled 'denali throw' to see what's changed there. Try it - you won't find what you would expect! (It IS SFW.)
Nov 16, 2010 at 04:13 AM David Wimbush
(comments are locked)
10|1200 characters needed characters left

From my perspective, I haven't seen anything that great.

I mean there's lots of updates to the ancillaries - for example SSIS, SSRS, Crescent etc. But I'm a total T-SQL nerd, and there's not much in there that I like that much.

I mean sequences, OK, they could be quite useful for serial number generation, etc. However, there's a lot I would have like to have seen that isn't there:

  • Support for scalar expression functions
  • Support for specifying order over CLR aggregates
  • Support for resolution of multiple cascade paths for foreign keys
  • Support for the [windowing functions that PostGres has][2]

Basically there's lots of awesome at the top level, but there doesn't seem to be a lot of awesome at the level I love: T-SQL.

[2]: http://www.postgresql.org/docs/9.0/static/functions-window.html#FUNCTIONS-WINDOW-TABLE
more ▼

answered Nov 15, 2010 at 02:56 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

I agree with you, there is a lot missing from a T-SQL perspective. I had the chance to talk to some guys at MS about the scalar expressions, implicit conversions and windowing functions, and unfortunately those improvements didn't make to this release. :( They don't want to implement "implicit" inline scalar valued functions for simple functions that will work for, what they think is 50% of all functions ( I would guess it's 80% ). They want a whole new solution for scalar functions.
Nov 15, 2010 at 06:28 AM Håkan Winther

Well, I have a lot of respect for the product team - so I wonder why they made that choice. I would have thought the code would look something like:

if (expression.type == scalar_expression)
Ahh, I love pseudo-code.
Nov 15, 2010 at 07:21 AM Matt Whitfield ♦♦
They are worried about all the phonecalls to the support team, and how many times they need to explain why some scalar works fine and some of them don't
Nov 15, 2010 at 07:33 AM Håkan Winther

@Matt - totally agree - epic fail on MS part for not doing the window functions yet. Has to be the most wanted T-SQL functionality that is missing.

Saw a short demo of THROW - finally a real way of passing errors. The guy in charge of this side of things really seems to be a smart person and want to get T-SQL to advance out of the 80s.
Nov 15, 2010 at 07:44 AM WilliamD
@Håkan - I wonder if they could have added something like 'WITH INLINE' to the definition - meaning you would have to deliberately mark it as such. Maybe that would avoid help desk calls... ?
Nov 17, 2010 at 01:20 AM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left
I tell you what I don't like in the new SSMS... For 15 years, I've been used to hitting CTRL+E to run a query. Now I have to press F5. Finger macros failing all over the place!
more ▼

answered Nov 15, 2010 at 03:08 AM

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

@ThomasRushton - If I understood this correctly, this is a "feature" that they have in the CTP. The muscle memory support will be replaced by full release.
Nov 15, 2010 at 07:41 AM WilliamD
(comments are locked)
10|1200 characters needed characters left
I'm with Matt. I haven't seen anything that just makes me jump up in my chair and shout. There are lots of enhancements around reporting & stuff. The columnar data is probably going to be a bit of a game changer. It's just hard to quantify it at this point. The demos look really cool, but that's the point of demos. Other than that, I'm not beside myself about any of the new functionality, yet.
more ▼

answered Nov 15, 2010 at 06:10 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: Nov 15, 2010 at 01:52 AM

Seen: 2093 times

Last Updated: Nov 15, 2010 at 01:52 AM