SQL Server 2008 T-SQL Enhancements Part - I

Question

SQL Server 2008 T-SQL Enhancements Part - I

Arshad Ali-556241

Say Hey Kid

Points: 706
More actions
January 21, 2009 at 9:30 pm

#204404

Comments posted to this topic are about the item SQL Server 2008 T-SQL Enhancements Part - I
With Thanks and Regards
Arshad Ali
Microsoft India
My Blog - http://arshadali.blogspot.com/[/url]

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

sanjarani SSC Veteran Points: 268 More actions · Answer 1

An excellent article, well written and to the point. My recommendation would be to ensure that another person reviews your article for grammer and typos ( Minor point but worth noticing).

Also, when using tempdb in your examples, please add # for temp local or ## for temp global tables, unless with SQL Server 2008, these notation have been removed.

I enjoyed reading this article and look forward to reading part2 ( that you promissed).

Ali Sanjarani

SuperDBA-207096 SSCrazy Eights Points: 8176 More actions · Answer 2

SuperDBA-207096

SSCrazy Eights

Points: 8176

January 22, 2009 at 6:24 am

#931088

Well done! Looking forward to part 2...

Irish Hall of Fame Points: 3958 More actions · Answer 3

Enjoyed the article, but like it if you would compare Intellesense to Redgate SQL Prompt.

I've used both and I admit that I am a bit biased when it comes to Redgate. When SQL Intellisense was billed to be the same as Visual Studio I was expecting much more than what I saw.

Does anyone know if they have made any improvements to Intellisense with updated to SQL 2008?

Regards, Irish

GSquared SSC Guru Points: 260824 More actions · Answer 4

Good article. Thanks for writing it.

Having used various versions of Intellisense with SQL, I have to say I usually don't like it. Too many times, I've had the drop-down picklist cover up stuff that I actually want to see. If I were to choose one over the other, I'd go with Redgate's, because it works with other versions of SQL, while the bit in Management Studio 2008 only works with SQL 2008. If you connect to a 2000 or 2005 server, no intellisense. Redgate's will handle those. I've also tried the one from ApexSQL, and it works well too, but again, I don't like any of them very much for myself.

I like most of the other new features for 2008.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Arshad Ali-556241 Say Hey Kid Points: 706 More actions · Answer 5

Hi Sanjarani,

First of all, I would like to thank you for sparing sometime and reading the article.

I must say, I am delighted to have your valuable feedback and comments, which I will surely incorporate in my future articles.

One more caveat I noticed, I used rich formatting for tables(where I have pasted the example scripts) which have eventually become image after publication and hence readers cannot copy and paste the scripts, I will make sure in next articles I keep it simple. 🙂

Thank you once again for your feedback and yes I look forward for your comments on my next articles which will go on floor soon.

With Thanks and Regards
Arshad Ali
Microsoft India

My Blog - http://arshadali.blogspot.com/[/url]

Arshad Ali-556241 Say Hey Kid Points: 706 More actions · Answer 6

Hi Mark Horninger, Jeffrey Irish, GSquared,

Thanks a lot for your encouraging words, it will definitely work as motivation forces in my future articles.

About intellisence feature, yes it works with SQL Server 2008 only. I will do onething, I will raise a ticket/request to Microsoft SQL Server Product Team and may be upcoming service pack or new version will have a fix for it. Let's hope. 🙂

About next article in this series, I have almost completed it and giving final touch to it. Soon I will be sending it to the editor and further it will take few days in review and editing. Anyway soon it will reach to you guys, so I insist you guys to have a look on them and give me back your valueable comments.

Thanks again for your time in reading it.

With Thanks and Regards
Arshad Ali
Microsoft India

My Blog - http://arshadali.blogspot.com/[/url]

RichB SSCrazy Eights Points: 9651 More actions · Answer 7

Is your grouping sets example not just a rework of rollup?

Is the power of this not in the way it can handle non hierarchical (ie group by col1, col2, col3 with rollup = hierarchical) sets?

eg

create table #people(fname sysname, lname sysname, location sysname)

insert #people

select 'rich', 'b', 'here'

union all

select 'bob', 'b', 'here'

union all

select 'rich', 'm', 'there'

union all

select 'rich', 'c', 'there'

union all

select 'jane', 'c', 'here'

select

coalesce(lname, fname, location, 'Total'),

fname,

lname,

location,

count(*)

from #people

group by grouping sets((fname), (lname, location), location, lname, ())

order by 1

roger_os SSC Eights! Points: 831 More actions · Answer 8

roger_os

SSC Eights!

Points: 831

March 5, 2010 at 2:27 am

#1129042

Nice article, thankyou

ianp SSC Veteran Points: 284 More actions · Answer 9

In general, even though SQL2008 has been out for some time now, well done on a useful recap for those considering a move. I believe the SQL editor probably requires an article in its self. The syntax checking, highlighting of balanced parentheses, underlining of invalid objects, auto complete (not entirely a fan it takes far too long to update if you have a new object). Also unlike for instance the Redgate product, there is no formatting of SQL statements. Otherwise there is little reason for not adopting 2008 over 2005. I understand that the database binaries are the same, so 2008 is far more like a tidy up of the things that were in 2005 but were only part realised implimentations. What this really means is that 2005 to 2008 is far less fraught than 2000 to 2005.

Keep up the good work Ian, web site: agency software, http://www.ava.co.uk/, blog http://creamteadiet.blogspot.com/

Trey Staker SSCarpal Tunnel Points: 4796 More actions · Answer 10

Nice article. It was well written and enjoyed it. I see that this is a reprint. Did you ever publish the 2nd part?

I didn't know about the GROUPING SETS and am excited to see this as an enhancement. Most of these enhancements are things I always felt should of been in the product/language. I've been using 2008 for awhile but I haven't had the need for it yet. I really could of used this in 2005 in a previous job.

I like the pretty light blue decorations around your code snippets. I think though I'd rather have the snippets copy and paste friendly.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

Thomas LeBlanc SSCrazy Eights Points: 8085 More actions · Answer 11

Excellent post, looking foward to the other parts

ThomasLL

Thomas LeBlanc, MVP Data Platform Consultant

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Nice article. Thanks for taking the time to write it and share it with us.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

TomThomson SSC Guru Points: 104773 More actions · Answer 13

Very useful article. I've been using SQL2008 for a while, but hadn't picked up on some of the simple changes - maybe now I'll remember some of them. I'm looking forward to the successor articles.

Tom

irshadmohideen SSC Enthusiast Points: 161 More actions · Answer 14

irshadmohideen

SSC Enthusiast

Points: 161

March 10, 2010 at 5:05 am

#1131268

Coool. Precisely describing the point. Thank you.