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 Friday, March 5, 2010 8:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 11:58 AM
Points: 1,142, Visits: 2,689
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
Post #877669
Posted Friday, March 5, 2010 9:06 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:39 PM
Points: 3,118, Visits: 792
Excellent post, looking foward to the other parts

ThomasLL


Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #877722
Posted Saturday, March 6, 2010 11:12 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:50 PM
Points: 17,807, Visits: 15,727
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
Post #878269
Posted Sunday, March 7, 2010 2:07 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:12 AM
Points: 7,791, Visits: 9,545
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
Post #878360
Posted Wednesday, March 10, 2010 5:05 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 22, 2013 6:33 AM
Points: 57, Visits: 110
Coool. Precisely describing the point. Thank you.
Post #880090
Posted Thursday, March 18, 2010 8:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 18, 2014 7:55 AM
Points: 22, Visits: 72
Hello! Thank you for interesting article!
GROUPING SETS were new for me. I've tried an example using GROUPING SETS and UNION ALL. I've just noticed that the ordering of returning rows is different.
Also the number of logical reads is less when using GROUPING SETS.

Post #885534
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse