The Heap™ – Consultancy ©®

12:22 AM

@EvanCarroll yeah PFA seems to want to focus on the "how should I invest my inheritance" or "how should I pay off my credit card debt" type of questions

@AndriyM the reason I brought it up in DBA is because (at least in my experience) we're often tasked with building accounting systems, without a good idea of how accounting works

I'll probably bring it up in Software Engineering, too

hot2use

5:40 AM

Morning

Andriy M

6:12 AM

Morning

dezso

6:31 AM

@alexw that is my feeling, too. I am wondering at the same time if this happens often enough - I mean, if the site becomes popular enough. Given some sites I never expected to appear, I might be totally wrong.

Andy K

7:22 AM

morning and evening

hot2use

Another question that makes me shudder and check my backup procedure:

0

Q: Online page restore hitting 1000 limit

I've been tasked to try to recover a database which suffered from corruption (due to I/O failure, which has been fixed since). I'm not familiar with the database or what it contains. I've been given an old (~3 weeks) full backup and a series of transaction logs... however there are missing trans...

hot2use

8:31 AM

50

Q: What stops Google from saving all the information on my computer through Google Chrome?

I noticed that in Google Chrome, if I type in file:///C:/Users/MyUsername/Desktop/ it shows me all of the folders on my Desktop, and I can type open up PDFs and such in chrome just by typing in the file path. What processes and systems are in place so that Google is not able to copy the data on ...

chrome file-system file-access

Philᵀᴹ

👀

dezso

9:09 AM

> Between ORMs and the dynamic language du jour, we have become so far removed from how computers work that most software development is a waste of electricity. We're using tens of servers and complex architectures for simple sites, just because we think that's the only way to scale them. And our computers are slower than they ever were.

7

news.ycombinator.com/item?id=17295518

hot2use

> Chances are, all you need is to properly use a relational database or another similar, proven, highly flexible and optimized tools, and you'll be fine until you have the time and money to solve the scale issues.

3

news.ycombinator.com/item?id=17295518

:-D

Mathematics

9:39 AM

Hi All

is it possible to desearlize a image file using T-SQl

ypercubeᵀᴹ

define deserialize

dezso

9:57 AM

@ypercubeᵀᴹ it answered no

Paul White

10:07 AM

Is the lower case L important

dezso

@ypercubeᵀᴹ yes. I am missing the reason for this definition appearing here

@PaulWhite sure, PauL

(I have a feeling I don't know what is being talked about here)

ypercubeᵀᴹ

10:26 AM

@dezso what definition? ;)

Paul White

54 mins ago, by Mathematics

is it possible to desearlize a image file using T-SQl

@dezso ^ context ^

dezso

10:51 AM

@PaulWhite ah. There is/was a reason why I didn't see that.

Paul White

Gotcha

Philᵀᴹ

1:05 PM

@dezso "I see at my place of work adding additional complexity as something to be celebrated in terms of overcomplicated pipelines, "Big Data" for questionable reasons etc. I'm starting to become more and more sure this is just that people don't actually know how any of it works." -- This has been my view for a while, and I've just been discussing it with my junior. He's lucky that I've trained him with a low level understanging of how everything works

Mathematics

1:34 PM

@PaulWhite K2 Workflow has process instances in there database, all information is there except datafields which are stored as type IMAGE, I want to view these as text

sorry for late reply by the way

I already tried casting as binary to nvarchar but it only gives a weird output with 2 characters

billinkc

Sounds like you'd need to mechanism of serialization used by k2

hot2use

2:23 PM

17

Q: Live: Left nav, new theming and responsiveness

We have released left navigation bar, our new theming and a our initial responsive design work on Stack Overflow and Meta Stack Exchange (it's been live on MSO for a week). This work has been in progress and being discussed with the community for several months. The motivation for the work is cov...

discussion featured navigation responsive-design

currently only on META and SO.

BradC

2:50 PM

So, the OP from this question is having a tantrum and defaced their original question:

-4

Q: How to do a case-insensitive like

My vendor requires the data warehouse to be case sensitive, which is getting a bit old. I'm tempted to run a job which changes the collation every night, but I think that might be overkill. Question: How would you write this to be case-insensitive? Where Name like '%hospitalist%'

sql-server

But the original Q is a good question. I've rolled it back to the original version

And there are some useful answers.

Can we "take over" the question from the OP, prevent them from further defacing it, and leave the useful answers?

(Calling a mod...)

Lamak

@BradC I mean, the original question is....discrete, I wouldn't call it a good question

and I don't understand why that user is throwing a tantrum

BradC

@Lamak They posted an answer explaining that they were going to create a duplicate database, containing (literally) 15,000 views, one for each object in the original database.

It was downvoted as people mentioned that didn't seem like a practical answer

So he got huffy, defaced his answer, then defaced his question

Lamak

@BradC lol, I'm reading that answer...jeez

BradC

And now its been closed as a dup of a random (unrelated) question

billinkc

Yeah, I don't get the dupe factor

Lamak

2:57 PM

yeah, what's with that "duplicate"?

hey @billinkc, you are still alive

\o/

jadarnel27

Jun 1 at 18:13, by jadarnel27

@James You definitely need a snickers.

billinkc

Si, estoy alivo

Kidding, ... vivo?

VIVA LA REVOLUTION!

BradC

I still think it is a decent question in its original form. I found a couple of very old similar questions for other platforms, but nothing for MS SQL

So, can we get a mod to re-open and clean up the junk?

Lamak

@billinkc ding ding ding

jadarnel27

Has anyone, you know, flagged for moderator attention?

3

billinkc

3:00 PM

@BradC Personally, I'd ask the same question so you don't involve the uncooperative OP

Never need to flag for mod attention, they watch this room with great interest due to the fascinating topics and jokes that never have to be explained at great length

8

BradC

Can't a mod edit it and move it to "community" or whatever, so we don't have to retype the answers?

jadarnel27

@BradC There shouldn't be a need to do that. If OP continues to deface content on the site, they'll be suspended.

OP can request the post be disassociated from their account.

BradC

@jadarnel27 Ha, OP has likely flounced from the site at this point.

Just trying to see if there is a way (short of suspension) to clean up this Q without it being further subjected to vandalism when (if) OP comes back. I'm just not familiar enough with the options the mods have

jadarnel27

@BradC Understood. They could also temporarily lock the post if edit wars continue.

BradC

@jadarnel27 I did flag, but it has since been closed as a dup of an unrelated Q.

dezso

3:08 PM

@BradC I reverted the answer (and then removed the beginning passage)

jadarnel27

@BradC Cool. Looks like @JackDouglas has taken care of business!

dezso

in the same news: dba.stackexchange.com/users/140866/james

BradC

Yep. In cases like this, do they routinely clear downvotes? (which were only due to the vandalism, the score was 0 prior to that)

billinkc

Wait, is this the same user that got a short ban and then a year long ban a year+ ago?

Maybe they were permabanned...

jadarnel27

Any interest from the room in reopening this question? Seems on-topic, 4k views, no downvotes, decent answers.

I came across it today in a Google search.

BradC

3:14 PM

@jadarnel27 if I had to guess, sounds like it was closed because "why is it this way" questions are sometimes unanswerable

sp_BlitzErik

b- would reopen

BradC

But in this case it seems (to me) pretty answerable

(and well answered)

Lamak

@billinkc who?

hot2use

vtr cast

dezso

@billinkc you mean the 10xer? I don't think so

billinkc

3:16 PM

@Lamak can't remember. They argued like the devil about stuff. I think they trotted out their mensa membership or some such genius nonsense

Lamak

sounds like something you would do

billinkc

I don't need to flaunt me brilliance

dezso

@billinkc the way they argument is totally different, so I really don't think they are the same

billinkc

Aholes tend to blend together

Lamak

@billinkc you might actually need it

dezso

3:19 PM

hm, don't recall I've ever seen an actual message from a mod when dealing with a flag, until just now

now he deleted his answer

Max Vernon

@Lamak this guy?

Lamak

3:37 PM

aaah, I remember that guy

Max Vernon

with much love, no doubt.

Lamak

the heap loves drama

or hate, don't remember which one

MDCCL

@dezso Interesting thread, thanks for sharing.

Zane

@billinkc yo

Paul White

27 people in the heap

that's the most I've seen for a while

McNets

3:44 PM

10x

billinkc

@Zane sup chief

Lamak

@PaulWhite you are gonna scare them

Zane

@PaulWhite Usually we don't get that kind of membership unless we say something that floods in the mods.

Lamak

@Zane is that a dare?, because @billinkc is here, so...

billinkc

@PaulWhite Or I'm in channel... which might correlate to mods being summoned

Paul White

3:45 PM

@Zane yeah that's the odd thing, they're all* normal people

billinkc

@PaulWhite /spittake

Paul White

asterisk added

terms and conditions apply

billinkc

Not loud enough

Zane

@billinkc Not much. Just trying to get to 1 so I can leave work and go camping.

billinkc

@Zane You can join me, be down here Friday for 10 days of glorious uhhhh that's not glorious weather... wunderground.com/forecast/us/mo/osceola?cm_ven=localwx_10day

Zane

3:56 PM

I'm gonna have to turn that down.

billinkc

Turn down for what?

Zane

Boundary Waters

billinkc

@Zane I was going with a musical reference youtube.com/watch?v=HMUDVMiITOU but yes, Boundary Waters is tentatively on the agenda for next summer

Zane

Nice.

Ha! Apparently we have a new policy that forbids any new database application from using dbo schema.

@billinkc I'd assumed it was a bit as well as a legit question.

Lamak

@Zane "legit question" and "@billinkc" in the same phrase...what times are we living in?

billinkc

4:14 PM

Glorious, end of day, times

Max Vernon

Just in case you haven't heard this term yet, Baader-Meinhof.

dezso

@MaxVernon EAGL please

Lamak

> Baader-Meinhof is the phenomenon where one stumbles upon some obscure piece of information—often an unfamiliar word or name—and soon afterwards encounters the same subject again, often repeatedly. Anytime the phrase “That’s so weird, I just heard about that yesterday” would be appropriate, the utterer is hip-deep in Baader-Meinhof

Max Vernon

^^^ that

expect to hear it often now.

Lamak

don't know what it was related to, but it's always good to learn something

dezso

4:18 PM

here in Germany it does mean something completely different

Max Vernon

@Lamak related to nothing other than itself.

@dezso interesting!

Lamak

@dezso the "Red Army Faction"?

dezso

Red Army Faction

The Red Army Faction (RAF; German: Rote Armee Fraktion), also known as the Baader-Meinhof Group or Baader-Meinhof Gang (German: Baader-Meinhof-Gruppe, Baader-Meinhof-Bande), was a West German far-left militant organization founded in 1970. Key early figures included Andreas Baader, Gudrun Ensslin, Horst Mahler and Ulrike Meinhof, among others. Ulrike Meinhof was involved in Baader's escape from jail in 1970. The West German government as well as most Western media and literature considered the Red Army Faction to be a terrorist organization. The Red Army Faction engaged in a series of bombings...

that

Max Vernon

interesting!

Lamak

I got that as the first results from google, but I thought @MaxVernon was talking about the other one

@MaxVernon oh, the tone I used to read that one...

ypercubeᵀᴹ

5:00 PM

I miss all the drama...

Defaced questions, Baader-Meinhof mentions, billinkc visiting the Heap ...

sp_BlitzErik

5:12 PM

@ypercubeᵀᴹ can't you just be here in one of your other dimensions?

alexw

5:37 PM

@dezso I think it's because the success of an SE site is so much about having a dedicated community behind it, more than the topic itself

jadarnel27

6:14 PM

Is there a way to tell the last time stats were auto updated for an index?

Ah, found it: sys.dm_db_stats_properties

My Google-Fu was failing me.

Tom V

@jadarnel27 sure I tend to refer to one of Glenn berry's scripts

jadarnel27

@TomV Do you have a link? The one I found is also from SQL Skills, but it's an Erin Stellato post: Understanding When Statistics Will Automatically Update

Tom V

@jadarnel27 on mobile now. Google Glenn berry dmv

jadarnel27

Ah, got it. Thanks, @TomV!

Tom V

@ypercubeᵀᴹ yeah me too. The most happenings in weeks and we miss it