« first day (2170 days earlier)      last day (2713 days later) » 

3:52 AM
@ypercubeᵀᴹ I added an answer with a little more in the way of analysis and explanation.
 
 
1 hour later…
5:06 AM
@PaulWhite Ha, "a little more". That is a regular kiwi blogpost requiring a reread or two to grasp what is actually going on. Thank you,
 
 
2 hours later…
6:55 AM
Morning all.
 
 
1 hour later…
8:22 AM
Morning
 
Morning
 
morning
 
8:50 AM
morninG
 
9:24 AM
morning grumpiness:
Did you try to do any research before asking? — dezso 15 secs ago
 
I thought "morning" defaulted to "good morning", not "grumpy morning". I'll try to remember to be explicit next time.
2
 
9:58 AM
finally, there were some valid chat flags somewhere
 
10:27 AM
hi friedns , i need to create column "commission" in 2 tables, may i create with same column name or different one [ column is not primary or foriegn key ] ?
 
@profile101 it depends on your naming conventions
but tecnically nothing is preventing you from having all tables in your DB with the same column names
OTOH, if those two columns refer to the same (IRL) thing, you might want to store them in a separate table and refer that using FKs
 
thanks @dezso
 
Unless "commission" refers to a free to enter percentage, I don't think I would create a table with 10%, 11,5% 10.25% 8.90% etc
So it depends :)
 
11:26 AM
@TomV hm, sure. But if it is a designated group of people or a commission in the sense it's used in logistics (which is an often seen use case here, so I didn't even thing about other uses), then maybe yes
 
Registered for a Coursera course today in Modern combinatorics.
in Russian ...
 
@ypercubeᵀᴹ for the challenge?
 
@dezso More or less. It says it has English subtitles in the videos!
 
12:03 PM
@PaulWhite Yeah, that deserved a bounty. Have to wait 5-6 days though for it.
 
12:44 PM
@ypercubeᵀᴹ Thanks but I really don't have any need for the rep. Just thought you might like to know that answer had been added.
 
@PaulWhite me neither ;) Nice answer however, so it needs rewarding!
And who knows, we might get some extra hats
 
Ooo hats yeah
 
hats?
already?
 
In 6 to 8 days
 
ah, ok
 
12:57 PM
I would link messages but the arrow is infeasibly tiny on my phone's screen
 
I imagine it's only usable on phones that are infeasibly large.
 
@PaulWhite there is a mobile specific edition, which is nearly usable
 
Yes I'm using the new chat. The old one was utterly unusable. This one is much better but still too hard to click the small things
 
1:15 PM
@PaulWhite I thought you were using android?
On my device it tends to zoom if you click close to links/buttons
 
@PaulWhite I can't make chat work in android most of the times
 
on the version I see, when I click a message, a menu of icons appear, with a nice big answer arrow
in turn I cannot see which post is an answer to which one (or could not figure it out yet)
 
@dezso Can't you just tap the little grey arrow (similar to the one in full chat)? That works for me but I have to tap it instead of hover over it like in the desktop version. And exactly on the arrow, not on the message
Maybe you all need to buy larger phones :)
 
for is unusable because it keeps constantly refreshing the page
 
@TomV hm, really
I somehow missed this earlier
@Lamak like for i in *; do refresh; done?
 
1:29 PM
like that
 
1:39 PM
Seriously, this customer has disabled the changing of keyboard preferences on their servers by using group policies
Having to watch an image of a french keyboard to figure out where the symbols are gets boring really quickly
 
@TomV that's...overly controlling
 
@Lamak imagine that someone mapped the pile-of-shit unicode character to 'a'
 
yeah, but seriously, why waste time in policing that?
 
@Lamak was joking
 
@Lamak Because ... French. They police even the language itself.
 
1:45 PM
they possibly must control everything, otherwise Bad Things Happen™
 
@dezso Hmm, tempting to waste an hour just to try attempting to hack that
imagine how long it could take them to revert it :)
 
@dezso I know....sorry
 
@TomV when done with your task, you could also change the wiring physically
 
@dezso not over RDP :)
(remote desktop for the *nix minded)
 
a screwdriver, a pair of scissors, some wire, and soldering stuff is all that you need
@TomV ah, that makes it harder
 
1:46 PM
Language police may refer to: The Language Police, a book by Diane Ravitch Latvian State Language Center, a Latvian government body State Language Inspectorate, a Lithuanian government body Language Inspectorate, an Estonian government body Office québécois de la langue française, a Quebec government office Minister of Culture (France), a French office known as the "language police" == See also == List of language regulators Linguistic prescription Political correctness...
 
TIL there is no space in 'e.g.'
so far I looked even more oldschool than I really am, inadvertently
 
I suppose they had a user at some point who kept messing up his keyboard settings, so they just turned it off for everybody
Ok, so I have access to the correct machine registry key to set up keyboard mappings, but they have to be physical keys
All that's left is figuring out how to stick alt-codes in there and we have unicode poo
They have to be standard keyboard scancodes, the best that would work is make their keyboard leds blink everytime they push some letter
 
2:35 PM
 
@ypercubeᵀᴹ I won't be able to look at that poor number like until now
 
 
1 hour later…
3:42 PM
If you're having internet weirdness and your dns server is set to 8.8.8.8, google has dns issues
 
 
1 hour later…
5:00 PM
^^^ That amused me
 
it was amusing
 
i wish i was like you ...
...
...
easily amused
 
@swasheck A mirror provides me countless hours of entertainment
 
Have you tried with "\"Statuses\"" ? — mcNets 36 mins ago
OK, the issue is the Windows command line and how to use/escape quotes. Try this please -t "public.""Statuses"""ypercubeᵀᴹ 36 mins ago
Match down to the second: 16:34:30Z
 
6:08 PM
Why are you converting sysdate to DATE? I thought it is already a date ... The whole TO_DATE(sysdate, 'dd/mm/yyyy HH24:MI:SS') is wrong in so many levels. — ypercubeᵀᴹ 9 mins ago
Convert the date to string. Then the result string to date. Then (probbaly) compare the result date to a string column. Then wonder why it doesn't work.
 
Deleted. Perhaps because they discovered the type of the bar column.
 
@AndriyM bar ... irish pub? college bar? night club? sports bar? lounge? cigar bar? WHICH TYPE OF BAR?
 
bar none
2
 
HALLO EVERYONE
 
mr. goodbar
 
6:17 PM
@billinkc sometimes you say something funny
 
The bar column is a column that's usually found by a bar, duh.
 
@Lamak i'm still waiting for him to say something funny today
@AndriyM corinthian? doric?
 
@swasheck maybe talk about hats. They are funny
 
@swasheck Not sure, one with a triglyph at the top, perhaps.
 
i'm not trying to be funny, just pedantic
 
6:20 PM
@swasheck Has to be doric, with only 3 letters.
 
perfect
 
we're blocking everything from imgur now because ... FEAR!!!!!
 
For External Application Resources?
 
no. actually afraid of the internet boogeymen.
 
6:22 PM
It's too late, once you have an IP address they get into your modems
 
I listen to Chinese music today, thnx to my next cubicle guy. Present to myself this Christmas: headphones
 
@swasheck you should be afraid
 
just waiting for the EOY bonus check to clear
 
@swasheck are you looking?
 
@Lamak i am so afraid of so many things. losing a competitive advantage because a DBA might look at an image on imgur (classified as "external storage") is not one of them
@Lamak check wont clear until february. i will start mid-jan
 
6:23 PM
@swasheck good luck
 
So uhhh, if average read stall on the file groups is between 125 and 128 milliseconds, that's good, right?
 
that's awesome!!!!
 
The overall read stall wasn't horrible because the system databases were bringing it down (sys dbs + SSIS + the OLTP db) to 84 average
Curiously enough, write performance doesn't suck. This likely means it's bad queries and or missing/non-covering indexes?
 
is the storage a SAN?
 
I've been told they have fusion IO cards. Whether that's true or not, I don't know how to verify
 
6:32 PM
is read stall the time between request and first pages read, or request and all pages read?
 
/shrug It's whatever is captured from dm_io_virtual_file_stats (Glenn Berry's diagnostic queries)
 
@billinkc also, i've generally preferred perfmon so that i can get a sense of when iops/throughput are peaking. sys.vfs (my shorthand) just gives you a "big picture"
@Forrest read completion. (extent reads ... page reads ... ) given the different ways data is read, i dont think it's just at page level.
@billinkc do you not have RDC access?
 
I don't think so. It's a prod box but they did give me access to see server stats
I think I regret looking at this
 
@billinkc well them pepper them with requests for information. is fusion the only storage in use? are they mirrored or independent? what is the health status of the cards? how old are they? what drive letter(s)/mount points are they?
 
Orrrrr, I hit eject and say "make it suck less, that's your role"
 
6:41 PM
@billinkc also a good consultant path. preserving future earning potential.
 
Seriously, I'm not a DBA nor am I the SAN/VM person. They have full-time staff to fill these roles. My contract says "make all the things talk to each other"
I'd like to help but I am not empowered to correct either issue nor is that a land war I'd like to die in
I will document that there is an issue and escalate to the project owner and get some Lava[TM] to clean my hands
 
"tag. you're it!"
2
 
@billinkc all the things?
 
@Lamak todos
 
tahdah!
 
7:05 PM
@ypercubeᵀᴹ I still have some left (earphones) :)
@billinkc 100+ ms would surprise me if it were fusionIO, or you have an insane workload
 
@TomV yeah. kinda my point
"we have fusionio" ... "are you using it?"
 
Yeah, we have our operating system on it, data and log is on floppies though
RAIF: Redundant Array of Inexpensive Floppies
 
amazon glacier
 
Oh I messed up that acronym didn't I
 
@TomV Redundant Arrangement ...
 
7:16 PM
@ypercubeᵀᴹ Array? no?
 
yes, better. Or bettre. I should use the British English spelling ;)
 
I suck at acronyms
 
ISAAC: I Suck At ACronums
3
 
Simplified! awesome
 
7:21 PM
@TomV No...
 
@PaulWhite Mods fix everything
 
Actually I was just keen to try edit on mobile
 
heh
 
@TomV or almost. They miss spelling sometimes. Rendundant
 
@PaulWhite evil little thing that mobile chat isn't it :P
 
7:23 PM
@ThomasWard Totally. Though it's much better than it used to be. Pretty much everything with text ducks on mobile anyway
 
@ypercubeᵀᴹ That was another one of my errors, as I seem to be messing up quite frequently
 
SpellCheck++
 
I left the ducks deliberately cos I liked it
 
@ypercubeᵀᴹ I'm trying to mimic your talent, I start with th etypos
3
 
off to my bus. see you all later
 
7:26 PM
byr
 
anyone know a PostgreSQL to MSSQL conversion tool that won't cost me a ton?
(work related question, not personal lol)
 
I don't, sorry
@ThomasWard is it for migrating a database one time?
 
@Lamak yep. CBA to do it by hand, too many tables.
wish we had a DBA to do this though :/
 
Migration assitant doesn't seem to support PostgreSQL (and sucks for Oracle anyway)
 
@ThomasWard that's the wrong direction
 
7:35 PM
24
Q: Easiest way to migrate a PostgreSQL database into an SQL Server one

Hut8I have a PostgreSQL database that I want to move to SQL Server -- both schema and data. I am poor so I don't want to pay any money. I am also lazy, so I don't want to do very much work. Currently I'm doing this table by table, and there are about 100 tables to do. This is extremely tedious. Is t...

 
@dezso you're right, it is in my opinion.
 
7
Q: Best tool to migrate a PostgreSQL database to MS SQL 2005?

EMPI have a database in PostgreSQL 8.3.1 that I'd like to migrate to MS SQL Server 2005 (or maybe 2008), including both the table schema and the data. The database is about 50GB in size with about 400,000,000 rows, so I think simple INSERT statements are out of the question. Could anyone recommend t...

 
but i don't get to say what my workplace does :P
they say "Do this"
 
@ThomasWard buy them out
 
and I have to say "Um, okay..."
heheh
 
7:36 PM
@ThomasWard I feel your pain
@Lamak what a compliment
 
tempted to vtc this as unclear, his answer (not being an answer) once edited in the question just makes things more confusing
0
Q: SQL Express core limits ambiguity

ThomasWe have an application that uses MSSync to download data from a server into a client's Sql Express 2005. The client's have a dual core with hyperthreading so, a total result of 4 cores. I have done a lot of research on SQL Express' limitations, and I think it comes down to 1 physical socket, but...

 
@dezso yeah, I was in a good mood
 
I edited the non-answer into the questino in a hurry before leaving for dinner and now can't figure out what his actual problem is
@ThomasWard my approach, being ignorant of any real toolkit would be to just recreate the schema and transfer the data using SSIS, but that would depend on your database size and especially number of tables and foreign key constraints
I'm sure @billinkc could talk you into using BIML if you have many tables
 
7:57 PM
@TomV The LHC only recently detected questinos. The race is on to find anti-questinos.
5
 
Could've been a typocube typo ^^
 
@TomV number of tables and FK constraints is higher than the actual amount of records lol
at least one record in each table, but IDK, this database here is archaic as heck.
if I were a DBA or a dev i'd redo it
 
Apparently a software developer having a and using a sewing kit is unusual
Anyone else have one on their desk?
 
@ThomasWard You could recreate the schema without foreign keys, load the data using SSIS and recreating constraints could work, but it looks as if a tool would suit you better
 
@TomV Yes, that's why i asked about a tool heh
 
8:11 PM
I only know one tool in here, and he may be able to help you with SSIS
7
/JK
 
@PaulWhite I read questinos as questions and was thinking "wha.....?" xD
 
@Lamak will star hat
 
@TomV but not really
 
@swasheck I just side with the majority
May 5 at 15:00, by Tom V
I only pick on the guy because as long as I side with the bullys I'm not the one being picked on
 
@TomV I wish I could star that more times
 
8:17 PM
@TomV nice
 
8:30 PM
@jcolebrand not on my desk but I have two ideas where to look
sewing kit or circular saw
 
8:43 PM
@TomV Why the answer by Hadar has -1? Seems correct to me. (am I wrong?) And with links and everything.
 
@ypercubeᵀᴹ I didn't downvote, it was a good answer to the original question, but the question seems to have changed
The original question was about licensing, but the "new" question seems to be about workload, which you pointed out in your comment on a now deleted answer
A mess ᵀᴹ
 
@TomV It sill answers one of the 3+ questions. About 2005. The edits about 2012 and 2012 Dev, I don't know. They could ammend the answer. Or we could roll back the q.
 
@ypercubeᵀᴹ I edited his non-answer in it, but if you feel it should be rolled back I possibly agree
You are right it might need to be a new question
 
Or we could edit the answer, with a short explanation about 2012. The long answer, about 2012 Dev and workload could be a new q on it sown.
 
The questino may be about licensing (initially) while the problem could be workload
but again, I agree, these might be 2 separate questinos and the answer was valid for the original
Feel free to roll back my edit and comment asking for a new question, I didn't think about that option a few hours ago but it may be the better solution
Or if you want me to do it...
I would have to look up if 2005 was about cpu's or cores (I believe it was sockets back then) and amend the answer
 
8:53 PM
@TomV Edited the answer instead. With as far as I know, which could be totally wrong ...
If anyone thinks it's wrong, please either correct it or add another answer.
 
@ypercubeᵀᴹ i can't seem to find a reference for Express any more, givern that 2005 is unsupported anyway
 
OK. The 1 cpu - 4 cores, is it correct for 2012?
 
@TomV are you trolling with those typos?
 
@swasheck it's because of typocube
 
hypertypocube
 
9:07 PM
@ypercubeᵀᴹ Had a go at editing
@swasheck I'm no longer the only troll in town
@ypercubeᵀᴹ however that is going into licensing questions (which supposedly are off topic) and less into the workload issue the question turned into
The more I think about it, the more I tend towards reverting the question back to the original, closing it as off topic (upvoting Aidar's answer in the process) and asking him to ask a new one based on the workload
Since he now states it's going single-threaded irrelevant of the license
 
(fire fighting today) But assuming you didn't use the clever PG things like their array type and what not, you Biml should be able to handle that (reverse engineer tables and forward generate into SQL Server and then build the SSIS package to push data)
Devil in the detail would be following the FK hierarchy. One day I'll finally get that figured out but 2016 has not been the year. Spent a full week trying to get that sorted out
 
@billinkc does it handle common things like converting serial/sequences to identity or sequences?
 
@ypercubeᵀᴹ One last edit, maybe this could now answer both the old and new question?
 
@ypercubeᵀᴹ Unknown. I'd have to spin up a little PG and see what happens when the magic schema crawler hits one
 
9:20 PM
one last addition, last bullet point
Haidar won't recognize his answer tomorrow
#teamwork
 
BAAHAHAHAHAHAHAHAHAHAHHAHAHAHAHAHAHAHAHAHAHAHHAHAHA
> Seattle mayor Ed Murray proclaims the Sounders the best soccer team in the world, which, um, not quite?
 
@ypercubeᵀᴹ ^^
 
@TomV Wait, we already are ;)
 
9:36 PM
@ypercubeᵀᴹ You are :)
Watch me not caring :)
 
9:51 PM
let me guess: now we are all trolling one?
 
THERE CAN BE ONLY ONE
 
@dezso I gave up trolling, I know when i'm beaten at the game
 
10:11 PM
i came here to troll fools and chew bubble gum ... and i'm all out of bubble gum
(also ... i'm out of glenmorangie quinta ruban)
 
10:28 PM
@EvanCarroll: Aside: Thinking you're wrong the first time ever, would be the second time. And that would be wrong, recursively. ;) — Erwin Brandstetter 18 hours ago
 
I'm deleting my answer for this because either way because I'm clearly wrong for the first time ever and I'd rather not be reminded of it. I have two questions for you 1) where is :* documented, and 2) shouldn't a mention to build to_tsvector('simple'..) come hand-in-hand with instructions that future querying of that tsv will require the 'simple' configuration too to tsquery? I think you should clarify the ramifications of disabling stemming on a tsvector/tsquery. — Evan Carroll 19 hours ago
done. fine. whatever.
you're a better person than i am, @ypercubeᵀᴹ
gunga din
 
Don't feed them. That's all I am saying. And I don't follow my own rules always anyway. Obviously and recursively ;)
2
@swasheck I might be better cube. Don't know for the person.
 
well ... not everyone is as perfect as i am /sarcasm
 
@swasheck bummers
 
@dezso right? that stuff is amazing for the price
 
10:39 PM
@swasheck did not taste yet, but it always hurt when one runs out of Scotch
also is it the black or the white label? I see both in a google search
 
'tis a tragedy of some sort of proportions
@dezso black
 
@swasheck I think someone could find a lot of things about us, by doing some research on the Heap and the words we use.
 
@ypercubeᵀᴹ understood. it is what it is. not sure i have much to hide, in that regard. but i do have tendencies.
 
One of us uses "far far away" quite often for example. Some others like "perfect".
@swasheck I was not talking about the troll talk specifically.
 
@swasheck must check if my favourite local whisky shop has it
 
10:42 PM
@ypercubeᵀᴹ ah. i see. just matching tendencies here to tendencies other places.
 
Just an observation I had the other day. Research + a psychologist could reveal things we might not even know ourselves ;)
 
@dezso well if you're used to top-shelf amazing stuff then you may not like it as much. however, it's one of my favorite, accessible, single malts
i'm also a big fan of highland park's stuff
@ypercubeᵀᴹ that sounds fun, actually.
hey @swasheck ... you're a wanton sociopath
 
@swasheck Isn't "coloured whiskey" the politically correct term in the US? ;)
 
wow. if you say so. :) ... black label (it's what i had on my shelf)
 
It wouldn't be a surprise if someone considered the term "black label" as racist.
 
10:45 PM
@swasheck currently, there is a Cardhu 12 yrs (mostly for my wife) and a Bowmore Black Rock on the top shelf :D
I am not really into the 100€$ range
 
@dezso that's pushing it. i'm not a huge islay fan, i discovered. my wife got me a lagavulin 16 for my birthday and it's just too smokey for me
 
BLOCKED!!!! FEAR OF THE INTERNET PREVAILS!!!!!!!!
 
I have a lovely bottle of that where... I think I've drunk it below the top label but I discovered two things in my purchase: Whisky is not whiskey. Whisky tastes like formaldehyde
 
@swasheck it's an 18 year "CAOL ILA"
 
10:50 PM
It's Caol Ila 18 year - an islay single malt that cost a pretty penny and was totally an incorrect purchase for my whiskey loving father-in-law
 
@billinkc Islay can definitely lean that way
@billinkc also ... islay is not speyside is not highlands
 
11:11 PM
@swasheck just send it over to me (that one is extremely smokey IIRC)
@billinkc you too
I am an Islay fan, as you see
 
silly quote of the day: Yerevan jokes
 

« first day (2170 days earlier)      last day (2713 days later) »