November 15, 2018 at 2:41 am
GilaMonster - Wednesday, November 14, 2018 1:52 PMIs that damn thread about TOP still going on?
I did follow that one for a bit, but I'm not going to look, no really I'm not :O
Rodders...
November 15, 2018 at 2:51 am
When you urge the business side to not waste my precious time and the first thing happens is 1 week of work was wasted because datatypes agreed on didn't match actual data in the end. On the other hand there's feature requests which are not even technically defined to me yet, still implementation is urged.
End of story: there might not be enough time this year to implement these feature requests now who could've seen something like that coming?
At least I could soothe business' mind by telling just today " you know this new piece of SW has a "go faster switch" (Daily load instead of full load, basically) now so the new data is available within 1 minute now instead of 35 minutes."
November 15, 2018 at 6:20 am
You know all the cracks sysadmins make about people using their Recycle Bin or Deleted Items as "archive" storage?
Yeah, I did something similar and it came back to bite me today...
Decided it was time to re-load my personal laptop (C:\ drive getting trim on space) so I backed up all my stuff to my NAS and nuked it.
EXCEPT for my D:\Temp folder where I had various and sundry images I'd grabbed off the web and other items...
:crazy:
Ah well, it was generally just a dumping ground for "neat" stuff I didn't want to stick in Documents or the like, so really I know I didn't lose anything that was *really* important, but still...
November 15, 2018 at 8:20 am
jasona.work - Thursday, November 15, 2018 6:20 AMYou know all the cracks sysadmins make about people using their Recycle Bin or Deleted Items as "archive" storage?
Yeah, I did something similar and it came back to bite me today...Decided it was time to re-load my personal laptop (C:\ drive getting trim on space) so I backed up all my stuff to my NAS and nuked it.
EXCEPT for my D:\Temp folder where I had various and sundry images I'd grabbed off the web and other items...
:crazy:
Ah well, it was generally just a dumping ground for "neat" stuff I didn't want to stick in Documents or the like, so really I know I didn't lose anything that was *really* important, but still...
He he, put it in the bin for a storage does not sound too convincing😉
😎
Have had to recover "important" data for many clients in the passed, the Recycle Bin has been a good ally many times. Until the data is overwritten, it is still available after the bin is emptied. In your situation, rip out the D: drive or the drive holding the partition, get a resent forensic Linux distribution and scan it at low level (using photorec etc.). Most likely you'll get majority of the files back unless, the drive was very fragmented.
November 15, 2018 at 9:26 am
Any help here would be appreciated as it is one of the areas in SQL Server that is out of my wheel house: https://www.sqlservercentral.com/Forums/2010197/CLR-Error
November 16, 2018 at 12:54 pm
Thom A - Wednesday, November 14, 2018 3:17 PMAhh well, we just have to make things more idiot proof. It'll create more creative idiots, but, I kind of find the way the mind of a user works fascinating some days. "Why did you think that clicking yes to both dialogue boxes that said "This will delete the customer's order history. Are you sure you want to do this?" wouldn't delete their order history?"🤣
somebody on here has a quote from Charles Babbage that fits this perfectly. "if I put in the wrong questions, will it give me the right answers? I cannot rightly comprehend the chain of poor understanding that would precipitate such an incorrect conclusion" ~paraphrasing
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
November 19, 2018 at 1:26 am
jonathan.crawford - Friday, November 16, 2018 12:54 PMsomebody on here has a quote from Charles Babbage that fits this perfectly. "if I put in the wrong questions, will it give me the right answers? I cannot rightly comprehend the chain of poor understanding that would precipitate such an incorrect conclusion" ~paraphrasing
Morning Jonathan 😎
It was prompted by the frequent questions about why reports didn't match spreadsheets or estimates or why two reports with entirely different names gave different results. I will forgive the confusion of the user who asked why two reports with the same name in different sub-folders produced different results.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
November 20, 2018 at 9:00 am
Gotta love the days before a holiday weekend...
No one's really in the office and of the people who are, very little *work* is actually being done, it's more catch up on paperwork and such.
I'd love to have a lab system so I could putter with things I want to potentially do to my servers, but that can wait until tomorrow when I'm working from home and have access to my home lab...
As for why I don't have one at work? Way to much of a pain to actually get a VM stood up or a second workstation.
November 25, 2018 at 4:08 am
jasona.work - Wednesday, November 14, 2018 12:10 PMGrab your popcorn for this topic!
https://www.sqlservercentral.com/Forums/2009853/The-Linux-CoC
It's trying *real hard* to descend into politics, rather than a discussion of the Editorial itself...Steve's doing his best I think, to keep it from going full-on screaming fight by ignoring the more charged comments, shall we say?
I would say Steve was doing his worst with that editorial when he wrote " it would be better to have a few people investigated or thrown out of a conference for no reason than have others suffer because they aren't believed", which clearly amounts to saying that any accusation should be treated as irrefutable proof of guilt because the accuser must not be upset by not being believed even if there is actually conclusive evidence that the accusation is false. I guess he was having an off-day when he wrote that, because I don't think he intended the very clear implication that fair play and justice don't actually matter.
Tom
November 26, 2018 at 7:47 am
TomThomson - Sunday, November 25, 2018 4:08 AMjasona.work - Wednesday, November 14, 2018 12:10 PMGrab your popcorn for this topic!
https://www.sqlservercentral.com/Forums/2009853/The-Linux-CoC
It's trying *real hard* to descend into politics, rather than a discussion of the Editorial itself...Steve's doing his best I think, to keep it from going full-on screaming fight by ignoring the more charged comments, shall we say?
I would say Steve was doing his worst with that editorial when he wrote " it would be better to have a few people investigated or thrown out of a conference for no reason than have others suffer because they aren't believed", which clearly amounts to saying that any accusation should be treated as irrefutable proof of guilt because the accuser must not be upset by not being believed even if there is actually conclusive evidence that the accusation is false. I guess he was having an off-day when he wrote that, because I don't think he intended the very clear implication that fair play and justice don't actually matter.
I'll be honest, I think the topic is one of those that no matter what direction you come at it from, someone is going to take offense to your position.
And, I'm going to leave it there.
November 26, 2018 at 2:25 pm
Anyone else just hear the adult noises from a Charlie Brown movie when Mr. Celko posts here?
November 26, 2018 at 2:31 pm
Lynn Pettis - Monday, November 26, 2018 2:25 PMAnyone else just hear the adult noises from a Charlie Brown movie when Mr. Celko posts here?
Nope... mostly stopped watching that particular show. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
November 26, 2018 at 2:36 pm
Jeff Moden - Monday, November 26, 2018 2:31 PMLynn Pettis - Monday, November 26, 2018 2:25 PMAnyone else just hear the adult noises from a Charlie Brown movie when Mr. Celko posts here?Nope... mostly stopped watching that particular show. 🙂
Well, I have grand kids between 6 and 3 years old, so I get to watch these old shows again. 😀
And I will always love Snoopy and Woodstock!
November 27, 2018 at 7:47 am
I've just had a conversation with our client about the fact that backups weren't being taken on the instance that we provide to them. It's not strictly our problem, that's why we gave them their own instance, but it's making our alerting screens look bad. To defend the chap I spoke to, he's not technical and doesn't pretend to be, he's just pretty switched on and if he doesn't know an answer himself, he knows the person who does.
He told me that they were backing things up, everyday they right-clicked on their databases and generated the scripts like they'd always done :pinch:
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
November 27, 2018 at 8:11 am
Neil Burton - Tuesday, November 27, 2018 7:47 AMI've just had a conversation with our client about the fact that backups weren't being taken on the instance that we provide to them. It's not strictly our problem, that's why we gave them their own instance, but it's making our alerting screens look bad. To defend the chap I spoke to, he's not technical and doesn't pretend to be, he's just pretty switched on and if he doesn't know an answer himself, he knows the person who does.He told me that they were backing things up, everyday they right-clicked on their databases and generated the scripts like they'd always done :pinch:
Well gosh, there is nothing like a backup....and that is nothing like a backup. 😀
_______________________________________________________________
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/
Viewing 15 posts - 62,851 through 62,865 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply