|
|
|
SSC-Addicted
 
Group: General Forum Members
Last Login: Monday, September 14, 2009 5:22 AM
Points: 437,
Visits: 918
|
|
Hmmm
I vaguely remember the furor about VB "dot Nyet" invalidating all code written in previous VB versions...
Walking up to Frankenstein's castle with torches and pitchforks ...
|
|
|
|
|
SSCrazy Eights
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 11:21 AM
Points: 9,104,
Visits: 8,528
|
|
J (3/19/2008)
Hmmm
I vaguely remember the furor about VB "dot Nyet" invalidating all code written in previous VB versions...
Walking up to Frankenstein's castle with torches and pitchforks ...
Yes, I was the guy in the front with the pitchfork and the Rocket Launcher.
-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Today @ 12:50 AM
Points: 918,
Visits: 738
|
|
Hi Jeff, and I thought you were an American. Americans only eats meatloaf or not?
 Manie Verster
Computer Programmer
Johannesburg
South Africa
Life is about choices.... I choose to be happy today
My Blog
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 20,183,
Visits: 13,714
|
|
Manie Verster (3/20/2008)
Hi Jeff, and I thought you were an American. Americans only eats meatloaf or not?
Heh... depends... will meatloaf hold up in a slingshot? ;)
--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".
"Data isn't the only thing that's supposed to have Integrity."
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 9:15 PM
Points: 6,189,
Visits: 8,927
|
|
Jeff Moden (3/20/2008)
Manie Verster (3/20/2008)
Hi Jeff, and I thought you were an American. Americans only eats meatloaf or not? Heh... depends... will meatloaf hold up in a slingshot? ;)
My Great-Aunt Wilma's would....Course - she wasn't much of a cook....:)
How well it holds up in a slingshot is inversely proportional to how well it holds up with mashed potatoes and gravy....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, February 25, 2010 10:51 AM
Points: 6,
Visits: 119
|
|
Great article Jeff. Another developer had a stored procedure that was run daily to create a report. The stored procedure took 3 hours to run. The SP had multiple "death by SQL" updates in it. After rewriting the code, the sp now takes 2 minutes (max) to run.
I was a beginner at SQL when I ran across this article, and I have used this technique in many queries.
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 20,183,
Visits: 13,714
|
|
Matt (2/1/2009)
Great article Jeff. Another developer had a stored procedure that was run daily to create a report. The stored procedure took 3 hours to run. The SP had multiple "death by SQL" updates in it. After rewriting the code, the sp now takes 2 minutes (max) to run.
I was a beginner at SQL when I ran across this article, and I have used this technique in many queries.
That's awesome, Matt. There's no better compliment an author can have than having someone come back with such a success story. Thank you for taking the time to post it. I very happy to have been able to have helped through the article.
--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".
"Data isn't the only thing that's supposed to have Integrity."
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
|
|
|
|
