October 28, 2010 at 6:07 pm
Craig Farrell (10/28/2010)
Think this would be a bit much as my signature?
CREATE TRIGGER trg_Celko ON vw_SSC_PostList FOR AFTER INSERTAS
-- Go read the documents, inline comments are for sissies.
IF EXISTS (SELECT * FROM inserted WHERE [Name] = 'CELKO')
BEGIN
UPDATE table_SSC_attributes
SET intHappiness = intHappiness + 1
Where RowNumber = ISNULL( NULL, 1)
END
GO
Did I break enough ISO standards? I'm sure I missed a few.
I think you need a bit column in there to really set him off. I have no idea why he hates bit columns so much and since he never explains himself, I'll likely never know.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
October 28, 2010 at 7:26 pm
Stefan Krzywicki (10/28/2010)
Craig Farrell (10/28/2010)
Think this would be a bit much as my signature?
CREATE TRIGGER trg_Celko ON vw_SSC_PostList FOR AFTER INSERTAS
-- Go read the documents, inline comments are for sissies.
IF EXISTS (SELECT * FROM inserted WHERE [Name] = 'CELKO')
BEGIN
UPDATE table_SSC_attributes
SET intHappiness = intHappiness + 1
Where RowNumber = ISNULL( NULL, 1)
END
GO
Did I break enough ISO standards? I'm sure I missed a few.
I think you need a bit column in there to really set him off. I have no idea why he hates bit columns so much and since he never explains himself, I'll likely never know.
You need something that uses IDENTITY as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 28, 2010 at 7:40 pm
Jeff Moden (10/28/2010)
Brandie Tarvin (10/28/2010)
FYI: Aside from Demo-titis, Grant had a pretty good presentation. Wish I could go to PASS and see the full 90 minute one.Now I'm obsessing about my latest project, trying to tweak it. Odd thing is, I removed an ORDER BY clause, thinking it'd make a SORT go away (which it did) but it increased the query time by 1 second. ???
Anyway, having fun with the new stuff I learned listening to Grant. Really really really recommend his session for PASS-going folks.
Ok... how'd I miss that? Where did you get the notification that such a thing was going to happen?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 28, 2010 at 8:58 pm
Jack Corbett (10/28/2010)
GilaMonster (10/28/2010)
Grant Fritchey (10/28/2010)
Yeah, I stumble over the word "statistics" badly enough without having a mouth full of sugar.At least you didn't take on an hour and a half presentation solely on statistics. First time I did my stats presentation (to the local usergroup) I managed to mangle the word at least half the times I tried saying it.
I have trouble with that word sometimes.
I lead Bible studies quite often and I avoid anything in Thessalonians because I can't say it.
It's not in Thessalonians, but say "Sibboleth" 😉
Just tell 'em it's in Greek
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 28, 2010 at 9:00 pm
Alvin Ramard (10/28/2010)
WayneS (10/28/2010)
Craig - I see you came through on your threat of a ST avatar! Seems appropriate, especially in the thread with Joes latest rant.I guess a new Star Trek avatar for our offensive responder could be Q.
I was thinking about making a comment in here about who made him God. Look at his initials: J.C. :w00t:
Jack Corbett? Jon Crawford? :-P:-D
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 28, 2010 at 9:10 pm
Two comments, which are completely separate, and I should probably post separately, but I'm lazy 😀
1 - we're all talking too much about Celko, and frankly, you're better than that. You guys are very helpful to a lot of people, try not to waste your energy on telling him off, which while entertaining, makes things too heated. I liked the replies about 'ignore him, sorry about that, don't be scared off', and the help you provided was great, somebody is really going to learn something. Just think positive, and try to ignore or advise to ignore rather than refute, because I have a sneaking suspicion it isn't going to change his behavior one bit.
2 - Curious if anybody is active in their local ACM chapters? Seems like the ones around here are struggling, (note the desparate cry for help here) but the org as a whole seems valuable and active. Trying to get a feel for if it's an organization worth investing some time in or not.
Sincerely,
The OTHER j.c.
(No, the OTHER OTHER j.c.)
(fine, whatever, it's jcrawf02)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 28, 2010 at 9:35 pm
Interesting find as I work on the Larger Default Trace article. I created a template from it in Profiler and it doesn't include the Plan Guide Unsuccessful Event.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 28, 2010 at 10:09 pm
jcrawf02 (10/28/2010)
Two comments, which are completely separate, and I should probably post separately, but I'm lazy 😀1 - we're all talking too much about Celko, and frankly, you're better than that. You guys are very helpful to a lot of people, try not to waste your energy on telling him off, which while entertaining, makes things too heated. I liked the replies about 'ignore him, sorry about that, don't be scared off', and the help you provided was great, somebody is really going to learn something. Just think positive, and try to ignore or advise to ignore rather than refute, because I have a sneaking suspicion it isn't going to change his behavior one bit.
2 - Curious if anybody is active in their local ACM chapters? Seems like the ones around here are struggling, (note the desparate cry for help here) but the org as a whole seems valuable and active. Trying to get a feel for if it's an organization worth investing some time in or not.
Sincerely,
The OTHER j.c.
(No, the OTHER OTHER j.c.)
(fine, whatever, it's jcrawf02)
Although I agree with you on ignoring Celko and simply telling the OP to ignore him, that doesn't really send him a mesasage. Hopefully, and I'm sure it is just wishful thinking, he will start to realize that the SQL Server community at large is tired of his online persona and that he really needs to change if he wants to be a relevent part of this community and to be taken seriously.
October 28, 2010 at 10:34 pm
Lynn Pettis (10/28/2010)
jcrawf02 (10/28/2010)
Two comments, which are completely separate, and I should probably post separately, but I'm lazy 😀1 - we're all talking too much about Celko, and frankly, you're better than that. You guys are very helpful to a lot of people, try not to waste your energy on telling him off, which while entertaining, makes things too heated. I liked the replies about 'ignore him, sorry about that, don't be scared off', and the help you provided was great, somebody is really going to learn something. Just think positive, and try to ignore or advise to ignore rather than refute, because I have a sneaking suspicion it isn't going to change his behavior one bit.
2 - Curious if anybody is active in their local ACM chapters? Seems like the ones around here are struggling, (note the desparate cry for help here) but the org as a whole seems valuable and active. Trying to get a feel for if it's an organization worth investing some time in or not.
Sincerely,
The OTHER j.c.
(No, the OTHER OTHER j.c.)
(fine, whatever, it's jcrawf02)
Although I agree with you on ignoring Celko and simply telling the OP to ignore him, that doesn't really send him a mesasage. Hopefully, and I'm sure it is just wishful thinking, he will start to realize that the SQL Server community at large is tired of his online persona and that he really needs to change if he wants to be a relevent part of this community and to be taken seriously.
Well said Lynn. Hopefully, it's not wishful thinking.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 29, 2010 at 2:24 am
Alvin Ramard (10/28/2010)
WayneS (10/28/2010)
Craig - I see you came through on your threat of a ST avatar! Seems appropriate, especially in the thread with Joes latest rant.I guess a new Star Trek avatar for our offensive responder could be Q.
I was thinking about making a comment in here about who made him God. Look at his initials: J.C. :w00t:
Careful Alvin, there are more people around here with those initials than you might expect :hehe:
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 29, 2010 at 5:18 am
Luke L (10/28/2010)
Grant Fritchey (10/28/2010)
Brandie Tarvin (10/28/2010)
Waving to Grant across the interwebs while listening to him present on execution plans!Oh, that was you? Sorry I didn't wave back. Man, I need to work on my examples a bit.
I hate talking to a wall for presentations.
Any chance the presentation was recorded. I couldn't watch at work today 🙁
Thanks,
-Luke.
You know, I don't know. I don't think so, but you should check with Pragmatic Works.
"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 29, 2010 at 5:20 am
GilaMonster (10/28/2010)
Grant Fritchey (10/28/2010)
Yeah, I stumble over the word "statistics" badly enough without having a mouth full of sugar.At least you didn't take on an hour and a half presentation solely on statistics. First time I did my stats presentation (to the local usergroup) I managed to mangle the word at least half the times I tried saying it.
Ha! But let's face it, talking about execution plans you probably talk about stats almost as much as you do when talking about stats.
"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 29, 2010 at 5:26 am
Jeff Moden (10/28/2010)
Brandie Tarvin (10/28/2010)
FYI: Aside from Demo-titis, Grant had a pretty good presentation. Wish I could go to PASS and see the full 90 minute one.Now I'm obsessing about my latest project, trying to tweak it. Odd thing is, I removed an ORDER BY clause, thinking it'd make a SORT go away (which it did) but it increased the query time by 1 second. ???
Anyway, having fun with the new stuff I learned listening to Grant. Really really really recommend his session for PASS-going folks.
Ok... how'd I miss that? Where did you get the notification that such a thing was going to happen?
Wha....? You don't read my blog? Daily? I'm crushed.
Sorry, couldn't help it.
You know, I don't know. I don't generally get emails from PragmaticWorks on this stuff, so I wasn't aware of what they were doing until they asked me to take part. They have training running a lot, twice this week.
"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 29, 2010 at 6:32 am
Grant Fritchey (10/29/2010)
Luke L (10/28/2010)
Grant Fritchey (10/28/2010)
Brandie Tarvin (10/28/2010)
Waving to Grant across the interwebs while listening to him present on execution plans!Oh, that was you? Sorry I didn't wave back. Man, I need to work on my examples a bit.
I hate talking to a wall for presentations.
Any chance the presentation was recorded. I couldn't watch at work today 🙁
Thanks,
-Luke.
You know, I don't know. I don't think so, but you should check with Pragmatic Works.
For those interested, it looks like the recording is coming soon as per http://www.pragmaticworks.com/Resources/webinars/Default.aspx
also looks like there is some other interesting stuff out there already posted.
October 29, 2010 at 6:46 am
Hey everyone. I'm positive one or more of you can help this guy
"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
Viewing 15 posts - 21,016 through 21,030 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply