April 26, 2009 at 8:54 am
Bob Hovious (4/26/2009)
It would be the same. Do you think if I went back and edited my post to remove the code, the Thread might forgive me?
I think you should bring a sacrifice. Maybe a link to something with stupid information? Do you know any source of an article which explains how cool cursors are?
And... my assumption about the dashboard was wrong.... one day I will learn not to type while not completely caffeinated.
I know what you mean... Just look at my avatar 😛
Greets
Flo
Edited: Typo
April 26, 2009 at 8:55 am
Bob Hovious (4/26/2009)
The rows column would be the same.Do you think if I went back and edited my post to remove the code, the Thread might forgive me?
And... my assumption about the dashboard was wrong.... one day I will learn not to type while not completely caffeinated. 😛
1st: The thread never forgets! So removing the code won't help.
2nd: I think you got it backwards when it comes to typing while caffeinated. NEVER type while NOT caffeinated!!
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 26, 2009 at 9:06 am
Morning, Alvin 🙂
NEVER type while NOT caffeinated!!
Isn't that what I said? Must... drink... more ... coffee....
Isn't it beautiful outside this weekend? I'm about to close the lid on my laptop and go commune with nature. This is too pretty a Sunday to waste.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 26, 2009 at 9:10 am
Bob Hovious (4/26/2009)
Morning, Alvin 🙂Isn't it beautiful outside this weekend?
I'm about to close the lid on my laptop and go commune with nature.
This is too pretty a Sunday to waste.
Yeah, it's beautiful alright. I had a number of things to do on the laptop last night. I was out on the balcony from 7:30 PM to 11:00 PM. It's too nice to waste. I just need to figure out how I'll do that.
Enjoy the day.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 26, 2009 at 10:07 am
Bob Hovious (4/26/2009)
Isn't it beautiful outside this weekend? I'm about to close the lid on my laptop and go commune with nature. This is too pretty a Sunday to waste.
Glad you're having nice weather. It's been freezing here the last week or so. If this continues we're in for a very cold winter this year.
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
April 26, 2009 at 10:15 am
GilaMonster (4/26/2009)
Bob Hovious (4/26/2009)
Isn't it beautiful outside this weekend? I'm about to close the lid on my laptop and go commune with nature. This is too pretty a Sunday to waste.Glad you're having nice weather. It's been freezing here the last week or so. If this continues we're in for a very cold winter this year.
To forget your weather for some minutes:
http://www.youtube.com/watch?v=AI94uYkvrYU
🙂
April 26, 2009 at 1:12 pm
(copied from my blog):
For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from my hospistal bed, which it turns out is very difficult, so please forgive any errors.
I gave my SQL Injection speech two weeks ago (which I think that I did blog about). Then part one of my series "There must be fifteen ways to lose your cursors" was published over at SqlServerCentral.com to a firestorm of response (over 300 posts so far). Then I gave speech on the same topic to Philly.net code camp to very favoarable reviews (so far anyway).
Then last monday I had to go to the ER for intense stomach pains that were diagnosed a Gallstones. Tuesday I go to see a Surgeon about getting my Gall bladder removed. He schedules me for surgery on May 4 and puts me on an "Absolutely no Fat or Glycol" diet, meaning fruits, vegetables, water and skim milk only. Joy!
Thursday I have to leave work with stomach pains so bad I almost don't make it home. Then I have my younger son, Chris drive me to the ER again. They say that is is another Gallstone attack but as an added bonus I now have pancreaitis too.
They say they cannot remove the gall bladder until the pancreaitis goes away, but it is taking its own sweet time. So on monday they will do some surgical procedure to relieve the pancreaitis and assuming that goes OK remove my gall bladder on tuesday.
Of course part 2 of mu series comes out on Monday, so I guess that Jeff and Lynn and Gus and the others will have to field the questions.
Hopefully, I will be back soon ...
Not trawling for sympathy on anything folks, just wanted to make sure that you knew what the story was...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 26, 2009 at 2:42 pm
Bob Hovious (4/26/2009)
Okay, so I'm still catching up on this thread, and this quote is from mid-Feb.
Wayne:
You need to admit that you need help.
I'd like to invite you to a meeting of Threadaholics Anonymous.
If you need a sponsor, I'll be happy to volunteer.
With counseling, support, and perhaps appropriate medication, you can break this terrible addiction.
I'm pulling for you, man.
Sincerely,
Bob
I NEED help. In a big way!!! I AM ADDICTED to THE THREAD.
Man, I've learned sooo much about all of you'll in the first 2500 posts... I just got to finish it.
IF I can catch up, maybe I won't need that medication.
Aren't the meetings at the bar, with a brew of some kind? So, what kind of sponsor would you be?
Okay, maybe I better start with the meds and get on the couch for the counseling. But, I think I'll get my support RIGHT HERE!:hehe:
Oh, BTW. How do you change the setting to read more that 10 posts on a page? I saw it once, but can't find it anywhere.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 26, 2009 at 2:47 pm
Lynn,
Does this[/url] look anything like your desert?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 26, 2009 at 3:01 pm
[font="Verdana"]The worst "novel solution" for a report I have ever seen was a canned standard report delivered as part of a banking solution to a small bank I did some contracting work for a couple of years ago. Note the word "small" in front of bank. This solution was apparently intended as suitable for much larger sites!
What the report would do is this:
1. Run a SQL query to determine the number of rows in the result
2. Run a SQL query to determine the number of columns in the result (even though this was fixed)
3. For every individual cell in the result set, run a SQL query to determine the result for that cell.
So for a report that was 10 columns by 10 rows, that's 102 different queries. And I'm sure you can imagine that the quality of the individual queries was somewhat, er... poor.
I wrote a separate report that replaced all of that with 1 SQL query. It took a report that ran for hours down to less than a minute.
[/font]
April 26, 2009 at 3:07 pm
RBarryYoung (4/26/2009)
For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from my hospistal bed, which it turns out is very difficult, so please forgive any errors.
[font="Verdana"]I did say you were a brave, brave man for writing an article on the evils of cursors...
Get well soon!
[/font]
April 26, 2009 at 3:16 pm
RBarryYoung (4/26/2009)
For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from my hospistal bed, which it turns out is very difficult, so please forgive any errors.
Ow!. Not good.
You take things easy, we'll handle the barbarian hordes.
:hehe:
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
April 26, 2009 at 3:22 pm
RBarryYoung (4/26/2009)
(copied from my blog):For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from my hospistal bed, which it turns out is very difficult, so please forgive any errors.
I gave my SQL Injection speech two weeks ago (which I think that I did blog about). Then part one of my series "There must be fifteen ways to lose your cursors" was published over at SqlServerCentral.com to a firestorm of response (over 300 posts so far). Then I gave speech on the same topic to Philly.net code camp to very favoarable reviews (so far anyway).
Then last monday I had to go to the ER for intense stomach pains that were diagnosed a Gallstones. Tuesday I go to see a Surgeon about getting my Gall bladder removed. He schedules me for surgery on May 4 and puts me on an "Absolutely no Fat or Glycol" diet, meaning fruits, vegetables, water and skim milk only. Joy!
Thursday I have to leave work with stomach pains so bad I almost don't make it home. Then I have my younger son, Chris drive me to the ER again. They say that is is another Gallstone attack but as an added bonus I now have pancreaitis too.
They say they cannot remove the gall bladder until the pancreaitis goes away, but it is taking its own sweet time. So on monday they will do some surgical procedure to relieve the pancreaitis and assuming that goes OK remove my gall bladder on tuesday.
Of course part 2 of mu series comes out on Monday, so I guess that Jeff and Lynn and Gus and the others will have to field the questions.
Hopefully, I will be back soon ...
Not trawling for sympathy on anything folks, just wanted to make sure that you knew what the story was...
Trawling for sympathy or not, you will be in my thoughts and prayers. We'll do our best to cover for you when part 2 comes out. You just take care and get better.
April 26, 2009 at 6:44 pm
Been there, Barry. You get LOTs of sympathy and well-wishes. The good news is that it will all be over quickly. I mean that in the most positive way.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 26, 2009 at 6:56 pm
I hope you get well soon Barry. Take Care.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 15 posts - 3,691 through 3,705 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply