The Heap™ – Consultancy ©®

Don't know about others but I'm not exactly ignoring anyone, although I may ignore messages that I have nothing to say in reply to, and then it doesn't matter whose messages they are

@Mathematics And I'm sure Tom didn't ignore your question a couple of hours ago.

Mathematics

11:39 AM

It's Paul, I think he put me on ignore

Paul White

@Mathematics Then you'd be wrong.

dezso

12:04 PM

@A_V that applies basically to every language but English (Hungarian more than German, however)

Mathematics

@PaulWhite you didn't tell me where was TomTom then

Paul White

Right.

Lamak

12:38 PM

@TomV hopefully everything goes well

@PaulWhite time flies

Paul White

@Lamak Doesn't it just.

Phil

12:51 PM

Oooh, proper Unix binaries on Windows. That I do like

Mathematics

someone gonna tell me who is TomTom ?

Paul White

Sad about Ronnie Corbett.

bbc.com/news/entertainment-arts-35934024

Mathematics

1:06 PM

keep ignoring

Andriy M

Watched an episode of Would I Lie to You? with him on YouTube, I think it was shot a couple of years ago, so he was already at least 80 apparently. He certainly looked old but not that old to me.

Thought he was like 65

Tom V

@Mathematics Dude, I don't know that user either, but if you click the profile link you'll see he posted until early 2014, didn't post any more and now posts again. So I suppose that's what Paul meant when he said "he's back".

My life is so much better know that I know!

@Lamak I suppose the raid is done, Army convoy just passed our offices towards the highway

Bizarre sight

Lamak

1:21 PM

@TomV at least the picture is not from inside one of those vans

Andriy M

@Lamak The ideas in your head!

Lamak

I'm being insensitive, I know, I know

Tom V

@Lamak Nah, the joke was good enough

Andriy M

Can't imagine myself in that situation. The conflict zone in my country is rather far from where I live but we had block posts around the city and further and that already felt so surreal to observe.

dezso

krhm

Lamak

1:35 PM

:28649133 please, don't post your sensitive information so recklessly

dezso

did you note it?

Andriy M

@Lamak You know I wasn't actually angry, right?

dezso

this is the downside of trying to do something useful while trying to set up another machine

Lamak

@dezso of course, I memorized it and sent it to every person I know

dezso

@Lamak very good

Lamak

1:37 PM

@AndriyM I'm just messing around, if I thought you were angry I would've said sorry sincerely

dezso

now I have to stick your picture somewhere here, so that when you arrive, the coworkers know what to watch for

Andriy M

@Lamak Very well. We are on the same page, that's all I care about :)

dezso

and, of course, everyone else (as I don't know who has access to the deleted posts here)

OMG, Joel Spolsky is here tomorrow, so I have to lock my laptops until he leaves

Lamak

@dezso ah, well, sorry to say, but almost every regular here ;-)

@dezso they'll never see me coming

(because I won't be)

dezso

@Lamak it's a pity, we are hiring

(all that was a very sophisticated way to make you asking for unsolicited job offers)

Lamak

1:41 PM

nice one

@dezso don't use the same password

Andriy M

On a completely unrelated note, my current rep spells "seet" in Leet

Isn't that seet

Mathematics

and Microsoft is down again

mva.microsoft.com

ypercubeᵀᴹ

2:00 PM

@dezso thnx. I solved th eissue anyway. It was weird, unrelated to pgbench.

Some text editors were adding a BOM thing in the start of my sql files, breaking pgbench as a result.

Paul White

@dezso Room owners (italic names) and above.

@Mathematics Works for me.

@Mathematics If only chat had some sort of search feature you could use!

Tom V

2:20 PM

@PaulWhite Ha, you had me verify you weren't talking crap about me before I joined the room :)

Paul White

Never.

Tom V

Apparently

James Lupolt

@TomV This is where I used to live. There were frequent bomb threats at the time, but always fake as I recall, and from communists instead of jihadists.

I understand some of the people who committed or were arrested for the recent attacks lived nearby in Charleroi

Tom V

@JamesLupolt Ah yes the good old Cellule Communiste Combattante

Did you actually live in that castle?

James Lupolt

2:36 PM

@TomV Yes, the owner split it up to rent it to people who worked on the US Air Force base nearby

Tom V

Cool

James Lupolt

Do you think the area has changed much? I haven't been back since around 89

Tom V

That area, yes a lot.

But I think the economic decline in the industrial sectors prevalent there was already ongoing when you were there then

It's gotten a lot poorer, but that goes for most of the French speaking part of Belgium

Andriy M

@TomV You mean to say, it wasn't affected by James's departure.

Tom V

But don't take that last comment as a judgement, when mines and related industry was booming they were the richer part of Belgium and the Flemish population benefited from that boom.

James Lupolt

2:59 PM

Charleroi looks pretty rusty on Google Earth. I don't remember it being that way.

Tom V

3:12 PM

@JamesLupolt Shut down factories without any maintenance whatsoever

Charleroi

Charleroi (French pronunciation: [ʃaʁləʁwa], Walloon: Tchålerwè) is a city and a municipality of Wallonia, located in the province of Hainaut, Belgium. By January 1, 2008, the total population of Charleroi was 201,593. The metropolitan area, including the outer commuter zone, covers an area of 1,462 square kilometres (564 sq mi) with a total population of 522,522 by January 1, 2008, ranking it as the 5th most populous in Belgium after Brussels, Antwerp, Liège and Ghent. The inhabitants are called Carolorégiens or simply Carolos. == Geography == The municipality of Charleroi straddles both banks...

> . Charleroi is in the center of a coal basin. Even so, due to the widespread loss in industrial power in the area since the 1970s, the area has suffered some of the highest unemployment and poverty rates in Europe for most of the 1980s and 1990s. However, from the early 2000s, the overall economy of the area has diversified to include health care, transportation and telecommunications. Nevertheless, the poverty rates are still significant.

swasheck

4:04 PM

> Product: Microsoft ASP.NET and Web Tools 2015.1 (Beta8) - Visual Studio 2015 -- Error 1714. The older version of Microsoft ASP.NET and Web Tools 2015.1 (Beta8) - Visual Studio 2015 cannot be removed. Contact your technical support group. System Error 1612.

gah

swasheck

4:38 PM

amazon.com/Cricket-Flour-made-100-22/dp/B00OMCTODQ/…

Max Vernon

4:58 PM

@swasheck mmmmmmmmmmmm!

Max Vernon

5:09 PM

Yes, it doesn't matter, to you. There is no way I'd touch that database without at least doubling my hourly rate. — Max Vernon 12 secs ago

swasheck

i was about to vtc -> music because i thought they were guitar tabs — swasheck 16 secs ago

Max Vernon

@swasheck loool

swasheck

i'm a funguy

Max Vernon

5:31 PM

This is just an example of the actual code Max, Jesus... troll much? — dazedays 5 mins ago

swasheck

@MaxVernon gotchaback

@dazedays he isnt trolling, he's trying to get an actual assessment of what you're actually asking. just because someone is asking questions to clarify what you're asking, and that they may disagree with you, does NOT mean that they're trolling. having said that, I was clearly trolling you so point your crappy attitude toward me. also, max is a nice guy, he asked questions. i just voted to close this. — swasheck 13 secs ago

Max Vernon

@swasheck thank you!

ypercubeᵀᴹ

loooool, @swasheck - I love MySQL more and more all the time. — Max Vernon 33 secs ago

2

Copied to be preserved

swasheck

"what does @MaxVernon vernon look like?"

What Does Marsellus Wallace Look Like?

►

Max Vernon

:-)

that's excellent, @swasheck

@ypercubeᵀᴹ thank you!

Daniel Hutmacher

5:38 PM

Good evening, Heapers.

Max Vernon

Hi Daniel!

swasheck

AND YOU WILL KNOW THAT MY NAME IS @SWASHECK WHEN I LAY MY VENGEANCE UPON THEE

Max Vernon

^^^^^^^^^^^^^^^^^^^^^^

Daniel Hutmacher

Off-topic question: I'm lost when it comes to SQL Server licensing (I just build/trim stuff, someone else order the servers and pays the bills) - I'm guessing that a site like sqlfiddle couldn't run on a Developer edition of SQL Server. Any thoughts?

Max Vernon

good edit, @ypercubeᵀᴹ

@DanielHutmacher licensing questions are off-topic here ;-)

Daniel Hutmacher

5:42 PM

@MaxVernon I know, that's why I didn't ask on the site proper. :D

Max Vernon

seriously though, you could just ask @jakefeasel

swasheck

@DanielHutmacher i'd assume not

Max Vernon

So MSDBLog.ldf can autogrow by 256 KB to a maximum of 2 terabytes. How many VLFs is that? A lot!

Daniel Hutmacher

@MaxVernon or I could ask sqlfiddle. :) Express Edition (64-bit)

Figures. :)

Max Vernon

@DanielHutmacher lol excellent point!

Tom V

5:55 PM

@MaxVernon I tried asking him about SQLFiddle weeks ago, still no reply

Max Vernon

I don't like to use plural for table names, most people would expect a table to have multiple rows

That's some seriously good trolling of me.

Tom V

Haha, yes noticed that earlier, was tempted to flag as NAA but a recent one was declined

Max Vernon

@TomV pretty hard to get NAA flags past @PaulWhite

Tom V

@MaxVernon Can a 10K+ user post the answer in question here. dba.stackexchange.com/questions/133900/…

I cannot verify any more since it's deleted, but I think I would still stand by the flag

Max Vernon

@TomV sorry, I don't understand.

what do you want me to do? I don't see anything deleted from that question/answer

Tom V

6:03 PM

Ah no the answer is still visible

it was just reformatting the OP's query so I still don't see how it's an answer (cc @PaulWhite)

Max Vernon

@TomV oooohhhh I see. I agree, that's a pretty terrible answer.

flagged as NAA

and down-voted, as well

rfusca

I f'ing hate Oracle with the fiery passion of a thousand suns.

Max Vernon

One might suggest that naming a table "Movie" is misplaced. Is it a table, or a movie? — Max Vernon 31 secs ago

Paul White

@TomV Self answer.

Tom V

@PaulWhite No that's the other one

unless you mean "@flybys answer was perfect" referring to the flagged answer but I don't see how he came to that conclusion

The only thing substantial in the flagged answer was "Question is what you want to achieve, how are the two tables linked? Maybe a LEFT JOIN + USING(RaagID) or something like that is better?" but I believe that's comment material

Max Vernon

6:08 PM

@TomV agreed

Tom V

Not that I care enough about a rejected flag enough to get into a lengthy discussion but I am willing to learn :)

Paul White

@TomV Oh yes I was going from memory (on mobile). The self answer was flagged NAA by someone else. I declined.

I'll check the other one.

@TomV OK marginal. The "Maybe a LEFT JOIN + USING(RaagID) or something like that is better?" seems like an attempt to answer the vague question plus comments seemed to be going somewhere at the time.

The self-answer appeared to find it helpful.

Tom V

@MaxVernon Table - and it is a table in the question. I don't see how naming a table "movie" with movie data is misplaced. — Paparazzi 29 secs ago

:) I like your recent trolls @MaxVernon (aka trollmeister)

Paul White

@TomV So, given the quality of the question, "I would appreaciate if someone could help me optimize this query." ... it seems like a reasonable attempt to answer with the information given. I'm not going to delete someone's answer simply because they could have (incorrectly) left the only useful part as a comment. Make sense?

Tom V

@PaulWhite Knowing your point of view I see how it makes sense yes

Paul White

6:18 PM

@TomV It's not just my point of view, it's right there in the FAQ. There are other things that could/should have been done to the question by the community, but they didn't.

Tom V

To me, at the time, it seemed like a request for clarification along with a reformatted query (while the reformatting could/should have been done in the question)

Max Vernon

Does the table contain details about "movie" or "movies"? I find it helpful to use the plural form of the noun since it makes talking about the data more understandable. For instance, Movies can have multiple Characters. We don't say (at least I don't) "Movie can have multiple Character" — Max Vernon 2 mins ago

Tom V

And I didn't see the self answer at the time, probably because that didn't show up in the review queue and I didn't click through to the question to see all replys

Max Vernon

I do realize that this is a holy war, and is actually unwinnable. But sometimes it's fun to try.

Paul White

@TomV Much of it is, which is why I said it was borderline. The point is that the post contains an valid attempt to answer, even if you strip all the other stuff away. NAA means actually not an answer. No sort of answer at all. None. Not a bit. Zero.

Tom V

6:24 PM

@PaulWhite I've lowered my threshold over time but I'll need to lower it further then :)

Paul White

@TomV It's not a great example, because it's so marginal, but for mine a downvote/comment as you feel inclined would have been the correct action. There's nothing for a mod to do. Deleting would be harsh and orphan the self-answer. Converting to a comment would be wrong too.

Max Vernon

@PaulWhite perhaps a well-made edit by a non-moderator would rectify the situation nicely?

or are you of the opinion nothing needs to be done?

Paul White

But even a downvote might be harsh: the guy was clearly looking to help as much as possible, and contributed the root of the right answer. I'm pretty sure we shouldn't punish answerers for the quality of the question.

Tom V

@MaxVernon You mean remove the reformatting after I did it in the question itself? I thought about that but didn't as it would remove 3/4 of the answer

Anyway, the thread isn't worthy of much effort I believe

Paul White

@TomV Agreed.

Tom V

6:28 PM

So, sorry to raise it, it started as a joking "yes I would flag but a recent one got rejected" in reply to max's link

Paul White

@MaxVernon An edit to the question or answer by "flyby"? Any edit that improves a post is always welcome of course.

Max Vernon

@TomV I was thinking removing the regurgitated SELECT statement from the answer, and reformatting the sentence to be simply: Maybe a LEFT JOIN + USING(RaagID) or something like that is better? Could help to know what Shabad and Raag mean in english.

Paul White

@TomV No it's good that we discuss these things. I can be persuaded I was wrong on occasion.

Max Vernon

@PaulWhite I was just thinking about the answer

@PaulWhite She's a witch! Drown 'er!

Paul White

@MaxVernon Ok, but what would you change? Anything useful from the comments could go there I guess. Difficult from my mobile to be sure, too hard to keep switching screens.

Tom V

6:30 PM

@MaxVernon That's what I was thinking of, It's somewhat confusing since it looks like the query is part of the answer

Max Vernon

let me give it a try. we can easily roll back if necessary

-1

A: How to optimize this crazy SQL Query (Specific)

What do you want to achieve? How are the two tables linked? Perhaps a LEFT JOIN + USING(RaagID) or something like that is better? Also, it might help to know what Shabad and Raag mean in English.

undownvoted (is that even a word?)

@MaxVernon Fine you like to use plurals for table names. I don't and stated so in the first line. The stated question is not about table naming conventions. — Paparazzi 10 mins ago

Tom V

@MaxVernon Please reload :)

and flagged the comments as obsolete

Max Vernon

@TomV excellent

Tom V

@MaxVernon i did one last edit and that's all the question deserves :)

Might even deserve an upvote now (LOL)

Max Vernon

yes.

poor customs guys, always getting a bad rap.

Lamak

6:42 PM

@MaxVernon yup, got that too

Tom V

On another note, nothing says "I'm a SSAS noob" like referring to dimension members as "records"

Lamak

@TomV you mean dimension "attributes"?

Max Vernon

@TomV I prefer to call 'em forty-fives.

Tom V

@Lamak No members, members are rows, attributes are fields

Lamak

@TomV now I'm confused

Paul White

6:52 PM

@MaxVernon I removed the obsolete comments on Blam/Frisbee/Paparazzi's answer as well. Flagged 'em myself :)

Max Vernon

@PaulWhite just noticed that. thanks

Tom V

@Lamak See this edit

The last edit, I quickly reformatted while at work, proper edited and answered when done with obeying the man

Paul White

@MaxVernon Voted on your answer now too.

swasheck

you buttheads deleted my trolling???

Max Vernon

@PaulWhite I guessed that was you. Thanks!

Paul White

6:56 PM

Little flurry of flags there, took me a while to get caught up.

@swasheck No I did.

Max Vernon

15 points away from two mortarboard days in a row

Paul White

@MaxVernon What's mortarboard?

swasheck

@PaulWhite ah. carry on, then

Max Vernon

that question about a+b+c+d=0 really helped.

@PaulWhite 200 points in a day

swasheck

> The square academic cap, graduate cap, cap, mortarboard (because of its similarity in appearance to the hawk used by bricklayers to hold mortar) or Oxford cap, is an item of academic dress consisting of a horizontal square board fixed upon a skull-cap, with a tassel attached to the centre.

Tom V

6:57 PM

@MaxVernon Beggar :)

Max Vernon

@TomV I'm not above anything, I tell ya!

Lamak

@TomV aha, I see

Paul White

@MaxVernon Oh I thought that was Epic or Legendary.

Max Vernon

@PaulWhite Mortarboard is the bronze version of both of those.

I'm 14% of the way to Epic.

Paul White

I see it now

Lamak

6:59 PM

@MaxVernon @PaulWhite doesn't know about meager bronze things

Max Vernon

which I think means I'm not very epic.

swasheck

you're very dedicated to your craft.

of earning unicorn points

Max Vernon

lool

Paul White

@Lamak I'd honestly never noticed that badge. But yeah, bronze ... meh :)

I mean ... awesome! Go Max!!!

Max Vernon

lol. hey @PaulWhite - was that you +1'ing me on this

if not, do you think I'm barking up the wrong tree?

Paul White

7:01 PM

@MaxVernon Nope. And not going to now :-D

Max Vernon

@PaulWhite :-0

Paul White

@MaxVernon None of us is. Only one person has ever earned Epic.

Max Vernon

@PaulWhite yes, the esteemed Aaron.

Tom V

@MaxVernon I did, felt like I needed to compensate yesterday's downvote for lack of effort with an upvote for lack of effort

Max Vernon

@TomV thanks!

Paul White

7:02 PM

@TomV That's a very balanced approach.

swasheck

@MaxVernon is the ostensible Fox News of The Heap

3

Paul White

Sadly I have only one star to give.

swasheck

it's the thought that counts

Lamak

@PaulWhite had to google when to use "none of us is" vs "none of us are"

Paul White

@Lamak Ooops!

swasheck

7:07 PM

@PaulWhite ... how would you go about indexing a column that's > 900 bytes? i found a HASHBYTES() solution but i'm not sure i love it

Max Vernon

dba.stackexchange.com/revisions/133985/3

Lamak

@PaulWhite hate to say it but apparently you were right

swasheck

@Lamak because none of us could be 0..n

Paul White

@Lamak I prefer the singular none of us is.

Lamak

@PaulWhite yup, I think I understood that

Paul White

7:09 PM

@Lamak I edited out my original mistake.

swasheck

@PaulWhite are you from texas?

Lamak

@PaulWhite I did too, that's why I search for it

Paul White

@swasheck huh?

swasheck

nevermind

sorry

bad joke

Lamak

@PaulWhite ARE YOU FROM TEXAS

Paul White

7:10 PM

@swasheck Could be improved by explaining it at length.

swasheck

DO THEY SPEAK ENGLISH IN WHAT???

@PaulWhite probably. but i'm more interesting in indexing large columns

Paul White

As you were then.

swasheck

right. so do you have any other tricks other than a HASHBYTES on hashable types?

Tom V

@swasheck If you were in Microsoft's AX dev team you would throw 3 of those columns in the clustered index

Paul White

3

A: How to optimize this crazy SQL Query (Specific)

What do you want to achieve? How are the two tables linked? Perhaps a LEFT JOIN + USING(RaagID) or something like that is better? Also, it might help to know what Shabad and Raag mean in English. Update from comments: shabad is the main table and has references to the other two, so I believe...

Tom V

7:12 PM

and call that #winning

swasheck

@TomV but i'm not. #soyunperdedor

Tom V

@PaulWhite Ha! #winning

Paul White

@swasheck Nope. That's the standard solution.

swasheck

@PaulWhite awesomepossum

bahahahaahahahahahaahahahaahahahahahahaahah

> Rupert Murdoch's Ex-Wife Is Dating Russian President Vladimir Putin

Paul White

Not Trump's wife then.

Tom V

7:16 PM

@PaulWhite Which one?

Ex or current

I don't think Uncle Vlad is interested in Uncle Donald's ex one, she looks second-hand

Paul White

@TomV The one in the pose recently in the media. Current I think.

Tom V

@PaulWhite yes current, the previous one can't be buried any more, she needs to be recycled because of all the plastic in there

Paul White

Ooo.

ConcernedOfTunbridgeWells

7:34 PM

@Mathematics Famously argumentative Knob-end who got banned.

Paul White

Unikong. On the side bar. Seems to be an April 1 thing?

swasheck

Polykong

bluefeet

@PaulWhite yes, April 1st shenanigans

Tom V

@PaulWhite I played it, couldn't get past level 1, guessed the game was trolling me

Paul White

@bluefeet Is it just for the day?

swasheck

7:37 PM

my wife is flying out of town on April Fool's Day

bluefeet

@PaulWhite Yes, that's the normal routine.

I think last year was StackEgg

swasheck

bahahahahahaahahahahahahahahahahahah

github.com/…

javascript is the "winner"

Lamak

@ConcernedOfTunbridgeWells you don't know what you've done

2

Paul White

@bluefeet Oh yes of course. Gosh that seems like more than a year ago.

Tom V

@swasheck That's not what she told me last night

swasheck

7:40 PM

@TomV nice try

bluefeet

@PaulWhite time flies

swasheck

tempus fugit

fuggit

ConcernedOfTunbridgeWells

@Lamak I didn't actually invoke him

Paul White

awkward pause

Lamak

@ConcernedOfTunbridgeWells I don't know if it's the same "him" that I'm talking about ;-)

Tom V

7:45 PM

@ConcernedOfTunbridgeWells "yet"

swasheck

why do we not talk about him ... sure he was a richard and all ... but ... oh bother. nevermind. i'm too tired to formulate a thought.

Tom V

@Lamak He who shall be named "SSRS dude" forever?

However, he learned me something today, SSRS 2008 really isn't working in edge

Lamak

@TomV I was talking about him, but I think that @ConcernedOfTunbridgeWells was talking about the guy referenced in his comment

Tom V

which I find funny, because "the new AX" (yes that's what marketing created for AX 7) works on all mobile phones except WP

ConcernedOfTunbridgeWells

@Lamak Yes, I was.

swasheck

7:49 PM

@Lamak i thought you were equating the two ... as in ... they are the sme person

@TomV all 3 users will be disappointed to hear that, i'm sure

Lamak

@ConcernedOfTunbridgeWells I figured

awwwwww

thanks @PaulWhite

:)

@swasheck It's not released yet, 3 projected users will be 0 actual users when they actually start using it

swasheck

7:58 PM

:)

Tom V

Well it's released, but not long enough to actually be implemented anywhere

2 weeks ago or something

Fun fact, I talked to their program manager and asked the question "So it's not really working yet", he replied "Oh yes the product is working, the tools not so much"

duh

swasheck

interesting distinction

Lamak

@TomV maybe the tools are the devs?

swasheck

they are here, that's for sure

ooh. found my next book to read

amazon.com/Three-Felonies-Day-Target-Innocent/dp/1594035229

Tom V

The printing isn't an issue at all, since the thing runs on azure, it stores pdf's of printed doc's on an azure blob storage and you need to install an agent on a local LAN machine. The agent isn't a real service but an application. I tried to configure it but chose the wrong tenant url (yes you need to type it out by hand) and when reconfiguring it it kept saying "access denied". I asked one of the dudes "ah yes we know, once you failed authentication you need to restart the application"

the product is working! (barely)

swasheck

8:04 PM

@TomV lack of CUPS drivers?

Tom V

They keep referring to the one project they got live, Lotus F1 team, that surely compares to a 1000 user ERP system

@Lamak I think the tools are the managers

Max Vernon

8:45 PM

do we know why @jcolebrand deleted this question about temp tables vs table variables?

also, @shog9 - what's the deal with this being deleted?

bluefeet

they both were migrated incorrectly here and are on SO

Max Vernon

ahhhhh

bluefeet

SO versions

251

Q: What's the difference between a temp table and table variable in SQL Server?

In SQL Server 2005, we can create temp tables one of two ways: declare @tmp table (Col1 int, Col2 int); or create table #tmp (Col1 int, Col2 int); What are the differences between the two? I have read conflicting opinions on whether @tmp still uses tempdb, or if everything happens in memor...

sql-server temp-tables table-variable

158

Q: List of all index & index columns in SQL Server DB

How do I get a list of all index & index columns in SQL Server 2005+? The closest I could get is: select s.name, t.name, i.name, c.name from sys.tables t inner join sys.schemas s on t.schema_id = s.schema_id inner join sys.indexes i on i.object_id = t.object_id inner join sys.index_columns ic o...

sql-server tsql indexing reverse-engineering

Max Vernon

coool. thanks, oh mighty blue one!

Max Vernon

9:17 PM

200+ rep days for users of Database Administrators

^^^ might not be perfect, but seems close

Andriy M

This revision to an answer was suggested by the OP, and a reviewer approved it single-handedly (because he used Improve Edit), but I'd say it should have been rejected as too radical (or "conflicting blah blah").

Of course, if the answerer doesn't mind, fine...

@MaxVernon Did you omit the +2 for accepting an answer and the bonuses on purpose or because you forgot about them?

Max Vernon

9:33 PM

@AndriyM because I'm a dummy and forgot.

also, I don't know where to find the actual bonus rep awarded.

@AndriyM seems to me like that edit should have been made to the question, not the answer.

Andriy M

@MaxVernon Or it should have been a self-answer. But not an edit to someone's answer definitely

Andriy M

9:46 PM

Did my best:

To me the edit by OP doesn't seem to belong in this answer, but if you don't mind, so be it. If you do, though, feel free to roll it back. — Andriy M 3 mins ago

Not sure if the reviewer should be called out on that approval or, if he should, that it's fine if a regular user does that.

Paul White

10:55 PM

@MaxVernon For the meaning of "migrated incorrectly" in those cases:

6

Q: Scope, migration and respect for other users

Update: a blog post based on feedback here and elsewhere: Respect the community – your own, and others’ The history of migration Stack Exchange has grown considerably over the past few years... When Server Fault first launched, it was an attempt to replicate the formula that had wor...

discussion migration scope

Max Vernon

Thanks, @PaulWhite

wBob

Good evening Wellington! On stand-by for some cracking April Fool's jokes no doubt : )

Paul White

@wBob Ends at midday doesn't it? i.e. in 10 seconds

wBob

@PaulWhite lol the "fun" is just about to start here.

Like did you hear the one about where OPENXML goes faster than XML datatype?

Paul White

@wBob Woo hoo (not)

wBob

11:01 PM

lol me neither. I mean some people say, but I've hardly ever seen it.

Max Vernon

That was a great read, Paul. Thanks again.

Paul White

@wBob It does sometimes, doesn't it? Been a long time since I consciously used xml

@MaxVernon It was referenced in the flags that caused those questions to be deleted, and thereby the migration rejected.

wBob

Like I say, rumour has it, and I think I've seen it happen, but can't remember where. Generally favour the other type. I did think it was odd there four SQL Server and XML questions here in the last two days. Guess somebody's using it : )

Paul White

It'll be json questions next.

wBob

Yay!

So any good ones (April Fool's Jokes) your side of the world? That new flag is a contender no? [ducks]

Paul White

11:07 PM

Oi.

wBob

Ha. West Indies beating India at cricket must be made up.

Paul White

Yeah but I watched that live so it definitely happened. Good game.

wBob

Those "SQL 2016: it's just faster right" PSS posts have been kind of amusing too.

Paul White

Oh I haven't seen those, I could do with a giggle, I'll check them out!

wBob

I mean I believe them, but looks like they bypassed the slick Marketing division and someone just pressed "publish".

This was the original and best (worst): blogs.msdn.microsoft.com/psssql/2016/02/23/…

Paul White

11:12 PM

Thanks.

2

A: SQL Server 2008R2 Alias not working

Summarizing what we discovered in the chat. When connecting over the network if the windows server is registered in Active Directory (AD) with a Server Principle Name (SPN) clients that try to connect with Integrated Authentication will get the Kerberos token from AD for the AD object that match...

Nice outcome.

Transcript for

The Heap™ – Consultancy ©®