August 22, 2012 at 10:24 am
Stefan Krzywicki (8/22/2012)
Brandie Tarvin (8/22/2012)
Allow me to correct myself.ChrisM@Work (8/22/2012)
Brandie Tarvin (8/22/2012)
President Bill Clinton once said "Define intercourse" ... or maybe "define sex"... in an interview about a sex scandal he was involved in with a White House intern.Why should it ever have been a scandal to anyone but his wife and kid(s)?
POTUS got caught with his pants down while he was in office. The idea of POTUS spending time in the Oval Office having sex with an intern rather than leading the country annoyed a lot of people. I know there are other countries where this is business as usual, but we in the States like to pretend our leaders have some semblence of loyalty to their spouses.
It go so bad that senate impeached President Clinton for covering up the issue ("I did not have sex with Monica Lewinsky!") ... I think the vote passed. I don't quite remember. And while the senate and house politicians were busy decrying his behavior, media outlets were busy offering rewards to anyone who could prove his most vocal critics were themselves having extra-marital affairs. And a whole bunch of card houses came a tumbling down.
It did not pass. The vote passed the house (where the leaders of the investigation were having affairs themselves), which is why they had the Senate trial, but not the Senate, which is why he didn't have to step down from office.
It only came to light because the Republicans in the House spent $500 million on a fishing expedition to find anything they could that Clinton may have done wrong. I don't know about you, but I'm a lot more upset that they spent $500,000,000 of the taxpayers money on an attempt at a power grab than that Clinton had a consentual affair.
The numbers I heard and can find are much smaller than that. Though they are still large ($70 million over 7 years). When put into perspective, it really isn't that much for government spending when an 11 day trip to Africa, for Clinton in 98, cost $5.2 million per day.
In both cases, I am sure there is a better way to spend the money.
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
August 22, 2012 at 12:50 pm
Brandie Tarvin (8/22/2012)
GilaMonster (8/22/2012)
jcrawf02 (8/22/2012)
GilaMonster (8/22/2012)
BrainDonor (8/22/2012)
GilaMonster (8/22/2012)
Nitpicking I can take, this is getting well beyond that.
I have to say Gail that it was a fascinating thread up to a point, and your examples and explanations were interesting.
But it has descended a bit into "Is this a five minute argument or the full half hour" type of level and I gave up before you did.
I pretty much decided enough was enough when the definitions of 'before' and 'after' were brought into question.
You're arguing with Bill Clinton?
<woosh>
That would be the sound of what I assume to be a joke going right over my head.
Bill Clinton once said "Define intercourse" ... or maybe "define sex"... in an interview about a sex scandal he was involved in with a White House intern.
I think it was something along the line of "It depends on what your definition of "is" is."
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 22, 2012 at 12:54 pm
WayneS (8/22/2012)
I think it was something along the line of "It depends on what your definition of "is" is."
Yeah, that was always suspect. Asking for definitions of congress/court on term definition is not an uncommon event, as what they're describing isn't always common usage and can provide loopholes. Asking for a definition of The, An, A... errr, wanna try me again on that?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 22, 2012 at 1:04 pm
Hey Jack - why are you dissing all of your Threadizen buddies?:-D:-D:-D
http://wiseman-wiseguy.blogspot.com/2012/08/im-speaking-at-sqlsaturday-156providence.html
4 Threadizens doing 8 presentations, and you're not seeing any of them?:w00t:
And what's up with only seeing presentations where the presenter's first name starts with "A"?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 22, 2012 at 6:46 pm
ChrisM@Work (8/22/2012)
Stefan Krzywicki (8/22/2012)
Brandie Tarvin (8/22/2012)
Allow me to correct myself.ChrisM@Work (8/22/2012)
Brandie Tarvin (8/22/2012)
President Bill Clinton once said "Define intercourse" ... or maybe "define sex"... in an interview about a sex scandal he was involved in with a White House intern.Why should it ever have been a scandal to anyone but his wife and kid(s)?
POTUS got caught with his pants down while he was in office. The idea of POTUS spending time in the Oval Office having sex with an intern rather than leading the country annoyed a lot of people. I know there are other countries where this is business as usual, but we in the States like to pretend our leaders have some semblence of loyalty to their spouses.
It go so bad that senate impeached President Clinton for covering up the issue ("I did not have sex with Monica Lewinsky!") ... I think the vote passed. I don't quite remember. And while the senate and house politicians were busy decrying his behavior, media outlets were busy offering rewards to anyone who could prove his most vocal critics were themselves having extra-marital affairs. And a whole bunch of card houses came a tumbling down.
It did not pass. The vote passed the house (where the leaders of the investigation were having affairs themselves), which is why they had the Senate trial, but not the Senate, which is why he didn't have to step down from office.
It only came to light because the Republicans in the House spent $500 million on a fishing expedition to find anything they could that Clinton may have done wrong. I don't know about you, but I'm a lot more upset that they spent $500,000,000 of the taxpayers money on an attempt at a power grab than that Clinton had a consentual affair.
That's almost as much as Dwain C spends on a fishing expedition, and he has to put them back too.
Hehe. Yes, Clinton through his back too, to the wolves!
The only thing that irks me about the whole affair was Clinton's choice of concubine. Surely the President of the US could have pumped his manhood on a more attractive intern's skirt.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
August 22, 2012 at 8:00 pm
dwain.c (8/21/2012)
I have written some WHILE loops but they don't count.
Why not? If you're While loops process just one row at a time, they're just as bad as a static fire-hose cursor.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2012 at 8:03 pm
GilaMonster (8/21/2012)
<soapbox>Cursors are tools. Use them where they work, don't use them where they don't. Statements like 'you should never use a <whatever>' are just shortsighted
If we count while loops as cursors, I wrote about 10 since saturday
I agree with the that. Of course, you have my curiosity up a notch. What did the While Loops do?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2012 at 8:09 pm
dwain.c (8/21/2012)
IIf I rewrite this SP to use 1 or 0 CURSORs, will the SQL-verse acknowledge this reduction in my career CURSOR usage and lower my career total CURSOR count?
If the new code is actually faster and a less resource intensive (the two will, many times, walk hand in hand), then not only will you get points back for removing the cursors, you actually get extra points for actually going back to fix them. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2012 at 8:34 pm
Jeff Moden (8/22/2012)
dwain.c (8/21/2012)
I have written some WHILE loops but they don't count.Why not? If you're While loops process just one row at a time, they're just as bad as a static fire-hose cursor.
If I resort to a WHILE loop, it is generally a set-based iteration.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
August 22, 2012 at 8:36 pm
Jeff Moden (8/22/2012)
dwain.c (8/21/2012)
IIf I rewrite this SP to use 1 or 0 CURSORs, will the SQL-verse acknowledge this reduction in my career CURSOR usage and lower my career total CURSOR count?
If the new code is actually faster and a less resource intensive (the two will, many times, walk hand in hand), then not only will you get points back for removing the cursors, you actually get extra points for actually going back to fix them. 😀
Thank you for the positive feedback!
I need a little moral support to gain the initiative to actually do it. As I mentioned, that SP is quite complex and a major pain to test. Removing even the inner CURSOR loop will require all the skill I can muster. Skill which I must thank this board for helping me to develop I might add.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
August 22, 2012 at 11:53 pm
dwain.c (8/22/2012)
Jeff Moden (8/22/2012)
dwain.c (8/21/2012)
IIf I rewrite this SP to use 1 or 0 CURSORs, will the SQL-verse acknowledge this reduction in my career CURSOR usage and lower my career total CURSOR count?
If the new code is actually faster and a less resource intensive (the two will, many times, walk hand in hand), then not only will you get points back for removing the cursors, you actually get extra points for actually going back to fix them. 😀
Thank you for the positive feedback!
I need a little moral support to gain the initiative to actually do it. As I mentioned, that SP is quite complex and a major pain to test. Removing even the inner CURSOR loop will require all the skill I can muster. Skill which I must thank this board for helping me to develop I might add.
An effort which must now be delayed I must add because some bonehead deleted a bunch of active transactions from a database I support and now I must try to figure out how to restore them.
Grrr! :angry:
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
August 23, 2012 at 2:14 am
Jeff Moden (8/22/2012)
GilaMonster (8/21/2012)
<soapbox>Cursors are tools. Use them where they work, don't use them where they don't. Statements like 'you should never use a <whatever>' are just shortsighted
If we count while loops as cursors, I wrote about 10 since saturday
I agree with the that. Of course, you have my curiosity up a notch. What did the While Loops do?
Data archiving. Can't use partition swaps because it's standard edition.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2012 at 8:33 am
WayneS (8/22/2012)
I think it was something along the line of "It depends on what your definition of "is" is."
And that too!
August 23, 2012 at 8:36 am
I am out of grapes. @=( (so sad)
But I have a bag of Tootsie Rolls...
Hmmm.
August 23, 2012 at 8:40 am
Brandie Tarvin (8/23/2012)
... Tootsie Rolls...
Are we back on Clinton??
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Viewing 15 posts - 37,606 through 37,620 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply