July 15, 2010 at 12:04 pm
I agree with Alvin there. Especially since we are a small Island. I was lucky to get Jimmy May and Joe Chang.
Our User Group was started last year august. So far I have done just 2 presentations. The members have done the rest of the presentations. This month I will do the presentation, next month the other DBA in my office will give one and in September I am aiming for the first Live meeting.
-Roy
July 15, 2010 at 12:10 pm
CirquedeSQLeil (7/15/2010)
With another one coming up very quickly 😉
Where? When? I don't know what you're talking about.... again
"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
July 15, 2010 at 12:12 pm
Jack Corbett (7/15/2010)
My thoughts on Live Meeting is that it is great to use to broadcast your chapter meeting for others to join, but, in my experience, having a remote presenter is a last resort, unless you can get an A-lister to present remotely. In Orlando we are struggling with attendance and remote speakers don't seem to draw anyone. We only have 2-3 remote attendees when we do broadcast. I actually wonder if it's worth the hassles it can bring.I have done a couple of remote live meetings as a speaker and I find it MUCH harder than an in-person meeting. I'm not going to volunteer to do it anymore, but will do it if asked.
Ditto. I've done a bunch of online presentations and while I'll continue to (hoping for the Fall 24HOP), I don't think I'm as effective and I certainly don't enjoy them.
"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
July 15, 2010 at 12:12 pm
Grant Fritchey (7/15/2010)
CirquedeSQLeil (7/15/2010)
With another one coming up very quickly 😉
Where? When? I don't know what you're talking about.... again
You don't remember volunteering? 😀
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]
July 15, 2010 at 12:37 pm
I think we've shot past denial and are moving in the direction of outright insanity on this. I'm still reading it because it's like watching a car crash.
"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
July 15, 2010 at 12:44 pm
Grant Fritchey (7/15/2010)
I think we've shot past denial and are moving in the direction of outright insanity on this. I'm still reading it because it's like watching a car crash.
That one still?
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
July 15, 2010 at 12:55 pm
Yes, the OP still doesn't understand what the other posters are saying. I'm watching too. It has been a learning experience though as people are trying to explain to him how to do correct error handling and that TRY...CATCH works EXACTLY as it is supposed to and as it was designed to. But yes, I'm expecting a car crash any moment now.
-- Kit
July 15, 2010 at 12:56 pm
Grant Fritchey (7/15/2010)
I think we've shot past denial and are moving in the direction of outright insanity on this. I'm still reading it because it's like watching a car crash.
I hadn't been following it since people posted good explanations. This reminds me quite a bit of engineers who think they've found proof that Einstein was wrong, though they clearly don't understand the physics and will spend days arguing that everyone else doesn't understand and only their brilliance can see the truth. There's a lot of them out there and they can be funny to read on occasion.
--------------------------------------
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
July 15, 2010 at 1:03 pm
Grant Fritchey (7/15/2010)
I think we've shot past denial and are moving in the direction of outright insanity on this. I'm still reading it because it's like watching a car crash.
But Grant.... the OP is in the arena... his face marred by dust and sweat and blood.... 😉
Having been on the losing side of many, many arguments I feel competent to make the statement that when EVERYBODY else disagrees with a position, intellectual honesty requires that the proponent have the humility to stop and question that position. The OP in this case still hasn't accepted the fact that he is apparently the only one who has generated a large body of code that is threatened by TRY/CATCH.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 15, 2010 at 1:06 pm
That is a funny thread actually. I can see the frustration building, and it is tempting to jump in. IMHO, the original code is just shitty coding, and a bit of an edge case for the issue with TRY..CATCH changing behavior. It does appear to be by design, because, well, that's shitty error handling for coding.
Anyone that wants to use ON ERROR RESUME NEXT as an example or error handling (avoding?) has dropped a few notches in my estimation.
July 15, 2010 at 1:14 pm
declare @DoNothing int
begin try
select 1/0 as result
end try
begin catch
set @DoNothing = 1
end catch
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 15, 2010 at 1:18 pm
Steve Jones - Editor (7/15/2010)
ON ERROR RESUME NEXT
My stomach just wretched reading that.
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
July 15, 2010 at 1:25 pm
Tom.Thomson (7/15/2010)
Paul White NZ (7/14/2010)
Jeff Moden (7/14/2010)
What "philosophy" are you good folks referring to?Presumably something around people who won't take the time to 'fix' a problem 'properly'.
As it happens, I think the comments on that thread have missed the point a bit.
A column with the IDENTITY property is not the only valid design.
It looks to me like the guy is implementing a Sequence Table.
I'd put it a bit stronger than that: there are cases where using a sequence table is appropriate and a column with the IDENTITY property is not a valid design (because it will not work).
I've never run into such a problem with IDENTITY even when "dual mastering" w/bidirectional replication was the order of the day. Can you good folks give me an example of when IDENTITY will not work?
And, no... I'm not trying to be a smart guy here or challenge anyone's answer... I've never run into such a problem and I'd really like to kinow where such problem would occur. Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 15, 2010 at 1:34 pm
CirquedeSQLeil (7/15/2010)
Steve Jones - Editor (7/15/2010)
ON ERROR RESUME NEXTMy stomach just wretched reading that.
lol I just went back to the start of that thread, and bteraberry made me laugh - "Common knowledge that an error handling mechanism handles errors? That's too obvious to possibly be true.
Good luck with stuff. "
I don't know squat, but I think it should be pretty obvious that using new functionality can change how you have to handle existing code.
but what do I know...
---------------------------------------------------------
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."
July 15, 2010 at 1:53 pm
Jeff Moden (7/15/2010)
I'd put it a bit stronger than that: there are cases where using a sequence table is appropriate and a column with the IDENTITY property is not a valid design (because it will not work).
I've never run into such a problem with IDENTITY even when "dual mastering" w/bidirectional replication was the order of the day. Can you good folks give me an example of when IDENTITY will not work?
And, no... I'm not trying to be a smart guy here or challenge anyone's answer... I've never run into such a problem and I'd really like to kinow where such problem would occur. Thanks.[/quote]
Ditto. Only slightly wracked my brain, but I haven't seen a place where the sequence works by identity doesn't. I have had slowness with very high volume inserts, but not sure a sequence fixes that. Have run out of identities, same thing.
Client side wanting the generation works better with GUID.
I could see that complex PKs, alphanumerics might want a sequence instead, but straight number generation? What am I missing?
Viewing 15 posts - 16,411 through 16,425 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply