The Heap™ – Consultancy ©® - 2017-03-23 (page 1 of 2)

7:05 AM

'

7:44 AM

morning

8:04 AM

ello

Good '

hell-o

8:20 AM

G M

Had a moderate earthquake half an hour ago.

🛢♏orning

@PaulWhite is 4.8 moderated?

Yes. Especially 50km deep.

And at 10 km from the epicentre.

I only mention this one particularly because the epicentre was only 10km from my house.

Ah. As @AndriyM says.

Was that the closest to your house you've ever had?

8:30 AM

So around 51km in direct line

@AndriyM I think so. Certainly the one we've felt most strongly. There are tiny quakes all the time of course, which we never feel or hear.

It is quite rare to have a decent sized one centred so close though.

9:03 AM

@PaulWhite thnx. I guess you meant the recent, closed as duplicate.

@ypercubeᵀᴹ Yes, my reply was linked back to a hopefully relevant Heap message. Anyway, it was this question and the work you did with comments and chat especially.

Almost as good as a mod. I even remembered to edit the "lets create a chat room" message ;)

My thinking exactly.

10:44 AM

When I've posted Greenplum questions in the past, I've been advised to tag them as Postgresql unless they are specifically related to the distributed nature of Greenplum. In the case of my most recent question, it turns out the answer is identical for both so both tags were appropriate. — PhilHibbs 1 hour ago

^^^ thoughts, postgres people?

10:56 AM

@Philᵀᴹ I've got SQLite working, though it's a bit rough and ready: dbfiddle.uk/?rdbms=sqlite_3.8 — it's currently creating databases in-memory but I could easily change to temporary files if that would be better.

Philᵀᴹ

Coolio

@JackDouglas while in certain cases it might make sense to use both (especially in hindsight, when the solution turns to be one based on Postgres 8.2), I would not encourage it, to say the least

thanks @dezso that sounds right to me too

what about the particular case of his question?

and with some luck, Postgres itself will render Greenplum useless in the next few major releases <whishful thinking off />

@JackDouglas well, the question mentioned originally already lacks mentions to Postgres, and rightly so

12:36 PM

anyone awake?

pinging @anyone

haha

@ypercubeᵀᴹ you have any mysql experience?

/eject

Yes, some. Unfortunately.

I am having a weird issue with LOAD DATA LOCAL INFILE, where it accepts the first column of data from my csv file, but puts NULL in all the other columns

any idea what might cause that?

12:41 PM

Put a small sample of your data and your code in a gist or pastebin or in a question at the site

(code meaning): CREATE TABLE and LOAD DATA statements

Could be some rogue character. I'd try and see what the data look like in hex view.

DANGER: This will DELETE YOUR ENTIRE DATABASE! technet.microsoft.com/en-us/library/… — adamjcooper Sep 17 '13 at 19:50

Looks like I can't edit the answer myself

@DavidWilkins ... without the code (FIELDS TERMINATED BY ... LINES TERMINATED BY) and the column types we cn only guess

@bluefeet has something changed with the suggest edits feature on SO?

Hmm, I can suggest an edit now, maybe the question has been inactive for too long or there was a javascript issue

@TomV Was the "edit" link inactive or just unresponsive?

12:47 PM

http://pastebin.com/jQZ03D1N = data
`LOAD DATA LOCAL INFILE '/home/dwilkins/xaa.csv' INTO TABLE po_2016;` = statement
I can give the table structure, but what is weird is this worked fine with another table...The only difference is I created the other table with a raw import using phpmyadmin, but I created this one with `CREATE TABLE po_2016 AS SELECT * FROM first_table WHERE 0`

@AndriyM inactive

let me try creating the new table the same way I created the original real quick

ConcernedOfTunbridgeWells

@TomV Ah, don't know then. Links like "edit" sometimes don't work for me, and usually it turns out the page is still loading some bits.

@Lamak No, but he used to.

@TomV Slightly changed your wording but only for the sake of approving your edit immediately.

12:58 PM

@ConcernedOfTunbridgeWells yeah, good thinking

bluefeet

@TomV link to question?

@bluefeet This answer: stackoverflow.com/a/3305146/297408

bluefeet

Huh, weird. No changes that I'm aware of

@bluefeet it fixed itself after a couple of refreshes

@TomV you mean @bluefeet fixed it

1:10 PM

It was a matter of who would give up first (Tom or JavaScript). Apparently Tom was Victorious.

@AndriyM Having some co-workers copy pasting random code from the internet I was a bit stubborn with this change

Q: What happened to the database
A: Oh I found some code on the internet that promised to kill all connections

A: Why is the edit button disabled?

105

There are a handful of conditions where we will stop accepting suggested edits: A large number of suggested edits by you were rejected in the past week (at least 5 more than one-third of your accepted edits). We are out of empty slots in the queue (40, with several exceptions. See here for deta...

@PaulWhite Thanks

Next time, hover :)

(The tooltip should say why the edit link is disabled)

bluefeet

@Lamak magic!

1:25 PM

yeah, I mean, how else could someone explain your blue feet?

Cold?

Oh, upside of Jack making my children starve by stealing away my unicorn points is that I've now earned the populist badge

2

lose/win

@billinkc Quite a rare one, that. You might want to frame it and display it somewhere nice.

@PaulWhite I'll hang it in your spare room when I come live with you next summer

1:41 PM

I'll make some space on the wall.

I guess the KFC dartboard can go.

Who is the greatest? Why me of course

@PaulWhite what did you do to deserve that punishment?

A: Sql Server Management Studio slow opening new windows

1

SQL Server Management Studio Startup When Microsoft's SQL Server Management Studio (SSMS) starts it tries to connect the Certificate Revocation List (CRL) of Microsoft: http://crl.microsoft.com/pki/crl/products/MicrosoftRootAuthority.crl The underlying .NET components of SSMS are trying to con...

Good answer to an old question ^

:(

MWAHAHAHA

1:44 PM

Such abuse

Good effort though :)

@billinkc Typical Populist.

@PaulWhite Why thank you :-)

@PaulWhite 16 undeleted answers in that question! (and 2 deleted). Must be some record

@hot2use It was very timely. I was just looking at that Q & A an hour or so ago and despairing at the enormous number of very average answers.

@ypercubeᵀᴹ I assume most were present before it came from SO, or were attracted by the bounty. Still, it's another of those old questions that don't necessarily reflect the best of dba.se

anyone here know RG?

1:48 PM

@PaulWhite I came across this issue a couple of times behind a corporate firewall and figured it out. Glad they have some blog articles on it now.

MAX_MEMORY_PERCENT is supposedly an INT which seems ridiculous... I suspect that I'm doing something wrong

@hot2use Yes I recognised your answer was the right one even though I had personally forgotten the root cause, having never experienced it myself, only heard of it second hand.

@PaulWhite that's because it's a new-ish issue

;)

@Lamak Oh shush!

@Lamak I had it in SQL 2008 the first time

1:52 PM

@hot2use ah, no, it was just a joke

23 hours ago, by Lamak

@JoeObbish are you saying @PaulWhite only blogs about old things?

@Lamak I will remind you, sir, that jeagl is active on this room.

4

I just noticed that, good thing

@PaulWhite @Lamak got it

@McNets I didn't mean you to delete that answer. You had a warning (about RI) which was fine. I commented so you can add another option to solve the issue.

He sometimes deletes then later undeletes when he's rethought.

@JoeObbish RG? Oh. Resource Governor.

2:00 PM

@ypercubeᵀᴹ I know, but I'm trying to redefine my answer, and meanwhile I prefer to delete it.

Tada.

@PaulWhite Yes. Is that not a common abbreviation?

Can somebody point me to a case where RG helps? A friend of mine visited a "SQL Server Performance Tuning and Optimizing" course and I think my friend recalled hearing that RG can be the root cause of performance issues and frankly should not be used. It breaks more than it fixes.

@JoeObbish Maybe. It took me a moment to grab the context though.

2:16 PM

@hot2use Let's say that you have a workload that sends thousands of queries to be run against the database as part of the batch. I believe by default SQL Server will give a query up to 25% of a server's memory in a grant. Once a query has a memory grant it will not let any of that memory go.

If a query cannot get its minimum memory grant it will wait for up to 24 hours.

So in theory you can have a few poorly written queries block lots of other queries from running

So, bring in RG with MAX_MEMORY_PERCENT set. Now you can limit the damage that those poorly written queries do

What I'm whining about here is that MAX_MEMORY_PERCENT must be an INTEGER... with servers having 256 GB of RAM and even more these days that seems like a silly oversight

RG can also be redgate so I figured you were using some tool of theirs that I don't play with

@JoeObbish How high do your percentages go? I normally limit mine to 0-100.

MIN_GRANT_PERCENT, MAX_GRANT_PERCENT hints not available/suitable?

@ypercubeᵀᴹ I've used my crystal ball now.

@PaulWhite Pretty low. < 5%

Those hints are both unavailable and unsuitable

Oh I see you want fractions

2:21 PM

@McNets They are using MySQL. Unlikely to have CHECK constraints. Sorry to disappoint you ;) Check the INSERT statement.

For some reason I thought you were conflating percentage with a fixed amount ha ha

@ypercubeᵀᴹ Or DESC indexes :)

Well, really what I want is a fixed amount.

I foresee another cycle of delete-undelete. (@McNets check the error message. An FK constraint fails)

In any case, it's not that big of a deal and what I have now is fine. Just annoying.

@ypercubeᵀᴹ haha never disapointed ... by anybody else than me., ok here we go again. may be a trigger?

2:23 PM

The documentation seems to suggest the query hints take a decimal rather than an integer, but I don't remember trying it.

@McNets No. The reason is hidden in plain sight.

INSERT INTO Entries VALUES (entry_id, subject_id, ...), (1, 4, 1, ...), ... ;

They do take a decimal

the hint is applied after any RG restrictions though

so if I limit memory grant to 4% using RG

@ypercubeᵀᴹ yes , well I'll wait for a table schema.

then add a 5% MAX_GRANT_PERCENT HINT

that's 5% of 4%

And that doesn't give you the flexibility you need?

2:27 PM

@JoeObbish Cheers.

A: How do I properly use the "Not an Answer" flag?

Haven't posted this for a while, so here it is again:

45

What is the Not an Answer Flag? The Not an Answer flag is a moderator flag that community users can use to notify moderators that a posted answer is not an answer, and should be deleted. What is the purpose of the Not an Answer flag? To identify attempts by community members to use answers for...

@PaulWhite It should be called the "Not An Answer, Not Not A Good Answer" flag.

3

just for clarity ;-)

It does seem to confuse people I agree.

Perhaps Objectively Not An Answer ;)

I know it confused me for a long time. Plus I really want a "Damn, this is a really terrible answer, and should be deleted" flag.

VLQ. Senior users also have VtD.

2:36 PM

Question about that

@PaulWhite true dat.

so in the example from earlier which advocated something harmful: stackoverflow.com/questions/1439183/…

The right thing to do is just edit instead of flag?

@JoeObbish or just downvote

@JoeObbish Editing to improve is always a good option. There are many valid actions.

@JoeObbish edit if you can improve, else downvote to oblivion.

2:39 PM

Flags are generally for stuff the community can't do, or which is particularly urgent.

Not sure that's proper English, but hey it's 3:40am

I guess that downvoting on its own seems like an insufficient action. We don't want answers on the site that could trick someone into dropping a database?

@JoeObbish If it's actually dangerous, a custom flag would be acceptable.

But since it could just be edited to at least add a warning (as was done), then a flag isn't needed

since the community can solve it

yep

@PaulWhite Not an Attempt at an Answer. In short, NAAAAA.

3

2:42 PM

@JoeObbish serves them right for taking advice from SO

@McNets Have you spotted the reason yet? It's right there, in he INSERT

Trick question of the day. Why does this fail?

INSERT INTO Entries VALUES (entry_id, subject_id, student_id), (1,4,1), (2,8,2), ... ;

the comma?

no

@ypercubeᵀᴹ All subject_id exists as far as I can see.

trying to insert column names?

ahhhhh

2:46 PM

I guess I'm missing context

@ypercubeᵀᴹ The column list is in the wrong place.

@Forrest Yes !

@PaulWhite and yes

@ypercubeᵀᴹ hahaha in front of my eyes

(entry_id, subject_id, student_id),

@AndriyM I like Not Even Wrong as a synonym for VLQ (meta.stackexchange.com/a/220630)

not really a valid question without an RDBMS

2:47 PM

I would love to flag something Not Even Wrong.

you just like making fun of NEW answers

@PaulWhite It's one of those things where we don't have full control over the code, customers won't be on SQL Server 2016, etc etc etc

big complicated mess

@JoeObbish To be fair, it's a solution to my problem, just not the OP's, since I'm trying to kill connections before a restore of said database anyway

So I didn't even downvote, it helped me out in my use case, but it should have been clearer that it did what it said on the tin "kill the database"

@Forrest Ha!!!

@JoeObbish Yep, understood. Has always been a tricky problem.

A: Select distinct values between two values in different field

"None so blind as those who will not see."

Should this answer be flagged as Not an answer?

0

+----+--------------+------------+----------+ | id | name | Min_price | Max_price | +----+--------------+------------+----------+ | 1 | jean | 1000 | 5000 | | 2 | shirt | 1999 | 7010 | | 3 | saree | 1008 | 8000 | | 4 | jeans ...

3:00 PM

What answer?

Last one

Sorry bad link

They rot so fast sometimes.

it's marked as accepted?

Not a bad link. Was deleted since it was flagged NAA and it was, in fact, NAA.

@PaulWhite JEAGL-compliant

3:02 PM

> Use this flag when an answer is being used to: Ask a new question

@JoeObbish The link is to a now-deleted answer.

@PaulWhite I've let a comment and @MaxVernon has edited it, but now I cannot find it on my last comments.

@McNets which question?

@AndriyM I replied "what answer" since I had just deleted the answer @McNets was asking about. The humour is in answering his question with an answer which is an answer, but possibly not the one he was expecting.

It like a new question similar to the OP, I've let a comment about merging accounts

@PaulWhite ok, I'm going crazy...

Life would be a lot simpler right now if I had just said: Yes it should be flagged as Not An Answer, in fact it was, and I deleted it.

Alas, no time ship available.

@McNets You're not going crazy. I deleted the answer and your comment went with it.

3:06 PM

@PaulWhite , if fact I flagged it before to ask

@PaulWhite I meant to say that explanation was already compliant with the policy but thank you very much for providing an extended explanation.

@McNets Yes.

@AndriyM One can never be too sure with jeagl compliance issues.

Fair enough.

See, that's why we need JEAGL, without it McNets would go crazy

At least you could explain me what JEAGL means!!! ;)

3:16 PM

@PaulWhite - this answer has a comment at the very bottom about something you wrote that has subsequently been deleted. I was going to edit the answer, but I have no idea what to do with it.

Oh no. We've been failing JEAGL by failing to explain JEAGL

That is the JEAGL way

JSNBEAGL

jeagl shall not be explained at great length.

@McNets JEAGL stands for Jokes Explained At Great Length

On MySql can I use '&&' '||' instead of 'AND' 'OR'?

@TomV Ok, thanks

3:18 PM

@McNets I think they mean something different.

We have a policy in place where we tend to explain jokes (often at great length) to avoid people missing the joke and ending up confused

on a WHERE clause.

@TomV sorry, I don't know what you mean.

@MaxVernon Are you joking?

This also has the added benefit that the lengthy explanation offers an opportunity to overdo it a bit, making the explanation by itself appear somewhat funny.

3:19 PM

@AndriyM do I really have to explain? ok. Yes, I was joking. ;-)

Also, since that behaviour has turned into a meme in this chat room, the fact that we explain jokes is, in itself, funny to a lot of residents

2

@TomV its a never-ending source of tomfoolery

@MaxVernon You failed, I had to google that

dammit!

@TomV thanks, it's a bit clear to me now

3:25 PM

@TomV considering English is not your first language, you have an excellent command of it.

I wish I had nearly that level of skill in French.

@MaxVernon Edited.

@PaulWhite - I guess I could have done that. Stupid brain. Thanks!

I'm saying nothing :)

I almost spit my coffee on my screen.

do you plan on getting some sleep tonight?

or, perhaps more accurately, this morning?

@MaxVernon Thanks, but my French is a lot worse than my English

3:29 PM

@Max Yes. I'm just finishing a few open tabs up, waiting for the end of Deep Space Nine S7 Ep 6, then I'll be off.

@TomV where are you from?

Belgium, the dutch-speaking part

@TomV Do you have a government yet?

2

Ha Ha

@MaxVernon what did you call @TomV?

3:42 PM

my computer needs to be taken out back and shot

@JoeObbish I did that once. Really fun. I have a hard drive with a bullet stuck in it sitting on my desk now.

3

unfortunately we're on a firearm free campus

I will happily provide free firing-squad disposal for any computers shipped to Texas ;)

news18.com/news/world/…

@TomV yeah, read about it this morning

3:47 PM

@Forrest If it was up to me I'd honestly do it. IT will probably want it back even though it's so old

@AndriyM thanks for the zero width space hint.

There is a system somewhere where we need to provide a reason in a dialog specifying the reason you are opening production with administrator access.

I entered the zero width space and auditors/managers are now running about trying to understand how I managed to enter nothing in the dialog

They'll probably still be debugging that halfway into next week

@TomV Nice!

can't they just ask you?

yesterday, by Tom V

@Forrest Everybody is using a generic "support" windows account

Cute

3:57 PM

I'm sure they'll figure out who to ask at some point

oh... that's evil

@TomV Always happy to help people with providing other people with some work.

Andriy M is a Job Creator?

I'm only an assistant

Maybe we should go into politics and save the economy

4:01 PM

Alas, zero width still has a length :(
SELECT LEN(NCHAR(CONVERT(int,0x200B)))

I tried to calculate the zero-width space's height and my computer shot itself

And on that note. I'm out.

@PaulWhite Have a good one

@Forrest Which is especially remarkable in view of the fact that a normal space doesn't: SELECT LEN(NCHAR(CONVERT(int,0x0020)))

@AndriyM Cool!

@AndriyM isn't that the same as LEN(N' ')?

4:13 PM

@ypercubeᵀᴹ Yes

@ypercubeᵀᴹ I wanted it to be equivalent to the other expression while giving a different result.

Remarks
LEN excludes trailing blanks. If that is a problem, consider using the DATALENGTH (Transact-SQL) function which does not trim the string.

msdn.microsoft.com/en-us/library/ms190329.aspx

I learn weird things when hanging out with y'all.

Sometimes (probably mostly) LEN(x + N'.') - 1 can do just as well. What I like about LEN is that it's consistent regardless of whether I use varchar or nvarchar, whereas with DATALENGTH I need to remember to divide by 2 when dealing with nvarchar since I want the length in characters, not bytes.

@Lamak lol, that was completely subconscious!

@MaxVernon your subconscious is kind of witty ;)

5:08 PM

→ 1 message moved to Trash

Welcome aboard, @dezso

@PaulVargas hi, why

@dezso Why what?

@PaulVargas why "welcome aboard" I guess

@Lamak that @PaulVargas

5:25 PM

I mean, I wish to welcome the presence among us of Mr. @dezso

→ 1 message moved to Trash

hi

@PaulVargas that's very nice of you. I did not understand it first as I was lurking the whole day

you cannot tell I am not consequent:

in Trash, yesterday, by dezso

THANKS, PAUL!!1!

5:41 PM

→ 1 message moved to Trash

→ 2 messages moved to Trash

M.A.R.

6:05 PM

@PaulVargas What purpose does this message, or flagging it serve?

@M.A.R. Okay, How can I flag myself?

@PaulVargas what comment do you want to delete

?

M.A.R.

@PaulVargas You can by clicking the down arrow and telling a moderator what they need to know.

But this isn't urgent, so I won't recommend it

@Lamak This, but I would like to move it to the Trash. :D

→ 1 message moved to Trash

7:38 PM

@MaxVernon You beat me by two minutes!

@JoeObbish on?

Q: Performance of count(*) in subquery

0

Suppose we have the following queries: 1. SELECT COUNT(*) FROM some_big_table WHERE some_col = 'some_val' 2. SELECT COUNT(*) FROM ( SELECT * FROM some_big_table WHERE some_col = 'some_val' ) Does any of the previous queries performs better? Or is it the same? Thanks in advance for...

ahhhhh I see.

have a plus one!

thanks, you as well

The TF may have been a bit much but I want to practice with those whenever I can

@JoeObbish no no, it's very useful. Quite frankly your answer is much better than mine!

7:42 PM

@MaxVernon get a plus one, @JoeObbish gets a plus one, everyone gets one

@Lamak Unicorn points for everyone!

except @billinkc, I don't wanna go against @JackDouglas intentions

I VtC'd that question, although if the OP gives any hint of what DBMS she's using, I'll retract it.

@Lamak clearly

@JoeObbish I was just testing the same query with 8606, heh.

@Lamak Monsters, all of you

7:45 PM

@billinkc I mean, how could I?, @JackDouglas is just too nice

@billinkc besides, you never went to SO en español as you said you would

I'm sure he appreciates all the plonks

I looked into the abyss and saw you staring at me

plonk is a very fitting onomatopeia

If you want to write code that performs well, don't rely on an ORM to do it for you. — Max Vernon 26 secs ago

