June 24, 2018 at 10:34 pm
Sergiy - Sunday, June 24, 2018 6:23 PMjasona.work - Friday, June 22, 2018 11:03 AMEd Wagner - Friday, June 22, 2018 9:21 AMjasona.work - Friday, June 22, 2018 8:34 AMChris Harshman - Friday, June 22, 2018 8:20 AMjasona.work - Friday, June 22, 2018 6:19 AMThat feeling when you've got a Linked Server connection to a remote site who thought they had everything set up and you just needed to get your end set up, but they didn't have everything set up right so now your end works and theirs doesn't and the people who require the data from the remote site are calling you...
:crazy::sick:Sorry man, I feel for you when dealing with linked servers. My problem tends to be somehow the network admins keep managing to screw up Kerberos and delegation so linked servers that used to work stop working and of course it's a database problem.
You know, I'd almost trade you problems...
Mine is SQL connecting to a remote Oracle server, over a WAN link that sometimes decides to crap out half-way through a data pull, or while SQL is waiting on the Oracle to start sending data, leaving a stuck connection that won't die and can't be killed...
But when the customer gets to me about it, and I test it, it's working fine again...Hey - I've had that problem. The WAN doesn't die frequently, but when it does, it's a disaster. My usual problem is that the query takes forever to run on the Oracle server.
It's especially annoying because it fails silently, just leaving a running / idle query behind. In my customers' case, it's kind of worse because while if we were doing nightly data pulls, something could be set to check at a set time "did the data arrive," and if not, run again. But nooo, they *require* near real-time data, which means at random points through out the day, they're going out through the link to get their data.
:unsure:How about an update on a remote table (would be bad enough by itself, but we don't stop here), which fires a trigger, containing a remote call to another server (sometimes back to the original server the query is coming from, sometimes not - it's a dynamic query), which executes some task of sending an email or manipulating files via cmd shell, which gets stuck because some network resource is not accessible, so it never comes back with any error code, and both servers got stuck in transaction, and because of beautiful indexing everything is locked...
You wish it would happen during a nightly process, no, it happens during a peak time of user requests, when they all commit their orders right before COB.
Heh.,. wusses,,, no automatic reboot of both servers to fix the problem. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2018 at 2:05 am
Sean Lange - Friday, June 22, 2018 3:08 PMI can't remember the term for this but truly inexperienced people think they are way better than they really are and experienced people start to underrate themselves as they get better.You have to keep in mind that your assessment is how you would stack up on average to a random sampling of people in the industry.
I've been thinking about this type of thing lately, when I realised that I hardly answer any questions on this site now. Looking back through my history I used to answer so many more, when I had far less experience behind me. Now that I (probably) know more I'm far more reserved about attempting to answer a post. I'm far more worried about getting it wrong than I think I used to be and don't have the time to research other people's problems to a level that I would be happy with.
So, based on that bizarre logic, people like Gale, Steve, Lynn and Jeff must know nothing - because they answer so many questions.
June 25, 2018 at 6:22 am
BrainDonor - Monday, June 25, 2018 2:05 AMSean Lange - Friday, June 22, 2018 3:08 PMI can't remember the term for this but truly inexperienced people think they are way better than they really are and experienced people start to underrate themselves as they get better.You have to keep in mind that your assessment is how you would stack up on average to a random sampling of people in the industry.
I've been thinking about this type of thing lately, when I realised that I hardly answer any questions on this site now. Looking back through my history I used to answer so many more, when I had far less experience behind me. Now that I (probably) know more I'm far more reserved about attempting to answer a post. I'm far more worried about getting it wrong than I think I used to be and don't have the time to research other people's problems to a level that I would be happy with.
So, based on that bizarre logic, people like Gale, Steve, Lynn and Jeff must know nothing - because they answer so many questions.
The term is the "Dunning Kruger Effect".
https://www.google.com/search?q=dunning+kruger+effect&oq=dunning+kruger+effect
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2018 at 7:33 am
Sergiy - Sunday, June 24, 2018 5:44 PMSean Lange - Friday, June 22, 2018 3:08 PMWhen I get a score from someone stating their ability on a scale of 1 - 10 I do a little before I assess that score. If the person has experience and rates them self 5 or lower I do something like 15 - TheirScore. If they have little or no experience and the score is > 5 I use TheirScore - 5. But for either if TheirScore is 10 I assume it to be no higher than a 4 or 5 unless they have been doing this forever. I can't remember the term for this but truly inexperienced people think they are way better than they really are and experienced people start to underrate themselves as they get better.
You have to keep in mind that your assessment is how you would stack up on average to a random sampling of people in the industry. And you sir would be far higher than a 5 on ability of a truly random sample of people working with databases.
And how do you score your ability to score other people abilities?
I suffer the same issue as described I suspect. I know I rate my abilities a lot lower today than I did several years ago. :blush:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 25, 2018 at 7:34 am
Jeff Moden - Monday, June 25, 2018 6:22 AMBrainDonor - Monday, June 25, 2018 2:05 AMSean Lange - Friday, June 22, 2018 3:08 PMI can't remember the term for this but truly inexperienced people think they are way better than they really are and experienced people start to underrate themselves as they get better.You have to keep in mind that your assessment is how you would stack up on average to a random sampling of people in the industry.
I've been thinking about this type of thing lately, when I realised that I hardly answer any questions on this site now. Looking back through my history I used to answer so many more, when I had far less experience behind me. Now that I (probably) know more I'm far more reserved about attempting to answer a post. I'm far more worried about getting it wrong than I think I used to be and don't have the time to research other people's problems to a level that I would be happy with.
So, based on that bizarre logic, people like Gale, Steve, Lynn and Jeff must know nothing - because they answer so many questions.The term is the "Dunning Kruger Effect".
https://www.google.com/search?q=dunning+kruger+effect&oq=dunning+kruger+effect
That's the one. Thanks Jeff. I couldn't remember the name of it and wasn't having much luck finding it either.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 25, 2018 at 9:47 am
Thom A - Sunday, June 24, 2018 1:08 PMI'm not going to link (but I'm sure many of you will guess who), and I'm not going to respond to them, but a certain very well known someone just tried called me out about my attitude on a public forum (towards data quality). Considering they're well renowned attitude on these very forums, I'll admit, it's really miffed me off. Hypocrite...</rant>jasona.work - Sunday, June 24, 2018 12:53 PMI don't know how this came about, but tomorrow my first SSC article goes up...
😮I look forward to it! Some (not to imply others weren't) of your posts have been really helpful for questions/problems I've had in the past, so I hoping for a good read. (No pressure!) 😀
I know who and read that response before seeing this.
June 25, 2018 at 11:42 am
You know what seems to be the eternal question that no one seems to get tired of asking, "How do you restore a copy of a database to an older version of SQL Server?"
Been working with SQL Server for over 20 years and this question keeps getting asked over and over and over, almost like the Energizer Bunny.
June 25, 2018 at 12:16 pm
Lynn Pettis - Monday, June 25, 2018 11:42 AMYou know what seems to be the eternal question that no one seems to get tired of asking, "How do you restore a copy of a database to an older version of SQL Server?"
Been working with SQL Server for over 20 years and this question keeps getting asked over and over and over, almost like the Energizer Bunny.
I would suspect that on any given day, somewhere in the world, someone is asking that question...
June 25, 2018 at 12:26 pm
Lynn Pettis - Monday, June 25, 2018 11:42 AMYou know what seems to be the eternal question that no one seems to get tired of asking, "How do you restore a copy of a database to an older version of SQL Server?"
Been working with SQL Server for over 20 years and this question keeps getting asked over and over and over, almost like the Energizer Bunny.
Well... How do you restore a copy of a database to an older version of SQL Server?
"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
June 25, 2018 at 12:31 pm
Grant Fritchey - Monday, June 25, 2018 12:26 PMWell... How do you restore a copy of a database to an older version of SQL Server?
I think you first need to install the Inverse Chronology Adapter module into Windows before you can even attempt to do that. Unfortunately that module will not be available until Windows Server 2037
June 25, 2018 at 12:41 pm
Chris Harshman - Monday, June 25, 2018 12:31 PMGrant Fritchey - Monday, June 25, 2018 12:26 PMWell... How do you restore a copy of a database to an older version of SQL Server?I think you first need to install the Inverse Chronology Adapter module into Windows before you can even attempt to do that. Unfortunately that module will not be available until Windows Server 2037
Unless you use DBCC TIMEWARP to install it yesterday. If you do that tomorrow, it should already be there today.
June 25, 2018 at 1:03 pm
Ed Wagner - Monday, June 25, 2018 12:41 PMChris Harshman - Monday, June 25, 2018 12:31 PMGrant Fritchey - Monday, June 25, 2018 12:26 PMWell... How do you restore a copy of a database to an older version of SQL Server?I think you first need to install the Inverse Chronology Adapter module into Windows before you can even attempt to do that. Unfortunately that module will not be available until Windows Server 2037
Unless you use DBCC TIMEWARP to install it yesterday. If you do that tomorrow, it should already be there today.
My head hurts.
"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
June 25, 2018 at 1:16 pm
Ed Wagner - Monday, June 25, 2018 12:41 PMUnless you use DBCC TIMEWARP to install it yesterday. If you do that tomorrow, it should already be there today.
Makes perfect sense. Do you need the Clairvoyance module though for TIMEWARP to work properly?
June 25, 2018 at 5:53 pm
Ed Wagner - Monday, June 25, 2018 12:41 PMChris Harshman - Monday, June 25, 2018 12:31 PMGrant Fritchey - Monday, June 25, 2018 12:26 PMWell... How do you restore a copy of a database to an older version of SQL Server?I think you first need to install the Inverse Chronology Adapter module into Windows before you can even attempt to do that. Unfortunately that module will not be available until Windows Server 2037
Unless you use DBCC TIMEWARP to install it yesterday. If you do that tomorrow, it should already be there today.
Not, unless you make it happen.
Drop everything and carve an instruction on your desk to use today's day as a parameter for DBCC TIMEWRAP.
Done?
Not there yet?
OK, they must have sent your desk into rubbish pile on 2021.
Try to screw the desk to the floor. With one-way screws. And may be copy the instruction on the kitchen's wall.
Still nothing?
Oh, that wall must have gone down during that major renovation in your office on 2026.
Together with removed floors and smashed desks.
Gosh, how to get the message through?
Oh! I know.
Do you have any friend in Russia?
Send them a snail mail, better a small parcel, enclose an envelope with the return address and ask to send it back when received.
"Post of Russia" will certainly deliver it right in time for 2037.
_____________
Code for TallyGenerator
June 26, 2018 at 6:59 am
So I've got a week long work trip coming up next month, and I'm already starting to plan out what to pack, how much cash to bring, where there is to eat around the hotel, etc...
I've sort of been working some of this for a few weeks now, I'm just sort of locking things down.
I've got another trip coming up in August (not work,) and I'm already working with the wife on planning what to pack, how to pack it, food plans, etc...
So, out of curiosity, how many of you start planning the details for trips weeks or months in advance?
Things like packing lists, etc...
Viewing 15 posts - 61,726 through 61,740 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply