The Heap™ – Consultancy ©® - 2014-02-20 (page 1 of 3)

1:49 AM

@AaronBertrand Thanks for your interest and vote (if you did)!

Lately I am not doing as much SQL work in my new job, but I am still keeping one foot in the database, and will do more later.

FreshPrinceOfSO

2:10 AM

Anyone feel like replying?

ok so i 'CREATE CREDENTIAL AlterEgo WITH IDENTITY = 'RettigB', SECRET = 'sdrlk8$40-dksli87nNN8';' then i do what? — Fearghal 2 hours ago

Aaron Bertrand

2:57 AM

@FreshPrinceOfSO no, sorry

@ErikE I did

Moderator candidate

0

Q: Why am I being logged in as someone else?

I went to http://dev.stackexchange.com (I tried this out because I thought maybe there's a SE site for it, but it seems to redirect me to http://www.stackexchange.com) and logged in. I pressed the button that "sends SE information to this site" and I got logged in as... Blondie21?

Chris Travers

3:10 AM

That's amusing. I wonder if dev.stackexchange.com is leaking bogus test data to the world.

It seems to log one in as a random name and with random stuff in one's inbox.

Aaron Bertrand

@Chris Are you saying you're seeing the same thing?

Chris Travers

@AaronBertrand yeah, it logged me in as "pauldawg" with random stuff in my inbox.

Aaron Bertrand

But more importantly, why is he snooping around there in the first place?

@ChrisTravers weird, what exact login method did you use?

Chris Travers

openid, gmail. I am pretty sure that pauldawg doesn't log in with my gmail account.

Aaron Bertrand

Yeah, I'm just wondering if type of authentication mattered. I used OpenID GMail too, and was shown my own username.

Chris Travers

3:14 AM

However... when I clock on the things to follow to the actual links, I get logged in to the other sites as the correct user.

bluefeet

@AaronBertrand I'm thinking of writing up an answer to that gender-neutral question on meta

think I should include any details of my personal experience on SO? you have seen some of the comments

swasheck

holy crap it's thunderhailing here

Aaron Bertrand

@bluefeet sure, especially if you can find any that haven't been deleted.

bluefeet

@AaronBertrand that's definitely going to be the hard part - I've been looking

Aaron Bertrand

You could also ask tim or shog or someone to screen shot a deleted comment for you, if you remember where any were deleted (obscuring the poster's name of course)

bluefeet

3:19 AM

@AaronBertrand good idea - I'll ask them I think I still have the link

Simon Righarts

Hmm. Getting LinkedIn requests from people I don't recognise is a bit weird

Phil

@MikeFal DevOps always means a bad non-separation of development and operations, which leads to rapid deployment cycles with poor testing, and crappy software quality. Just my experience/take. Also the reason I will never work for a small company again

Shog9

From commit to production in < 10 minutes, that’s why I love working here.

Tweeted by Nick_Craver on February 19, 2014 at 4:41 PM

bluefeet

hey @Shog9 I asked Anna via twitter but any chance you can give me a screengrab of the deleted comments on stackoverflow.com/a/20253661? I'm looking for examples for the gender neutral question on meta

Simon Righarts

@Phil It doesn't have to be that way though. Admittedly I have limited experience but dodgy deployment practices are orthogonal to having a devops group

Phil

3:34 AM

@SimonRigharts I tend to agree. DevOps does suit very small companies that are extremely agile - I don't deny that

Shog9

@bluefeet sure

Aaron Bertrand

TIL @Shog9 is always here, waiting to pounce on something

(or someone)

Phil

But anything bigger than that needs a separation of dev, test and support to enforce quality

Shog9

Shog9 ♦, Not looking over your shoulder

191k 66 483 966

discussion feature-request support status-completed stackoverflow review bug

It clearly states that I'm not watching. I don't know why you would doubt such an honest face.

Aaron Bertrand

bwahahaha

swasheck

3:36 AM

@SimonRigharts did you get my earlier message? did you get all you needed for the blocked process report?

Aaron Bertrand

Next you'll offer me a nice bridge in Florida

Chris Travers

@Phil I think one of the big issues is that one needs to have a real role for an engineering role. Unfortunately as you broaden the focus (devops for example), that becomes a lot harder.

Simon Righarts

@Phil Oh yeah sure if you don't have dedicated devs or dedicated testers or dedicated operations people you're going to have issues. There is a happy medium somewhere in the middle where devops helps dev and QA and dev and ops and QA and ops work together more effectively though

Phil

Yo @Shog9 - you should hang around in here more often anyway. We all like beer. The talk is less than 50% databases :P

Shog9

mmm, beer

Simon Righarts

3:37 AM

@swasheck We landed up parsing the inputbuf for the object_id embedded in it, so yeah I guess?

(it took us probably half an hour to write the xpath query for that, god I hate xpath)

Phil

You need a barrier though. When the devs are the operational people, testing isn't as good. Just whack it in production anyway

Chris Travers

I mean IMO, you'd have engineering which would handle design and testing, and then you would have development and support answerable to them.

Phil

It's 3:37 - I just escaped from a lock-in - they were still serving beer

bluefeet

@Shog9 thanks!

Chris Travers

My experience is that a lot of devs suck at testing

they test the wrong things....

swasheck

3:39 AM

@SimonRigharts fahhhbulous

Chris Travers

hmmm let's test how our dependencies behave internally!

bluefeet

@Shog9 feel free to remove that I grabbed it :)

Simon Righarts

@Phil yeah, I'm referring to having devs as a group, testers as a group, ops as a group, and devops also being a group sitting between all of them and making things better

Aaron Bertrand

@bluefeet please let me edit that image

Phil

That is completely different

Simon Righarts

3:40 AM

(v. idealistic view, I know)

Aaron Bertrand

...before you use it

bluefeet

@AaronBertrand haha what are you going to do to it? I'm still formulating my answer.

Simon Righarts

@bluefeet Nothing good, I'd guess

bluefeet

trying to decide exactly how much I want to state about my experiences

Chris Travers

@SimonRigharts The problem I think is that you really need good design before you can test, and you need good tests before you can assure your deployment will work properly.

Simon Righarts

3:42 AM

@Phil Yeah I guess the problem here is the irresponsible naming conventions prevalent everywhere in IT :P

Shog9

@bluefeet When in doubt, "I was raised by wolves" is usually a good start to a memoir

Aaron Bertrand

@bluefeet just removing the comments that still exist (someone could search for them and come across the people likely involved)

That makes me feel a little better

Shit, missed on

bluefeet

I was planning on hiding anything that would be obvious

Aaron Bertrand

Ah, there

Phil

By way of example, I'll run rings around most Linux/Solaris/HPUX/AIX sysadmins, but I call myself a DBA. I started off as a business analyst and have done entire project lifecycles on $20 million+ projects. I must be devops!

Did I just call myself crap? :P Haha

Simon Righarts

3:45 AM

@ChrisTravers This all depends on how risk-averse your company is. If you're making firmware for pacemakers I'd sincerely hope your shit is tested forwards, backwards, upwards, downwards and sideways. If you're writing a generic CRUD webapp you probably don't need as strict a set of testing requirements.

Phil

The same goes for scale though

Chris Travers

@SimonRigharts I have maintained webapps that were untestable. Unfortunately I have a fairly good idea of what the costs are. One of the huge issues though is that most devs don't really have a good sense of how to go about testing. IMO, testing is not something that should be left to devs but should be handed back to the software engineers and architects.

Phil

I'm from a telco background - stuff has to work when transactions have financial implications and there are billions of them

Chris Travers

@Phil I haven't dealt with that scale, but most of my work is financial stuff.

Phil

Medium t olarge sized companies should have dedicated technical testers, end of story

Chris Travers

3:49 AM

But even without the financial side..... If you can't keep your module contracts clean and tested, your pace of development will eventually suffer.

Simon Righarts

@ChrisTravers Somewhat agreed. Yes, testing shouldn't be left to devs, but it shouldn't be on the architects either. You need dedicated test/QA people

Chris Travers

@SimonRigharts The immediate question is what you test IMO. There's some value in having at least the initial test cases written by the people who design the module contracts.

That doesn't mean there isn't room for dedicated test/qa people for more tests, security testing, etc.

Aaron Bertrand

Shoot me

0

Q: Error creating database in Management Studio

Trying to create a new database but then I got this error: Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (SqlMgmt)

sql-server sql-server-2012 ssms

Simon Righarts

@ChrisTravers Agreed. That said, QA is a specialised field that architects/devs shouldn't be expected to master as well

Phil

So did that Bohemian person end up dropping out?

bluefeet

3:54 AM

@Phil nope they have 7300+ votes at this point

Aaron Bertrand

@Phil nope

Phil

See nothing on meta.stackoverflow.com/questions/221594/…

Simon Righarts

Hasn't answered the questions, is still nominated

bluefeet

@SimonRigharts answering isn't required

Aaron Bertrand

@Phil correct. Hopefully voters see that as a preview to the commitment we might expect if he's nominated.

Phil

3:56 AM

Hasn't made a single comment in the chat room either

Aaron Bertrand

Nope

bluefeet

@AaronBertrand It didn't seem like Bohemian knew about the Q&A but the comments are now deleted from meta

Aaron Bertrand

@bluefeet interesting, wonder if they were self-deleted

Most recent comments from him on meta seem to be on this answer:

16

A: Why is there a primary election?

I only have limited time and willingness to carefully consider lots of candidates. The primary cuts down the number of candidates to those that has some chance of winning, so reducing the effort needed to decide how I vote. At the primary state, I just give a quick up vote to candidates that I...

Sadly I can't see deleted comments there.

There is, though, still a comment from Loomarak there pointing Bohemian directly to the Q & A. So he may be able to claim ignorance for not answering it before that, but not since.

Thinking of creating a meta question asking why the questionnaire isn't mandatory

Shog9

@AaronBertrand If you do, save it for after the election, please. We aren't changing the rules half-way through if we can help it.

so, just drama

good to discuss it for the future though

Aaron Bertrand

@Shog9 you mentioned that it isn't a requirement - can you explain why answering the questionnaire isn't mandatory?

Also I wouldn't be raising the question on meta so that you can change the rules in this election. For the long term, of course, but more importantly, to raise awareness to the fact that some people don't think it's worth their while

Shog9

4:13 AM

@AaronBertrand Really wasn't considered all that important until fairly recently.

Don't get me wrong - this sort of thing has come up before.

cough MATH cough

If we were gonna make it mandatory, it might actually make more sense to run the questionnaire first and then just have folks answer in their nominations instead of a whole separate meta thing.

bluefeet

@Shog9 yes that would be easier

Chris Travers

@SimonRigharts Sure. no problem with that statement. Also there are certain areas I don't think the engineers are in a good position to test for (buffer overruns for example). There are projects (mostly small ones) where I wear every hat out there: software engineer, architect, dev, tester, support provider, etc. But what's really important in those cases is to put the engineering first and to actually wear the hats....

(i.e. not approach testing as a developer)

Aaron Bertrand

4:38 AM

Well, he answered, finally

1

A: 2014 SO Moderator Election Q&A - Questionnaire

Good luck all! Q1: An asker repeatedly flags their own question and says that they need to delete it or they'll be fired, because they mistakenly posted proprietary code. There are several good answers on that question. What do you do? Well firstly, a person's job is more important that the...

But still:

0

Q: Make moderator election questionnaire mandatory

Note: Before I even begin, I want to stress that this is for the next election, not the current one currently. I can understand why candidates may want to opt out of the moderator election chat room - for some people chat is just not their thing, and it is not an official moderator duty IIRC...

feature-request election nominations

@Shog9 I made it very clear - multiple times - that I am not suggesting the current election be changed. I also left out a paragraph or so about why opting out of the questionnaire is unfair and what some of the potential side effects could be.

bluefeet

ugh I feel like my gender neutral answer is rambling nonsense, maybe I don't post an answer

Aaron Bertrand

@bluefeet share it here, I'll read it

bluefeet

its looooong

Aaron Bertrand

ok

Shog9

must... not... tweet "bluefeet sez: gender neutral == rambling nonsense"...

bluefeet

4:41 AM

@Shog9 nice

its probably because it is way past my bedtime

Shog9

@AaronBertrand looks good

bluefeet

forget it, I'm gonna write up a blog post on my site. I think it will get too off-track for that question

Shog9

1. Write blog post
2. Link to it from heavily-traffic'd MSO post
3. ???
4. Socks! er, Profit!

swasheck

5:09 AM

playing with Ghost.

my displeasure with wordpress has reached its tipping point

Aaron Bertrand

Wow, if you dislike Wordpress, you'll hate community server

Seriously, try it, Wordpress is heaven in comparison

(No experience with ghost, though)

swasheck

hahahaha ... isnt community server some bastardized version of wordpress in an aspx container or something?

Aaron Bertrand

@swasheck pretty sure it pre-dates wordpress

swasheck

@AaronBertrand could be. i'll defer to your expertise. learning through the pain of others is an underrated skill

@AaronBertrand just got a funny email from a developer

"i have this query and when i change the search parameters things get slower" ... said query has 5 CTEs ... all unfiltered SELECT * one of them is ~4bln rows.

the "faster" hits the CI and somehow the optimizer pares things down to 45k rows from that table. other queries hit a NCI and returns 6million rows

with a gnarly nested loop

plan explorer gave me a good chuckle

Aaron Bertrand

ha

swasheck

5:21 AM

i was impressed that the optimizer compensated as much as it did.

Aaron Bertrand

We've got a live one here

0

A: Make moderator election questionnaire mandatory

Requiring the questionnaire doesn't actually solve any problems. I like the questionnaire. I really do. Requiring it, though, doesn't seem to address any existing significant concern, so I'm not sure it needs to be changed.

Basically, "well, I don't think you've explained why this should be required, so I think we should continue allowing moderator candidates to not bother answering the questions by which they should be judged"

</facepalm>

WTF does this even mean

I think I'm sort of miscommunicating here. I'm not opposed to the idea of it being a requirement, but simply the idea of changing such a minor feature. i.e. [Does it need to be changed? Y/N] [Y: Change it.] [N: Don't change it.] / The current suggestion falls under N. — Emracool 1 min ago

So you're not opposed to making the questionnaire mandatory, but you're opposed to changing a minor feature that would allow the questionnaire to become mandatory? shrug

swasheck

@AaronBertrand get some sleep, or do you not require such base human things

Aaron Bertrand

Can't sleep. Someone on the internet is a moron

swasheck

oh man. you're in for a lot of loooooooooooooooooooooooooooooooooong nights

Paul White

@swasheck Yes.

Andriy M

7:27 AM

possible duplicates:

2

Q: How to prevent a SQL query (MYSQL) read off the entire table?

I have a table in MYSQL Table1 database that contains 2 million records, I would make an appointment and to return only the first 10 records; Then the next thought: SELECT FROM table1 LIMIT 10;, which returns only the 10 records. When I run EXPLAIN SELECT from table1 LIMIT 10; reports that come...

mysql sql database

0

Q: Working out elapsed time from two columns in ORACLE SQL

I have two rows stored in a table called client_booking. These are called start_time and end_time. I need to create a text box in ORACLE APEX which generates the elapsed time through an SQL query.

sql oracle table apex

(not duplicates of each other but of other questions)

bluefeet

11:03 AM

@Shog9 I wouldn't link it from the MSO post - no profit here - just my rambling thoughts off the network. I'm still deciding

bluefeet

11:47 AM

@AaronBertrand @Shog9 answered

0

A: Does the SO community view itself as gender neutral?

Gender neutral is very difficult especially when you are dealing with users online because while you don't know who is on the other end, as Jaydles said I think most of us assume person is a man. Is that right, no? - but it is just what happens. Personally, when I am dealing with users, I typ...

Erick Robertson

12:10 PM

wow, that EXPLAIN SELECT LIMIT 10 question is a great example where the asker wrote a poor subject line, and then at the bottom of the question body, asked a direct question that made a great subject line

lol, so I swapped them :)

if anything, this makes it even more clear that it's a duplicate question, and I also submitted my close vote

FreshPrinceOfSO

12:43 PM

@AaronBertrand i think they withdrew

@AaronBertrand d3j5vwomefv46c.cloudfront.net/photos/large/…

ypercube

I cannot understand thi sguy

@ypercube well i don't care why i typed 767 in the answer actually.. but nice that you are tying to explain it to me.. — Raymond Nijland 3 mins ago

Einsteins Grandson

Is it possible to import SQL scripts into a blank Database that I created in MS SQL Server Management Studio?

If so, how?

FreshPrinceOfSO

@EinsteinsGrandson using the import export wizard

ConcernedOfTunbridgeWells

@EinsteinsGrandson Open the file with SSMS and execute the scripts.

bluefeet

@FreshPrinceOfSO nope, they are still in it

FreshPrinceOfSO

12:57 PM

@bluefeet goes to show how much i'm paying attention

bluefeet

2:00 PM

please vtc

0

Q: Convert specific columns to rows with some other columns

Hi have this query in SQL Server 2008R2 Column1 Column2 Column3 Type Quantity 7 191 95 94 2 7 333 58 94 1 32 656 58 94 1 7 191 95 95 4 7 333 58 95 1 32 656 58 95 2 I need to...

sql-server sql-server-2008-r2 pivot

and

1

Q: How to get Oracle Rows as Columns with count .?

Here is my table view. [column names & records]. MERCHANT_ID |CARD_TYPE |DENOMINATION |STOCK_IN_HAND 1000017 |CDMA_PP |1000 | 5 10000000 |CDMA_PP |50 | 1 10000000 |CDMA_PP |500 | 1 10000000 |CDMA_PP |1000 | 1 10000001 ...

sql oracle pivot

FreshPrinceOfSO

done and done

nice

bluefeet

2:48 PM

please vtc

0

Q: SQL Separate Row

I have table ABC containing data as follows: ID Data 1 text|text|text 2 text|text|text What is the query so I get the following result? ID Data 1 text 1 text 1 text 2 text 2 text 2 text Could this Code be the correct way? How to use it so I get the IDs for the Data records?

sql sql-server-2008

Aaron Bertrand

A lot of people just really don't get my point. :-(

11

Q: Make moderator election questionnaire mandatory

Note: Before I even begin, I want to stress that this is for the next election, not the current one. I can understand why candidates may want to opt out of the moderator election chat room - for some people chat is just not their thing, and it is not an official moderator duty IIRC. But I c...

feature-request election nominations

@Shog9 Can you explain what happened in the math election where a candidate not answering the questionnaire caused an issue?

And ugh, I want to punch the people who migrated this garbage here

0

Q: SQL Server 2008 installation errors

I am stuck here. I tried reformatting my laptop, re-installing SQL Server 2008 but I keep getting these errors. I don't know what to do. I really need this program for my project. Damn. I got these errors every time I'm installing SQL Server: Your SQL Server 2008 installation completed with ...

sql-server sql-server-2008

Will do

Thanks!

bluefeet

3:10 PM

sure

FreshPrinceOfSO

@AaronBertrand pssh anonymous

bluefeet

oh an @AaronBertrand in my answer about the gender neutral SO - you were first person I ever corrected :)

FreshPrinceOfSO

@AaronBertrand anything you're looking for in particular?

Aaron Bertrand

@bluefeet you can name me in that answer if you like (in fact I was surprised you didn't)

Andriy M

@AaronBertrand I wouldn't want to punch a renown boxer.

Aaron Bertrand

3:12 PM

@FreshPrinceOfSO honesty. What bugged you about bohemian not answering the questionnaire (and/or abstaining from chat)?

Zane

Not enough information dude. — Zane 7 secs ago

FreshPrinceOfSO

@Zane NEID!! (in german accent)

Zane

Removed comment no Fun @bluefeet

@bluefeet What about gender neutral SO?

bluefeet

@AaronBertrand updated :)

26

Q: Does the SO community view itself as gender neutral?

The website design and formatting of Stack Overflow is very gender neutral, but most users (arguably) come to the site for user content. So a question (or two) to ALL fellow users: When posting a question/answer/comment do you try to keep your post gender neutral (by thinking about correct pron...

discussion community demographics

Aaron Bertrand

Nice!

bluefeet

3:15 PM

I should have given props in the first place, my bad!

Aaron Bertrand

No worries at all, don't know if that's props really, just confirms that I do make those assumptions (and you were the first person that made me realize I shouldn't).

bluefeet

@AaronBertrand well the props would be for how you reacted.

Aaron Bertrand

@bluefeet ah, true

bluefeet

unlike so many others

Aaron Bertrand

sad that something like that stands out to you. Should be the opposite.

Zane

3:19 PM

@bluefeet You cut that comment thread before I ridiculed that guy... lol

Aaron Bertrand

@FreshPrinceOfSO thanks, I get those points, but they don't involve the questionnaire directly

Lamak

@AaronBertrand I don't think that people in meta are willing to change their minds about anything really, no matter how compelling the point is

Aaron Bertrand

@Lamak probably true, but I hope that making compelling arguments against the status quo and "what harm?" people will sway other readers who haven't made up their mind

Lamak

I tried to explain why I found the primary phase of the election an important one to bohemian, and the same goes to the questionnaire. And I also find it funny that he deleted the comment asking "what questionnaire?"

Aaron Bertrand

Thanks guys, updated

Lamak

3:22 PM

I mean, how less engaged on this election can you be?

Aaron Bertrand

15

Q: Make moderator election questionnaire mandatory

Note: Before I even begin, I want to stress that this is for the next election, not the current one. I can understand why candidates may want to opt out of the moderator election chat room - for some people chat is just not their thing, and it is not an official moderator duty IIRC. But I c...

feature-request election nominations

FreshPrinceOfSO

@AaronBertrand just saw this. got my upvote.

dezso

I decided to play @FreshPrinceOfSO:

Stale memory? Where do you buy such? My tables are stored on disk... — dezso 32 secs ago

bluefeet

@Lamak you can tell from his recent posts on meta that they are not really involved with the site besides answering

FreshPrinceOfSO

@dezso i rub off on people in some good ways

Lamak

3:23 PM

@bluefeet I know. As I said before, he earned my downvote the moment I read the meta question about identifying the guy who downvoted him

that's not how a mod should act

FreshPrinceOfSO

@AaronBertrand I'm tempted to answer

Lamak

I mean, I've been more engaged in each election as a simple user (even though I barely flag anything), than this guy who is actually running for an election

Aaron Bertrand

@FreshPrinceOfSO please do

billinkc

That hurts me to even think about

0

Q: Flat file connection can't read text fields over 65,536 characters

As part of an ETL process I'm building, I'm receiving a few files that contain very large fields. These are XML documents that our vendor has embedded within CSV files, so that instead of a number of XML documents named with an ID, we have one large CSV file that contains each ID and its associat...

sql-server ssis

dezso

@Lamak he earned mine for this:

> Like good code, answers and especially questions should be a brief as possible (without losing meaning or legibility). Reflect that we're building a knowledge base here, not a blog site. I will guide users to this end

this is so untrue

JNK

3:34 PM

@dezso Yeah disagree as well. See any of martin smith's most upvoted answers on DBA

they are basically awesome blog posts

billinkc

Anymore, I tend to write my blog posts as answers then copy paste them into my blog.

Mike Fal

@Phil See, the mildly amusing/frustrating thing is that when I got here, we were a mid sized company trying to put our big boy pants on. Now it seems like we want to go back to the days where we run around with our junk hanging out.

Zane

@bluefeet Not sure if I entirely want to post an answer to that question.

swasheck

had a dream about being in a small plane crash and then having to escape a grizzly bear attack. yep, that's right. i must be on call

FreshPrinceOfSO

okkkkkkaaaayyy

0

A: Make moderator election questionnaire mandatory

The questionnaire should absolutely be mandatory. While I haven't analyzed previous elections, I would guess that higher rep users are carried in elections. This election, it has led to a particular candidate to completely ignore requests to participate in chat or the questionnaire. The problem...

swasheck

3:40 PM

@PaulWhite how about now?

@AaronBertrand what's it mean when i have Seek Predicate AND Predicate in the details of an Index Seek?

bluefeet

@Zane I really struggled writing something but I wanted to provide my own perspective. I actually cut out a lot from that answer - it was a bit more personal

Aaron Bertrand

@swasheck can I see?

swasheck

@AaronBertrand you want the full plan?

Aaron Bertrand

Sure

FreshPrinceOfSO

@swasheck I want the full plan and nothing but the full plan!!

Aaron Bertrand

3:43 PM

You can't handle the plan!!!

2

JNK

WHO ORDERED THE TABLE SCAN?

FreshPrinceOfSO

@JNK i asked for a side of key lookup and you gave me a table scan?!?!

Zane

0

A: Does the SO community view itself as gender neutral?

Alright I'm going to answer from my perspective. For a little background I'm 27 and have only been working in IT for a little over three years. When I answer a question it is incredibly rare that I think/try to keep my comments gender neutral it just sort of happens. I use the @UserName the maj...

JNK

@FreshPrinceOfSO was a few good men reference

"WHO ORDERED THE CODE RED?"

swasheck

@JNK not even.

FreshPrinceOfSO

3:48 PM

@JNK sorry for ruining it. never saw it.

swasheck

@FreshPrinceOfSO dont feel bad. neither have i

JNK

oh lord

you really should

Rob Reiner, Aaron Sorkin, Cruise and Moore

and whos that other guy

JACK NICHOLSON

Zane

Great movie.

JNK

yeah its awesome. Both of you leave work and go rent it now

Tell them the heap said you had to

FreshPrinceOfSO

@AaronBertrand what do you think?

Why not just make an election SE site where candidates can only answer? The questions would be ready for them, then they have n days to answer them. After that period, the candidates with the most rep move on to the election phase? — FreshPrinceOfSO 13 secs ago

@JNK i'm at home in my underwear

Zane

3:52 PM

@bluefeet The trend is certainly going in the right direction. Over half of my team is made up of women.

swasheck

@FreshPrinceOfSO i'm at work in my underwear.

i have pants on over them but ...

FreshPrinceOfSO

@swasheck i'm surprised you wear underwear to work

gbn

@swasheck On the outside of you trousers though?

bluefeet

@FreshPrinceOfSO why most rep?

Why not just make an election SE site where candidates can only answer? The questions would be ready for them, then they have n days to answer them. After that period, the candidates with the most rep move on to the election phase? — FreshPrinceOfSO 3 mins ago

Aaron Bertrand

@swasheck thanks, I will take a look today, not this moment though

@bluefeet I think he meant most rep from those answers on that separate site

James

3:55 PM

@ConcernedofTunbridgeWells Won't be able to make it tonight as I've got the flu. Hopefully next time though

swasheck

@gbn works for superman

@AaronBertrand no worries. thank you

Aaron Bertrand

Highest score would probably be better (up-vote = +1, down-vote = -1)

swasheck

@James the best way to cure the flu is a few doubles of whiskey

Aaron Bertrand

Instead of the disparity we have now, where +2/-2 = +16

bluefeet

@AaronBertrand that would be better

dezso

3:59 PM

So, I'm refactoring a query full of RIGHT JOINs while the Taleggio cheese I bought is slowly killing the colleagues around

FreshPrinceOfSO

@bluefeet from the answers...

And by most rep, I mean rep from the answers they provide. — FreshPrinceOfSO 1 min ago

swasheck

@dezso serves them right

FreshPrinceOfSO

4:19 PM

TIL about historic locks

bluefeet

my state is awesome - azcentral.com/news/politics/free/… NOT!

FreshPrinceOfSO

@bluefeet dem conservatives

are you surprised?

bluefeet

@FreshPrinceOfSO sadly no

Zane

@bluefeet Did you see google fiber may be coming to pheonix.

FreshPrinceOfSO

good otherwise we would have to have a heart to heart

bluefeet

4:25 PM

@Zane i didn't. thanks for letting me know

Zane

@bluefeet Phoenix is among the 9 cities they are considering fo the next fiber roll out.

@bluefeet Not that I agree but do you really want to give your business to anyone who would discriminate against you for your sexuality if they could?

bluefeet

@Zane nope never

FreshPrinceOfSO

@Zane if we were only more like developed countries

Aaron Bertrand

@Zane simple, layperson's terms - what is the big deal about google fiber? Is it free or something?

FreshPrinceOfSO

@AaronBertrand gives you good poops

Aaron Bertrand

4:28 PM

ma ha

Zane

Lets keep the bigots out in the open. Then all of us who aren't colossal ass-holes can spot the doesn't serve same sex couples and take our business elsewhere. It allows good people to discriminate against homophobic people.

@AaronBertrand Other than the bonus of better poops. It's incredibly fast internet for a very low price and the price just is what it is. Theres none of the current jacking around that we get from our current companies.

swasheck

@FreshPrinceOfSO sign me up

FreshPrinceOfSO

@swasheck @AaronBertrand Google TISP

swasheck

yep

Zane

Also any sort of competition in the broadband department is direly needed. Most Cable companies across the country set up monopolies with the local munisipality.

Aaron Bertrand

4:32 PM

Uh, google.com/tisp/install.html

FreshPrinceOfSO

@Zane @AaronBertrand Likely pressured by Google Fiber, Time Warner ups speeds, slashes rates

wow i don't know how to internet

Zane

@AaronBertrand this is why I want Fiber.

fiber.google.com/cities/kansascity/plans

FreshPrinceOfSO

Damn, 1 TB of storage on Google Cloud :)

Zane

I'm paying 90 a month for 20mbps max internet at the moment.

Aaron Bertrand

I'm paying $0 for ~42

FreshPrinceOfSO

4:36 PM

Doesn't your wife's work pay for it?

Zane

@AaronBertrand ??

FreshPrinceOfSO

Some Comcast rep stopped by our house and was like I'll give you 2 years of 50 Mbps/down for $30/month

Aaron Bertrand

@Zane wife's work pays our bill (she works for Cox, RI's Comcast, direct competitor to FiOS)

FreshPrinceOfSO

^ that's ironic

@Zane you also get a Nexus 7 tablet with the TV + Internet package.

Zane

@FreshPrinceOfSO See we've been a customer for over 2 years and are therefore getting trusted customer discount of +40 a month to our bill.

Aaron Bertrand

4:37 PM

@FreshPrinceOfSO we're spies

Zane

@FreshPrinceOfSO It's pretty sweet.

FreshPrinceOfSO

I wish someone explained where they disagree with my meta answer .. +4/-2

Aaron Bertrand

@FreshPrinceOfSO they probably just think you down-voted theirs

FreshPrinceOfSO

@AaronBertrand no proof

;)

Zane

@AaronBertrand we don't have a direct competitor it's slow DSL that can't handle our workload or its Comcast.

swasheck

4:41 PM

for us it's comcrap and centurystink

Zane

They give the City of Minneapolis money for exclusive rights to have us completely by the balls.

swasheck

@Zane yeah. same here

Zane

@swasheck It sucks sooo bad. There is zero incentive for comcast to provide use anything resembling service.

swasheck

it's really pretty bad here too. pay higher prices for lower service

Aaron Bertrand

Uh, serious deja vu

1

Q: What are the criteria for an acceptable question title?

I am trying to post a question, but the title of the question is apparently not of an acceptable quality, resulting in an error. What are the criteria for an acceptable question title?

support asking-questions title

Zane

4:45 PM

Its more than likely that your question has been asked before and you should look at the accepted or highest voted answer and apply that solution to your problem. — Zane 6 secs ago

Aaron Bertrand

@Geobits sigh I'm sorry that you don't understand the point, but I can't really spend all day educating you about it. — Aaron Bertrand 12 secs ago

bluefeet

vtc please

0

Q: table rows to column using MS sql pivot

I have following table: ID Reason 1 a 1 b 2 c 3 d 3 e 3 f and I would like to use Pivoting to get following results: ID c1 c2 c3 1 a b null 2 c null null 3 d e f The number of columns (c1, c2, c3... ) can be more. I am no...

sql pivot

FreshPrinceOfSO

So they answered

8

A: 2014 SO Moderator Election Q&A - Questionnaire

Good luck all! Q1: An asker repeatedly flags their own question and says that they need to delete it or they'll be fired, because they mistakenly posted proprietary code. There are several good answers on that question. What do you do? Well firstly, a person's job is more important that the...

ypercube

@FreshPrinceOfSO they?