SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


T-SQL: Why “It Depends”


T-SQL: Why “It Depends”

Author
Message
The Dixie Flatline
The Dixie Flatline
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24439 Visits: 6913
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? Everybody look what's going down. -- Stephen Stills
TheSQLGuru
TheSQLGuru
SSC Guru
SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)

Group: General Forum Members
Points: 65505 Visits: 8838
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 on googles mail service
Florian Reischl
Florian Reischl
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17417 Visits: 3934
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
Matt Whitfield
Matt Whitfield
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4221 Visits: 719
Bob

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

Atlantis Interactive - SQL Server Tools
My blog
Why I wrote a sql query analyzer clone
Paul White
Paul White
SSC Guru
SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)SSC Guru (68K reputation)

Group: General Forum Members
Points: 68354 Visits: 11399
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
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
Jack Corbett
  Jack Corbett
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88215 Visits: 14997
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (185K reputation)SSC Guru (185K reputation)SSC Guru (185K reputation)SSC Guru (185K reputation)SSC Guru (185K reputation)SSC Guru (185K reputation)SSC Guru (185K reputation)SSC Guru (185K reputation)

Group: General Forum Members
Points: 185535 Visits: 33307
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
The Dixie Flatline
The Dixie Flatline
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24439 Visits: 6913
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? Everybody look what's going down. -- Stephen Stills
BlackHawk-17
BlackHawk-17
SSC Veteran
SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)

Group: General Forum Members
Points: 226 Visits: 401
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!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search