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 12345»»»

T-SQL: Why “It Depends” Expand / Collapse
Author
Message
Posted Monday, March 15, 2010 9:38 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 4,013, Visits: 6,098
Comments posted to this topic are about the item T-SQL: Why “It Depends”

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #883517
Posted Monday, March 15, 2010 9:39 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:07 PM
Points: 4,356, Visits: 6,189
Nicely done. Lots of people just don't understand that data volumes can REALLY alter performance of existing code, and can also make the optimizer take different approaches to queries that can dramatically affect performance as well - even in a NEGATIVE manner.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #883519
Posted Tuesday, March 16, 2010 2:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 2,087, Visits: 3,932
Hi Bob

I'm a little bit in a hurry at the moment, so only a very short feedback:

Great job!

Thanks
Flo



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #883601
Posted Tuesday, March 16, 2010 3:00 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, July 22, 2013 11:59 AM
Points: 509, Visits: 719
Bob

Really good article - like it. Now where's the +1 button on this forum?


Atlantis Interactive - SQL Server Tools
My blog
Why I wrote a sql query analyzer clone
Post #883605
Posted Tuesday, March 16, 2010 3:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:59 AM
Points: 11,194, Visits: 11,166
Excellent stuff Bob. The first article on SSC I have really enjoyed reading for quite some time. Well done!

It is a shame about some of the code formatting problems (missing spaces, mostly). I am sure those errors were not in the article you submitted.
The other layout thing is that the "Retrieving Detail of Last Sale(s) Of All Products" section is duplicated, and the section inserting the sample data is missing.
Hopefully these things can be corrected quickly, to avoid detracting from the otherwise excellent-ness of the thing.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #883619
Posted Tuesday, March 16, 2010 6:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:38 PM
Points: 11,314, Visits: 13,101
Nice job Bob, very thorough as would be expected. Glad to see yo back in the saddle so to speak. I know the article was probably written awhile ago, but you've been missed on the forums.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #883684
Posted Tuesday, March 16, 2010 6:05 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:38 AM
Points: 1,945, Visits: 3,004
Excellent piece of work!

I wonder how "MAX(sale_date) OVER (PARTITION BY product_nbr)" would do?


Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
Post #883687
Posted Tuesday, March 16, 2010 6:11 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 5:59 PM
Points: 15,735, Visits: 28,141
Excellent article. You made several points and made them well, not the least illustrating why "it depends" is such a common statement.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #883693
Posted Tuesday, March 16, 2010 6:17 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 4,013, Visits: 6,098
Thanks, guys.

Your comments did me more good this morning than my first cup of coffee (which I have yet to pour).

Flo: I'm pleased you even found time to read this. I remember how busy you are this year.

Matt: Forgive my absence from ASK SSC. Paul could tell you that I've barely been participating in The Thread for the past few months. However I still wear my "Enlightened" badge proudly.

Paul: I will read over the article and see if Steve can make the changes. It's also been pointed out to me that a script to generate the sample data table really should have been included. Thanks, as always, for keeping me straight.

Jack: You're right. This was written back in November. Things have been hectic since. When is the next SQL Saturday in Orlando? I need a vacation.

Joe: We've never met, but I sat in on your presentation at the PASS Summit. I suspect the MAX() technique will do well in the time trials.

Grant: Thanks as well. I'm busting through your book on execution plans right now and can't wait to crack open the one on performance tuning.

Jeff: Simply thanks. I've told you before at length how much I owe you. It's good not to be savaged with a pork chop first thing in the morning.


__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #883694
Posted Tuesday, March 16, 2010 6:24 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 7:34 AM
Points: 42, Visits: 398
Excellent.

Clear. Concise. To the point.

Great examples and presentation. All you needed to add was the infamous developer quote: "It worked faster in test."

Thanks for sharing!
Post #883701
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse