October 17, 2010 at 11:09 pm
Jeff Moden (10/17/2010)
WayneS (10/14/2010)
"Don't try this at home... we're professionals!"Heh... I have the perfect SQL subject for that... Quirky Update. 😀
Or what I actually labelled as 'Don't try this at home' on my last blog post. Kill the SQL process and open one of the data files in a hex editor.
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
October 18, 2010 at 1:03 am
HowardW (10/15/2010)
ALZDBA (10/15/2010)
btw not so long ago, I had a bird strike whilest riding my bike. It hit me on top of my helmet, right above the vizor. It was a blackbird that crossed my path. I was lucky that it didn't hit my during a curve, or I would for sure have ended up on the side. It was a hell of a noise and a shock to the neck for me (sencible for a couple of hours). The bird didn't make it.For my helmet is was a spot of bird chalk.
In fairness to the bird, it sounds like you struck it rather than the other way round!
I'm just glad I won :w00t:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 18, 2010 at 2:11 am
CirquedeSQLeil (10/15/2010)
...He - I got run off the road last night by a woman driving an SUV...
That's the school run for you.
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
October 18, 2010 at 4:47 am
WayneS (10/16/2010)
I just love these!"I've got this task, needs to be done in an insert trigger".
So, I give the code for doing so.
"Now, can you incorporated it into my already existing, cursor-ridden insert trigger?"
Just shoot me... better yet, shoot the OP.
Edit: and, upon further reading, scope has changed from being for company/sub-accounts to being for college/students. Homework?
I just love how he suddenly solves the problem after you guys start asking the homework question.
October 18, 2010 at 4:56 am
Brandie Tarvin (10/18/2010)
WayneS (10/16/2010)
I just love these!"I've got this task, needs to be done in an insert trigger".
So, I give the code for doing so.
"Now, can you incorporated it into my already existing, cursor-ridden insert trigger?"
Just shoot me... better yet, shoot the OP.
Edit: and, upon further reading, scope has changed from being for company/sub-accounts to being for college/students. Homework?
I just love how he suddenly solves the problem after you guys start asking the homework question.
aspardeshi (10/16/2010)
...I am sorry dear...
Grrrrowl this makes me so cross, it's almost always associated with a big pile of porky pies. Why can't people be honest? They'd still get help, and they'd probably learn more, it happens.
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
October 18, 2010 at 5:05 am
WayneS (10/16/2010)
I just love these!"I've got this task, needs to be done in an insert trigger".
So, I give the code for doing so.
"Now, can you incorporated it into my already existing, cursor-ridden insert trigger?"
Just shoot me... better yet, shoot the OP.
Edit: and, upon further reading, scope has changed from being for company/sub-accounts to being for college/students. Homework?
I'm not so sure. Looks to me like this is someone used to programming with Oracle Sequences, and where cursors are very different animals. He just needs a Sequence Table, no?
Also the way I read it, he provided a simplified example rather than the full procedure. I think you guys got it wrong on this one.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
October 18, 2010 at 5:40 am
May I suggest that everyone just ignores that? I don't think we need another flaming thread here.
Sorry, I just replied! :blush:
Not encountered Lennie before
October 18, 2010 at 5:52 am
I love polite respondents. Heck, I love people who actually respond once you give them advice. It's nice to know when advice doesn't go down the rabbit hole and who knows where else.
EDIT: This has nothing to do with Lennie.
October 18, 2010 at 6:33 am
Lynn Pettis (10/17/2010)
Sorry, but I couldn't resist responding. We'll see how he takes my critizism (sp ?).
Oh hell, I posted. If he goes off on it or whatever, I'm not going to argue.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 18, 2010 at 7:16 am
Jeff Moden (10/17/2010)
Steve Jones - SSC Editor (10/14/2010)
The green value, if there is one, comes not from you getting ebooks, but from 1000s of people doing this. Less paper, less energy, less storage, not to mention less trucking, heating, cooling, etc. That being said, not sure this is the best way to remain green, especially as you have to charge it up.Doesn't bode well for lots of jobs, and I hope that some level of "bookstore" still remains in the future.
I wonder what the total carbon footprint of manufacturing such a device is? Add the carbon footprint of recycling it at end of life.
To get the true green value of ereaders, you also have to factor in how many books did not get printed. Good luck with that number.
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]
October 18, 2010 at 7:38 am
October 18, 2010 at 7:56 am
Gianluca Sartori (10/18/2010)
Plz, do my homework!
Well, I was wrong.
When I see things like "plz" and "How can i write the Sp PLZ let me know" I tend to think it's homework.
-- Gianluca Sartori
October 18, 2010 at 8:00 am
Gianluca Sartori (10/18/2010)
Gianluca Sartori (10/18/2010)
Plz, do my homework!Well, I was wrong.
When I see things like "plz" and "How can i write the Sp PLZ let me know" I tend to think it's homework.
I can haz cheezburger?
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
October 18, 2010 at 8:15 am
Ray K (10/18/2010)
I can haz cheezburger?
Noes! U cantz haz cheezburger!
But u can haz lazanya.
October 18, 2010 at 8:17 am
Gianluca Sartori (10/18/2010)
Gianluca Sartori (10/18/2010)
Plz, do my homework!Well, I was wrong.
When I see things like "plz" and "How can i write the Sp PLZ let me know" I tend to think it's homework.
USE Forums;
GO
SELECT Answers
FROM dbo.SQLServerCentral
WHERE Examples IS NOT NULL;
GO
Viewing 15 posts - 20,521 through 20,535 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply