Are the posted questions getting worse?
-
Lynn Pettis (4/29/2010)
Agreed, cursors have their place, there just is just a lot of places where they are inappropriate.IMO, the best place for cursors is in other peoples code... when they are paying you $100+/hr to fix their performance problems! :w00t: 😀
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
GabyYYZ (4/29/2010)
Lynn Pettis (4/29/2010)
WayneS (4/29/2010)
Makes you wonder... Here, the OP (with 1800+ points) can't pull apart two simple nested cursors with 5 subqueries in that last nest into some reasonable code. And here, he seems to know what he's talking about. :w00t:And he considers what you wrote "complex"?????? :blink:
If you wanted to be evil, you could wrap Wayne's elegant code in a cursor, lob the grenade into a forum, and watch everyone duck for cover. That being said, I have come around...in that rare case, every so once in a while, when there is NO set based solution, a cursor will do. (there...I said it :w00t: )
elegant????? Don't know 'bout that!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
WayneS (4/29/2010)
Lynn Pettis (4/29/2010)
Agreed, cursors have their place, there just is just a lot of places where they are inappropriate.IMO, the best place for cursors is in other peoples code... when they are paying you $100+/hr to fix their performance problems! :w00t: 😀
LOL - that is a very good place for them, if I am the one getting paid.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
Agreed, cursors have their place
I'm really surprised to hear you say that, Lynn.
Oh wait.... I thought that said cursING. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
The Dixie Flatline (4/29/2010)
Agreed, cursors have their place
I'm really surprised to hear you say that, Lynn.
Oh wait.... I thought that said cursING. 😀
And all this time I thought we were talking about cursors (those who curse).:crying:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
Drats - funny
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
The Dixie Flatline (4/29/2010)
Lol.
I wish I was a photoshop guru, it would be fun to change the "Curses" to "Cursors". lol
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum -
lmu92 (4/29/2010)
@Lynn: May I take a break at the TITD? I'd even walk the hippo, if needed...I need to take a break and relax before I cannot resit anymore to post something I have in mind regarding this post ...
Go for it! I know where you are coming from. Individual PM'ed me to look at another thread where I was easily able to help him, for the most part. Stopped dealing with the thread when he wanted to move the asp.net app into tsql.
-
lmu92 (4/29/2010)
Lynn:See, the hippo is doing just fine!
It has lost its tutu.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
CirquedeSQLeil (4/29/2010)
It has lost its tutu.
... but it can sing now!
-
lmu92 (4/29/2010)
Lynn:See, the hippo is doing just fine!
Awesome!
By the way, did you see the latest post?
-
Lynn Pettis (4/29/2010)
lmu92 (4/29/2010)
Lynn:See, the hippo is doing just fine!
Awesome!
By the way, did you see the latest post?
You guys have more patience than I. That series would have torqued me off pretty good.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 14,941 through 14,955 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply