SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2008 T-SQL Enhancements Part - I


SQL Server 2008 T-SQL Enhancements Part - I

Author
Message
Arshad Ali-556241
Arshad Ali-556241
SSC Veteran
SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)

Group: General Forum Members
Points: 270 Visits: 194
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/
sanjarani
sanjarani
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 303
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
SuperDBA-207096
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3983 Visits: 711
Well done! Looking forward to part 2...
Jeffrey Irish
Jeffrey Irish
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1478 Visits: 1145
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
GSquared
GSquared
SSC Guru
SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)SSC Guru (106K reputation)

Group: General Forum Members
Points: 106077 Visits: 9730
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
Arshad Ali-556241
SSC Veteran
SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)

Group: General Forum Members
Points: 270 Visits: 194
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. Smile

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/
Arshad Ali-556241
Arshad Ali-556241
SSC Veteran
SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)

Group: General Forum Members
Points: 270 Visits: 194
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. Smile

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/
RichB
RichB
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4680 Visits: 1083
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
roger_os
Old Hand
Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)

Group: General Forum Members
Points: 361 Visits: 568
Nice article, thankyou
ianp
ianp
SSC Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 Visits: 43
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/



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search