« first day (3149 days earlier)      last day (32 days later) » 

6:00 AM
Morning
 
6:46 AM
Morning
 
7:00 AM
Morning
 
Morning
 
7:45 AM
Do you add index to a 3rd party DB?
 
8:01 AM
It Depends™
If the third party is the principal maintainer of the DB, I guess I wouldn't mess with it. But if it was merely imported and afterwards it was up to me what to do with it, I probably would, and I actually have.
 
if i have a compelling need to do so and the perms to let me, then usually yes
 
Of course it also matters whether the DB is meant to be updated heavily by applications under my control. So far I've only done this on a DB that's used as a reference only.
 
@AndriyM For integrations purposes I access directly to the DB, and by now none of my queries are taking advantage of any index.
And all of them becomes into table scans
The App allow to add new NONCLUSTERED index, but you can't INCLUDE columns
 
I would certainly look into the possibility of creating helpful indexes. As in, I would ask around to see if I'm allowed to do that or if I can contact a person who can with my suggestions.
Although I suspect in the latter case it would help if I could prove the index(es) would be beneficial.
 
@McNets I guess that's one way, although if you can temporarily create an index without any issues (and then drop it), then the proof might be stronger if you could take actual measurements with and without the index.
Also, just as a side note, an index suggested in an execution plan might not always be the best. It's just what the engine thinks would help in that specific plan. (And even then you might need to take into account other queries and modify the create index statement to accommodate them as well, if possible.)
 
@AndriyM ok, thank you
 
9:12 AM
@McNets is it an ETL or live queries?
You could add the index before running your integration and remove it again afterwards, depending if your database edition supports online or if there is any risk of causing blocking when adding the index, but it could be an option
 
@TomV It's a live query, mostly about active production orders and current stocks.
We're developing a manufacturing tracking module, just to make it easy (and avoid some licences...)
 
9:52 AM
@McNets Yeah MES is expensive if you are only doing basic shop floor control and you often only need one or two screens with a bunch of buttons
And the MES vendors all tout their "machine integration" but they use a matrikon or kepware middleware to connect the machines and connect to that using simple OPC so you can write that yourself pretty easily too
 
10:14 AM
@TomV Not only MES but production tracking of manual operations. (Raw material, start - end time, ...)
 
 
3 hours later…
1:37 PM
@McNets Depends on the terms of the support agreement. If the vendor has a 'no changes' policy then it might void their SLA. Otherwise it's probably not going to hurt but for CYA reasons test elsewhere before you deploy to prod.
 
1:51 PM
One of my answers old SO just got a 500 point bounty for no apparent reason.
8
A: Pseudo-random stack pointer under Linux?

ConcernedOfTunbridgeWellsAddress space layout randomisation is used on several operating systems for precisely this reason. Your variation in stack pointer addresses may well be caused by this - very likely to be the case on recent versions of Linux and or *BSD. IIRC recent versions of Windows do this as well.

???
 
@jww I am not looking for anything new, my intention is to reward the existing answer — Sergei Kurenkov Aug 16 at 9:24
 
@ConcernedOfTunbridgeWells The guy just likes giving bounties
 
Don't look a gift horse in the mouth
 
OK. I seem to have been the victim of some drive-by charity.
 
Seems like you'll just have to suffer it
 
2:08 PM
I'm sure I'll be able to come to terms with it.
 
Time can heal all the wounds.
 
Tell that to someone dying of old age.
3
HAPPY MONDAY
 
Yes it was
 
@ConcernedOfTunbridgeWells I just gave you another 10 points too.
 
The age doesn't matter. What matters is whether you do have time.
 
2:27 PM
@AndriyM and a minimum of money
 
2:58 PM
howdy heapers
n00bish question, how do I update this image
<---------
beaker has run his course.
I searched the help center, tried all the things on my site and network profile pages
 
@AaronBertrand edit profile and settings on your user page
 
@AaronBertrand your profile pic? GO to your profile and edit profile and settings
 
Oh derp, yep being a n00b
 
@Taryn you both have an Aaron detector?
 
@Taryn We should have offered to change it for him 😀
 
3:00 PM
haha
 
@PaulWhite that would have been fun
 
I have the best ideas a minute too late
3
 
 
6 hours later…
The flair hasn't caught up yet
Or rather the dark theme hasn't
vs
Doesn't even onebox
Because of the shame, no doubt
It will still be preserved for history
 
9:05 PM
the all-time graph is even more ominous
https://stackexchange.com/users/62212/skwllsp?tab=reputation
 
9:22 PM
Looks as though they suddenly learnt to stop worrying about the rep and love giving it away.
 
Not everyone can cope with the stress and responsibility of being a trusted user
 

« first day (3149 days earlier)      last day (32 days later) »