SQL Server 2008 T-SQL Enhancements Part

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Arshad Ali » SQL Server 2008 T-SQL Enhancements Part - I

16 posts, Page 1 of 2

1 2 »»

SQL Server 2008 T-SQL Enhancements Part - I

Rate Topic

Display Mode

Topic Options

Author

Message

Arshad Ali-556241

Posted Wednesday, January 21, 2009 9:30 PM

Valued Member

Group: General Forum Members
Last Login: Friday, June 07, 2013 1:23 PM
Points: 64, Visits: 182

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/

Post #641356

sanjarani

Posted Thursday, January 22, 2009 1:51 AM

Valued Member

Group: General Forum Members
Last Login: Friday, June 14, 2013 6:07 AM
Points: 57, Visits: 162

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

Post #641422

SuperDBA-207096

Posted Thursday, January 22, 2009 6:24 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 02, 2013 12:15 PM
Points: 1,443, Visits: 711

Well done! Looking forward to part 2...

Post #641619

Jeffrey Irish

Posted Thursday, January 22, 2009 6:45 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 30, 2013 9:54 AM
Points: 143, Visits: 999

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 w00t

Post #641655

GSquared

Posted Thursday, January 22, 2009 6:58 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:45 PM
Points: 15,442, Visits: 9,572

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

Post #641671

Arshad Ali-556241

Posted Thursday, January 22, 2009 10:46 AM

Valued Member

Group: General Forum Members
Last Login: Friday, June 07, 2013 1:23 PM
Points: 64, Visits: 182

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/

Post #641888

Arshad Ali-556241

Posted Thursday, January 22, 2009 11:44 AM

Valued Member

Group: General Forum Members
Last Login: Friday, June 07, 2013 1:23 PM
Points: 64, Visits: 182

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/

Post #641932

RichB

Posted Thursday, August 27, 2009 4:21 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:24 AM
Points: 1,028, Visits: 759

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

Post #778141

roger_os

Posted Friday, March 05, 2010 2:27 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 10:30 AM
Points: 49, Visits: 529

Nice article, thankyou

Post #877477

ianp

Posted Friday, March 05, 2010 5:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 4:33 AM
Points: 9, Visits: 41

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/

Post #877552

« Prev Topic | Next Topic »

16 posts, Page 1 of 2

1 2 »»

Permissions