so true.

@JoeObbish Nesting the SELECT subquery 74 deep seems to add about 15ms to the parse/compile time on my test rig.

7:48 PM

ORMs are horrible.

@Forrest now that's a level of detail that is impressive

@billinkc that's your problem, you were supposed to just gazed into it

@EvanCarroll one can understand why they have appeal; but I hate them with a passion.

@MaxVernon I don't know about that but thank you, glad you appreciated it

@Forrest I did briefly think about extra parse time and decided (without evidence) that it would be close to 0 ms

that's an interesting observation

@Forrest no doubt there exists some SQL somewhere that is 74 levels of (SELECT *) deep.

7:52 PM

@MaxVernon usp_Inception

@Lamak only applied to oracle, @billinkc had no business there anyway :P

@EvanCarroll - that question is about sql-server, not postgresql

I clicked it from your link, it's all the same. At least from the ORMs I've used. Though I haven't used Entity, I assume it doesn't play with window functions.

The order of execution is standardized. I assume MS doesn't deviate from it.

Just use EF on top of procs, problem solved.

Shit, 50% of developers can't write good SQL, why let developers write programs that write SQL.

5

@EvanCarroll I agree that it's pretty much going to be the same answer; just the link you provide goes to the PostgreSQL docs, which won't help the OP, or future visitors to the question.

@CadeRoux yes, that's the way to do it. For sure.

8:04 PM

Sure, got a link to SQL Server doc, glad to replace it. I looked after you brought up.

In theory I agree with you.

At least, with adding too if the working is concise.

is 50% a lower bound or upper bound?

lol

Plus you can code gen SQL procs as good as EF and then just optimize that SQL later.

@JoeObbish the other 50% can't write SQL at all.

and ORMs are getting better all the time; it's only a matter of time before they always write better code than your average dev.

note, I said "average"

Doubt it.

8:08 PM

I don't know a lot about the history of SQL, but wasn't it once marketed as a language that non-programmers could use easily?

They can, that's also the problem it and with generating things in it.

It's extremely rare that you will mindlessly join some in-memory data structure against two disparate data sources using LINQ or whatever and get anything approximating acceptable performance. You will always have to think about it.

Well said. LINQ is pretty awesome btw. I give Microsoft a lot of shit, but I really LINQ a lot.

@CadeRoux true but that is just a process. Software will very soon be able to understand how to do most things we currently do on a day-to-day basis, and they'll do them faster and more accurately than we do.

And by the time you think about it, you can implement a much better solution. While it's great that you can say something in LINQ that is pretty data access agnostic, if you are operating across data access platforms, it's going to require thinking.

@MaxVernon yes, but most of programming is not coding anyway, it's understanding the problem.

8:11 PM

most certainly; there are situations where we'll always be needed.

thankfully!

LINQ is awesome, but it has problems like most abstractions.

I'm only bringing it up to shed my anti-MS reputation. LINQ is real cool, I'm sure it's far from perfect. I just learned it to help some friends get jobs.

It was intuitive, for me.

Fundamentally, that's the problem. Whenever a problem is abstracted, you are going to lose performance, hide implementation details that turn out to be crucial, increase debugging time, etc. It's just intrinsic to the process. RDBMS themselves are an abstraction. They benefit from the abstract model being somewhat close to the implementation model. Just like C.

SQL itself has already got a great deal of abstraction, being merely a declarative language. In that sense, there's little point abstracting it further by building ORMs on top of it.

8:26 PM

@EvanCarroll - large big black fonts in your answers are ok, just don't add "GIVE IT A TRY!!!" at the end of each answer.

please!

Hmm, unable to edit a "you're" into a "your" as the edit is too small, but the rest of the post is fine.

I think it stops complaining about that after you get like 5k exp

Clearly I should focus on leveling up more.

A: Low rep users should be able to fix broken links

I'll power level you, give me a second.

It's 2k exp that you get the ability to edit without minimum length restrictions

8

Er.. what? Fixing a broken link would surely push you over the 6 character minimum in most cases. Beyond that, dream bigger. Is the post otherwise so perfect that nothing in it can be improved? If so, then it is a rare post indeed ... like a majestic, dew-flecked unicorn.

@EvanCarroll Thanks for the info! And the power-leveling...

8:41 PM

@Forrest What's the post in question?

@AndriyM Someone else edited it.