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 2 of 2

««1 2

SQL Server 2008 T-SQL Enhancements Part - I

Rate Topic

Display Mode

Topic Options

Author

Message

Trey Staker

Posted Friday, March 05, 2010 8:12 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:52 PM
Points: 1,379, Visits: 2,626

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

Thomas LeBlanc

Posted Friday, March 05, 2010 9:06 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 20, 2013 3:33 PM
Points: 2,705, Visits: 717

Excellent post, looking foward to the other parts

ThomasLL

Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/

Post #877722

SQLRNNR

Posted Saturday, March 06, 2010 11:12 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

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 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #878269

L' Eomot Inversé

Posted Sunday, March 07, 2010 2:07 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:06 AM
Points: 7,104, Visits: 7,169

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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #878360

irshadmohideen

Posted Wednesday, March 10, 2010 5:05 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 8:32 AM
Points: 57, Visits: 108

Coool. Precisely describing the point. Thank you.

Post #880090

galina.maystrenko

Posted Thursday, March 18, 2010 8:07 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, March 03, 2011 7:24 AM
Points: 22, Visits: 62

Hello! Thank you for interesting article! Smile

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 »

16 posts, Page 2 of 2

««1 2

Permissions