Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Server 2008 T-SQL Enhancements Part - I Expand / Collapse
Author
Message
Posted Wednesday, January 21, 2009 9:30 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 6:25 AM
Points: 64, Visits: 189
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
Posted Thursday, January 22, 2009 1:51 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 63, Visits: 209
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
Posted Thursday, January 22, 2009 6:24 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, Visits: 711
Well done! Looking forward to part 2...
Post #641619
Posted Thursday, January 22, 2009 6:45 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 6:25 AM
Points: 149, Visits: 1,023
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
Post #641655
Posted Thursday, January 22, 2009 6:58 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Posted Thursday, January 22, 2009 10:46 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 6:25 AM
Points: 64, Visits: 189
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
Posted Thursday, January 22, 2009 11:44 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 6:25 AM
Points: 64, Visits: 189
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
Posted Thursday, August 27, 2009 4:21 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:07 AM
Points: 1,060, Visits: 876
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
Posted Friday, March 5, 2010 2:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 2, 2014 10:06 AM
Points: 49, Visits: 540
Nice article, thankyou
Post #877477
Posted Friday, March 5, 2010 5:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 24, 2013 9:40 AM
Points: 9, Visits: 42
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 »

Add to briefcase 12»»

Permissions Expand / Collapse