November 10, 2011 at 9:39 am
SQL Kiwi (11/9/2011)
Roy Ernest (11/9/2011)
Darn, I was submitting an article here and as soon as I uploaded an image, it removed all the previous text I entered. That was painful. Anyone else seen this behavior here?The SSC article editor?
Don't. Get. Me. Started.
:crazy:
Me. Either.
It's slightly better over the last month as we've revamped the control, but it's still slightly flaky. I back up everything before I paste anything in.
November 10, 2011 at 9:43 am
GilaMonster (11/9/2011)
SQLRNNR (11/9/2011)
GilaMonster (11/9/2011)
Roy Ernest (11/9/2011)
Darn, I was submitting an article here and as soon as I uploaded an image, it removed all the previous text I entered. That was painful. Anyone else seen this behavior here?I don't think I've ever used the article editor.
Do you just send the word doc to steve?
Yes, but I don't know if he wants to encourage that.
I don't. It causes the workflow to get disrupted. I don't mind the few people that have been doing it for years, but please not anyone new. Worst case, upload the Word doc in the article editor and leave a note at the top of the text to use that.
November 10, 2011 at 9:46 am
GilaMonster (11/9/2011)
Roy Ernest (11/9/2011)
Steve will rip my article into pieces for sure. I am not a writer. Therefore I expect to have problems with the Steve Editor as well. His comments are very good though. I like his reviewing process. Each time I learn a bit more about writing. 🙂Never worked with Tony Davis have you? Steve's positively gentle in comparison. I sent something to Tony yesterday and between him and Phil Factor I expect it to come back almost completely rewritten.
Tony is rough, a little too rough, IMHO. He edits traditionally to meet some form. I try to keep your voice, just make sure the flow and focus are there.
November 10, 2011 at 9:47 am
Kiara (11/10/2011)
ChrisM@Work (11/10/2011)
Kiara (11/10/2011)
Stefan Krzywicki (11/10/2011)
Kiara (11/10/2011)
In case y'all haven't seen this.. http://thedailywtf.com/Articles/The-Query-of-Despair.aspx...I'm sure we've all had days like that...
I inherited a query like that back in 99. It was a 500 line query with lots of unions. I got it down to a 50 line query with no unions. It ran better too. 🙂
I'm trying to make some time to go after a rather nasty trigger we've got here with a recursive CTE in the middle of it. Ugly, ugly, ugly. I'm still reverse-engineering the business logic, though - I'm not going to touch it until I actually understand what it's trying to accomplish. But it sits out there, taunting me, and keeps making it closer and closer to the top of the "must tackle now" list...
Hi Ki
How about posting up the rCTE bit?
Chris, after that last mess I posted (in which I expertly demonstrated what happens when you get buried too deeply into the middle of a problem and forget to come up for air) you want to play with more? 😀
Once I figure out what it's trying to accomplish, if you really are that bored, I will, but I haven't started playing with it yet, so I can't build a postable version of it yet in my sandbox.
Too busy to get bored Ki, only three weeks left on this gig and tons to do - but I have a special interest in rCTE's.
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
November 10, 2011 at 9:48 am
Ninja's_RGR'us (11/10/2011)
We're waiting on an OR & date. He's on top of the list. He needs an open heart surgury to fix 5 different problems. That's 10 hours on the table with the heart stopped when everything goes according to plan.Let's just say nobody's thrilled about that at the moment.
That sucks. Thoughts and prayers and hope things go smoothly.
November 10, 2011 at 9:50 am
Steve Jones - SSC Editor (11/10/2011)
Ninja's_RGR'us (11/10/2011)
We're waiting on an OR & date. He's on top of the list. He needs an open heart surgury to fix 5 different problems. That's 10 hours on the table with the heart stopped when everything goes according to plan.Let's just say nobody's thrilled about that at the moment.
That sucks. Thoughts and prayers and hope things go smoothly.
tx.
November 10, 2011 at 9:52 am
Ninja's_RGR'us (11/10/2011)
....We're waiting on an OR & date. He's on top of the list. He needs an open heart surgury to fix 5 different problems. That's 10 hours on the table with the heart stopped when everything goes according to plan.
Let's just say nobody's thrilled about that at the moment.
Definitely prayers and all that with you and your father right now.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 10, 2011 at 9:56 am
GSquared (11/10/2011)
Ninja's_RGR'us (11/10/2011)
....We're waiting on an OR & date. He's on top of the list. He needs an open heart surgury to fix 5 different problems. That's 10 hours on the table with the heart stopped when everything goes according to plan.
Let's just say nobody's thrilled about that at the moment.
Definitely prayers and all that with you and your father right now.
tx
November 10, 2011 at 10:48 am
Ninja's_RGR'us (11/10/2011)
Got another puzzle for you guys and possibly another bug (row_number, partition by & cte).http://www.sqlservercentral.com/Forums/Topic1203532-266-1.aspx
It was a known bug, confirmed by our own walking wiki from NZ.
November 10, 2011 at 10:53 am
Ninja's_RGR'us (11/10/2011)
--------------------------------------------------------------------------------
We're waiting on an OR & date. He's on top of the list. He needs an open heart surgery to fix 5 different problems. That's 10 hours on the table with the heart stopped when everything goes according to plan.
Let's just say nobody's thrilled about that at the moment.
For what comfort this may bring, four years ago I under went open heart surgery to replace portions of 3 viens, needless to say the surgery was successful. May your Dad's surgery be as successful as mine.
May God bless your Dad and watch over him and your family.
November 10, 2011 at 10:57 am
ChrisM@Work (11/10/2011)
Kiara (11/10/2011)
ChrisM@Work (11/10/2011)
Kiara (11/10/2011)
Stefan Krzywicki (11/10/2011)
Kiara (11/10/2011)
In case y'all haven't seen this.. http://thedailywtf.com/Articles/The-Query-of-Despair.aspx...I'm sure we've all had days like that...
I inherited a query like that back in 99. It was a 500 line query with lots of unions. I got it down to a 50 line query with no unions. It ran better too. 🙂
I'm trying to make some time to go after a rather nasty trigger we've got here with a recursive CTE in the middle of it. Ugly, ugly, ugly. I'm still reverse-engineering the business logic, though - I'm not going to touch it until I actually understand what it's trying to accomplish. But it sits out there, taunting me, and keeps making it closer and closer to the top of the "must tackle now" list...
Hi Ki
How about posting up the rCTE bit?
Chris, after that last mess I posted (in which I expertly demonstrated what happens when you get buried too deeply into the middle of a problem and forget to come up for air) you want to play with more? 😀
Once I figure out what it's trying to accomplish, if you really are that bored, I will, but I haven't started playing with it yet, so I can't build a postable version of it yet in my sandbox.
Too busy to get bored Ki, only three weeks left on this gig and tons to do - but I have a special interest in rCTE's.
Fair enough!
-Ki
November 10, 2011 at 10:58 am
bitbucket-25253 (11/10/2011)
Ninja's_RGR'us (11/10/2011)
--------------------------------------------------------------------------------
We're waiting on an OR & date. He's on top of the list. He needs an open heart surgery to fix 5 different problems. That's 10 hours on the table with the heart stopped when everything goes according to plan.
Let's just say nobody's thrilled about that at the moment.
For what comfort this may bring, four years ago I under went open heart surgery to replace portions of 3 viens, needless to say the surgery was successful. May your Dad's surgery be as successful as mine.
May God bless your Dad and watch over him and your family.
tx
November 11, 2011 at 7:14 am
The first part of my 3 part series of articles on SQL Audit will be be out on 28th of this month. I am right now trying to upload the second part. Half way thru uploading using the editor (Not Steve). I save after every step so that I wont loose it all. 😀
-Roy
November 11, 2011 at 7:28 am
EEEK! I just sold another story. Happy happy.
Now I have to write more.
November 11, 2011 at 7:41 am
Brandie Tarvin (11/11/2011)
EEEK! I just sold another story. Happy happy.Now I have to write more.
Congrats Brandie. Wonderful job. 🙂 You can stop working as a DBA and be a full time writer now. 😀
-Roy
Viewing 15 posts - 31,621 through 31,635 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply