|
Which Denali/Juneo/Crescent features do you like the most?
(comments are locked)
|
|
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 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 '10 at 04:13 AM
David Wimbush
(comments are locked)
|
|
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:
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. 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 '10 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: Ahh, I love pseudo-code.
Nov 15 '10 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 '10 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 '10 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 '10 at 01:20 AM
Matt Whitfield ♦♦
(comments are locked)
|
|
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! @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 '10 at 07:41 AM
WilliamD
(comments are locked)
|
|
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.
(comments are locked)
|
1 2 next page »
