T-SQL: Why “It Depends”

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 Bob Hovious » T-SQL: Why “It Depends”

102 posts, Page 1 of 11

1 2 3 4 5 »»»

T-SQL: Why “It Depends”

Rate Topic

Display Mode

Topic Options

Author

Message

The Dixie Flatline

Posted Monday, March 15, 2010 9:38 PM

Hall of Fame

Group: General Forum Members
Last Login: Monday, May 20, 2013 2:02 PM
Points: 3,788, Visits: 5,543

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

TheSQLGuru

Posted Monday, March 15, 2010 9:39 PM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:54 PM
Points: 3,578, Visits: 5,120

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

Florian Reischl

Posted Tuesday, March 16, 2010 2:54 AM

SSCrazy

Group: General Forum Members
Last Login: Sunday, November 04, 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

Matt Whitfield

Posted Tuesday, March 16, 2010 3:00 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, February 15, 2013 7:29 AM
Points: 509, Visits: 718

Bob

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

Atlantis Interactive - SQL Server Tools
My blog
Why I wrote a sql query analyzer clone

Post #883605

Paul White

Posted Tuesday, March 16, 2010 3:33 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:02 AM
Points: 10,989, Visits: 10,534

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

Jack Corbett

Posted Tuesday, March 16, 2010 6:03 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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

CELKO

Posted Tuesday, March 16, 2010 6:05 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 11:11 AM
Points: 1,945, Visits: 2,782

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

Grant Fritchey

Posted Tuesday, March 16, 2010 6:11 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:55 AM
Points: 13,381, Visits: 25,165

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

The Dixie Flatline

Posted Tuesday, March 16, 2010 6:17 AM

Hall of Fame

Group: General Forum Members
Last Login: Monday, May 20, 2013 2:02 PM
Points: 3,788, Visits: 5,543

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. Wink

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills

Post #883694

BlackHawk-17

Posted Tuesday, March 16, 2010 6:24 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 17, 2013 6:50 AM
Points: 41, Visits: 384

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 »

102 posts, Page 1 of 11

1 2 3 4 5 »»»

Permissions