December 5, 2019 at 12:59 am
ZZartin wrote:Jeff Moden wrote:p.s. I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies". It there's not a well documented ticket to support the urgency, it doesn't get done. While that sounds like I'm being nothing more than an Ahole, I'm not. It supports audits and a whole bunch of other things and I've gotten management support on that. It's actually written into our SOPs on the company WIKI.
I've kind of adopted the policy of, does it require changing production data? that's a ticket. Will it take me 30 minutes or less to get the data you want/help you and i like you? no ticket. Otherwise ticket.
Even if I like them I request a ticket. Too many times that less than 30 minute original request balloons to a half a day when they keep asking for multiple revisions because they didn't know what they really wanted.
Sorry Jasona.work I misspelled your name in my last post. Thanks Eirikur for pointing out my mistake. 🙂
Yeah that's why it's a privilege reserved for people i like 😛 one of those criteria being I know they won't waste my time.
December 5, 2019 at 9:20 am
p.s. I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies". It there's not a well documented ticket to support the urgency, it doesn't get done. While that sounds like I'm being nothing more than an Ahole, I'm not. It supports audits and a whole bunch of other things and I've gotten management support on that. It's actually written into our SOPs on the company WIKI.
This is something we have for everything now, even the really simple stuff; as we got fed up of people abusing "urgents" at times. People will call us, and make a "urgent" work request, to which we remind them of the correct channels to raise a work ticket. Sometimes We've been chased a week later for that work, which they needed 2 days earlier, but then respond with "I didn't have to raise the ticket" when we say we can't find it. They literally take 2 minutes; if it was that urgent you would find those 2 minutes of time.
It does work really well though, as I'm sure many have found as well. People get a little "annoyed" by it, but those are many people that can't be bothered to make the request; but then why should we be bothered to do the work for them then? 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 5, 2019 at 3:33 pm
That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said person...
🙂
December 5, 2019 at 3:36 pm
That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said person...
🙂
What did I get wrong this time?
"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
December 5, 2019 at 3:39 pm
jasona.work wrote:That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said person...
🙂
What did I get wrong this time?
You said Mackinac Island fudge is nothing but horse poop! Yeah, that's what it was, really!
December 5, 2019 at 3:41 pm
jasona.work wrote:That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said person...
🙂
What did I get wrong this time?
Google came up with a correction suggestion, "What didn't I get wrong this time?"
😎
You coming over for the Bits?
December 5, 2019 at 4:10 pm
Grant Fritchey wrote:jasona.work wrote:That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said person...
🙂
What did I get wrong this time?
You said Mackinac Island fudge is nothing but horse poop! Yeah, that's what it was, really!
Well, compared to what you get out on the Cape...
"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
December 5, 2019 at 4:11 pm
Grant Fritchey wrote:jasona.work wrote:That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said person...
🙂
What did I get wrong this time?
Google came up with a correction suggestion, "What didn't I get wrong this time?"
😎
You coming over for the Bits?
HA!
In theory, yes. I've submitted a few sessions and a precon. If I get any of it accepted, I'll be there.
"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
December 5, 2019 at 4:14 pm
Eirikur Eiriksson wrote:Grant Fritchey wrote:jasona.work wrote:That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said person...
🙂
What did I get wrong this time?
Google came up with a correction suggestion, "What didn't I get wrong this time?"
😎
You coming over for the Bits?
HA!
In theory, yes. I've submitted a few sessions and a precon. If I get any of it accepted, I'll be there.
Did the same, let's see what happens 😉
😎
December 5, 2019 at 4:18 pm
jasona.work wrote:Grant Fritchey wrote:jasona.work wrote:That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said person...
🙂
What did I get wrong this time?
You said Mackinac Island fudge is nothing but horse poop! Yeah, that's what it was, really!
Well, compared to what you get out on the Cape...
/Note to self: bring a 1/2lb of Mackinac fudge to the next event I go to that Grant's at!
December 5, 2019 at 4:24 pm
Jeff Moden wrote:p.s. I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies". It there's not a well documented ticket to support the urgency, it doesn't get done. While that sounds like I'm being nothing more than an Ahole, I'm not. It supports audits and a whole bunch of other things and I've gotten management support on that. It's actually written into our SOPs on the company WIKI.
This is something we have for everything now, if the really simple stuff; as we got fed up of people abusing "urgents" at times. People will call us, and make a "urgent" work request, to which we remind them of the correct channels to raise a work ticket. Sometimes We've been chased a week later for that work, which they needed 2 days earlier, but then respond with "I didn't have to raise the ticket" when we say we can't find it. They literally take 2 minutes; if it was that urgent you would find those 2 minutes of time.
It does work really well though, as I'm sure many have found as well. People get a little "annoyed" by it, but those are many people that can't be bothered to make the request; but then why should we be bothered to do the work for them then? 😉
I take great pleasure in telling people that they just wasted more time arguing about opening a ticket than it takes to <insert drum-roll and cymbal crash here> open a ticket.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 5, 2019 at 4:45 pm
If anyone is interested in a rather interesting problem has a look at this: https://www.sqlservercentral.com/forums/topic/table-function-returns-varying-number-of-records-for-an-update-statement
I gave up.
Looks like I was able to help the OP. Yea me!
December 6, 2019 at 11:54 am
getting back to the original topic - are the posted questions getting worse.?
hell yes...there was one today that was "I have query, make it faster" - several of us very politely asked for a tiny bit of code, maybe a query plan.. I chased it up, only to be told "fixed it with temp table" - no etiquette, no manners..... no thankyou for taking the time to look at my issue
I don't know if you guys are familiar with let me google that for you . LMGFTY.com
here's a sample https://lmgtfy.com/?q=sql+log+file
I'm so tempted to use this when people just don't try. - but i'm nice and I help the lazy people who can't use a spell checker and clearly are fixing their own issues by relying on us (i'm not naming that user)
end of Rant
MVDBA
December 6, 2019 at 12:13 pm
getting back to the original topic - are the posted questions getting worse.?
hell yes...there was one today that was "I have query, make it faster" - several of us very politely asked for a tiny bit of code, maybe a query plan.. I chased it up, only to be told "fixed it with temp table" - no etiquette, no manners..... no thankyou for taking the time to look at my issue
I don't know if you guys are familiar with let me google that for you . LMGFTY.com
here's a sample https://lmgtfy.com/?q=sql+log+file
I'm so tempted to use this when people just don't try. - but i'm nice and I help the lazy people who can't use a spell checker and clearly are fixing their own issues by relying on us (i'm not naming that user)
end of Rant
That's why I rarely post anymore, people will just not make the effort. :-/
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 15 posts - 64,201 through 64,215 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply