April 11, 2011 at 4:57 pm
Jeff Moden (4/11/2011)
GilaMonster (4/11/2011)
After 30 minutes of arguing about set theory, equivalence of statements, testing requirements and development methodology I gave up and discarded the changes.
That's why I try to let the code do the talking. I setup a test and defy them to find a fault by comparing the result sets.
I fought a battle like this a long time ago where the result set was 100% identical and the perfomance was 1000% better. The code owner was still beligerant and the argument went something illogical like on the 3rd blue monday of the 5th month the result set will be different. Then it led to this is the way we've always done things and changing may have different results in the production enviornment eventhough the dev enviorment was a copy of the production enviornment.
Some people no matter how wrong they may be will not accept the fact that they are wrong or that there is a better way of doing things.
I did win the argument in the long run because the code owner proved to be incompetent over in time and was let go. I worked there for another 2 years until a better opportunity came by. My code years later still runs on that system.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
April 11, 2011 at 5:17 pm
Trey Staker (4/11/2011)
Some people no matter how wrong they may be will not accept the fact that they are wrong or that there is a better way of doing things.I did win the argument in the long run because the code owner proved to be incompetent over in time and was let go.
I guess I'm lucky... they HAVE to listen to me. Of course, the ropes I tie them up with help a great deal. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
April 11, 2011 at 6:06 pm
Jeff Moden (4/11/2011)
WayneS (4/11/2011)
Jeff, I never did get this. Did you miss my previous post to send it on?Apparently so. I'll send it out when I get home tonight. Thanks, Wayne.
Jeff - sent you my comments on your proposed article via email at 8 PM.
Thanks for giving me the privilege of reading it before it was published, I appreciate that.
April 11, 2011 at 7:13 pm
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
Complaints about the lizard? Why on earth? ::confused::
-Ki
April 11, 2011 at 7:14 pm
Craig Farrell (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.:blink: Whaaa?
Good to see the dead hopeless romantic virgin isn't forgotten. I never could decide if killing him off made the show better or worse.
I never forgave JMS for killing him off.
-Ki
April 11, 2011 at 7:52 pm
GilaMonster (4/11/2011)
Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted the PMs. Complaining that it's ugly, that no sensible person would have a venomous lizard as an avatar, that I should delete the 'insect' picture.
Can you send me the picture? I'll make it my avatar.:-D
Trying to leech off my work are we? 😀 Let's see how many we can confuse...
http://www.cryptomundo.com/cryptozoo-news/gila-invade/
Doubt the photo's originally from that site, it's found in tonnes of places on the net, no indication of the origin.
It'll be fun. I want to see if people complain to me about it.
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
April 11, 2011 at 8:01 pm
Hey Jack...
Just wanted to say that I really like your new avatar. Much better looking that what you had up previously... :-P:-D
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 11, 2011 at 9:33 pm
Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted the PMs. Complaining that it's ugly, that no sensible person would have a venomous lizard as an avatar, that I should delete the 'insect' picture.
Can you send me the picture? I'll make it my avatar.:-D
Trying to leech off my work are we? 😀 Let's see how many we can confuse...
http://www.cryptomundo.com/cryptozoo-news/gila-invade/
Doubt the photo's originally from that site, it's found in tonnes of places on the net, no indication of the origin.
It'll be fun. I want to see if people complain to me about it.
Haha.
I saw Gail quoted and the Gila avatar to the left and for a split second wondered why Gail quoted herself. But that didn't last long.
Nice one.
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
April 11, 2011 at 11:38 pm
Trey Staker (4/11/2011)
Jeff Moden (4/11/2011)
GilaMonster (4/11/2011)
After 30 minutes of arguing about set theory, equivalence of statements, testing requirements and development methodology I gave up and discarded the changes.
That's why I try to let the code do the talking. I setup a test and defy them to find a fault by comparing the result sets.
I fought a battle like this a long time ago where the result set was 100% identical and the perfomance was 1000% better. The code owner was still beligerant and the argument went something illogical like on the 3rd blue monday of the 5th month the result set will be different. Then it led to this is the way we've always done things and changing may have different results in the production enviornment eventhough the dev enviorment was a copy of the production enviornment.
Some people no matter how wrong they may be will not accept the fact that they are wrong or that there is a better way of doing things.
That's the kind of argument I had with the person in question, though his entire argument was 'There is no way that you can change this without breaking it'. Semi-technical business analyst (who frequently tells the developers how to do their job). Plus I'm 'temporary labour' and hence incompetent to do anything that might affect the 'critical business processes'.
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 12, 2011 at 5:06 am
Stefan Krzywicki (4/11/2011)
So you'd suggest LOCAL STATIC FAST_FORWARD?EDIT: Never Mind, Can't do FAST_FORWARD and STATIC on the same Cursor.
That looks as if my memory is playing up again :blush:.
But I'm not going to say "it's too long since I last declared a cursor" 😀 , that can never be too long.
So STATIC FORWARD_ONLY READ_ONLY it has to be.
Tom
April 12, 2011 at 5:52 am
CirquedeSQLeil (4/11/2011)
Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted the PMs. Complaining that it's ugly, that no sensible person would have a venomous lizard as an avatar, that I should delete the 'insect' picture.
Can you send me the picture? I'll make it my avatar.:-D
Trying to leech off my work are we? 😀 Let's see how many we can confuse...
http://www.cryptomundo.com/cryptozoo-news/gila-invade/
Doubt the photo's originally from that site, it's found in tonnes of places on the net, no indication of the origin.
It'll be fun. I want to see if people complain to me about it.
Haha.
I saw Gail quoted and the Gila avatar to the left and for a split second wondered why Gail quoted herself. But that didn't last long.
Nice one.
Darned ... I was just planing on wearing a SSC T-shirt with all avatars of my favorite forum members during the next SQLPass...
Guess who was on it :crazy:
At least 2 should be altered 😉 ... No .... I'll just skip the member names :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
April 12, 2011 at 5:58 am
I think this cursor suits Stefan's needs best.
DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING
STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN
FOR
SELECT Superpower
FROM dbo.JusticeLeague
WHERE SupType = 'Lightning'
OPEN OMG_NotAnotherCursor
FETCH LAST FROM OMG_NotAnotherCursor
INTO @WhatsThisVariableForAgain
WHILE @@FETCH_STATUS = 'headdesk'
BEGIN
SET @YetAnotherVariable = DBCC Timewarp()
FETCH LAST FROM OMG_NotAnotherCursor
INTO @WhatsThisVariableForAgain
END
THROWOUT OMG_NotAnotherCursor
DEALLOCATE CursorAbilities
GO
Having had a little bit of fun with this (and probably making a horrible joke that no one thinks is funny), I will admit cursors do have their place. I've actually found, in some circumstances, cursors are faster than WHILE Loops. But, admittedly, that's part in due to database design and part in due to what I was trying to accomplish.
April 12, 2011 at 7:14 am
Brandie Tarvin (4/12/2011)
I think this cursor suits Stefan's needs best.
DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING
STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN
FOR
SELECT Superpower
FROM dbo.JusticeLeague
WHERE SupType = 'Lightning'
OPEN OMG_NotAnotherCursor
FETCH LAST FROM OMG_NotAnotherCursor
INTO @WhatsThisVariableForAgain
WHILE @@FETCH_STATUS = 'headdesk'
BEGIN
SET @YetAnotherVariable = DBCC Timewarp()
FETCH LAST FROM OMG_NotAnotherCursor
INTO @WhatsThisVariableForAgain
END
THROWOUT OMG_NotAnotherCursor
DEALLOCATE CursorAbilities
GO
Having had a little bit of fun with this (and probably making a horrible joke that no one thinks is funny), I will admit cursors do have their place. I've actually found, in some circumstances, cursors are faster than WHILE Loops. But, admittedly, that's part in due to database design and part in due to what I was trying to accomplish.
rofl! Brandie, you just made my day. I'm going to be laughing about this through conference IO and airport wait states...
-Ki
April 12, 2011 at 7:21 am
Brandie Tarvin (4/12/2011)
I think this cursor suits Stefan's needs best.
DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING
STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN
FOR
SELECT Superpower
FROM dbo.JusticeLeague
WHERE SupType = 'Lightning'
OPEN OMG_NotAnotherCursor
FETCH LAST FROM OMG_NotAnotherCursor
INTO @WhatsThisVariableForAgain
WHILE @@FETCH_STATUS = 'headdesk'
BEGIN
SET @YetAnotherVariable = DBCC Timewarp()
FETCH LAST FROM OMG_NotAnotherCursor
INTO @WhatsThisVariableForAgain
END
THROWOUT OMG_NotAnotherCursor
DEALLOCATE CursorAbilities
GO
Having had a little bit of fun with this (and probably making a horrible joke that no one thinks is funny), I will admit cursors do have their place. I've actually found, in some circumstances, cursors are faster than WHILE Loops. But, admittedly, that's part in due to database design and part in due to what I was trying to accomplish.
I liked it. Static was most recently part of the Teen Titans, but has quit the team to go get his powers back (long story). He's apparently getting his own series again soon.
As for the cursor, it is mainly used to pass variables to a series of stored procedures. Annoying, but I'll get rid of it eventually. I haven't even had a chance (been allowed) to tackle all the non-Sargeable statements. Things like WHERE Convert(varchar(20), ThisDate, 106) = Convert(varchar(20), GetDate(), 106)
--------------------------------------
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
April 12, 2011 at 7:27 am
I see SanDroid has started digging again...
--------------------------------------
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
Viewing 15 posts - 25,606 through 25,620 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply