The Heap™ – Consultancy ©® - 2016-04-01

« first day (1914 days earlier) ← previous day next day → last day (2951 days later) »

3:30 AM

Brilliant

google.com/get/cardboard/plastic

2 hours later…

5:14 AM

Should all questions be taken seriously today?

"I've got this problem..." – "Yeah, right..."

2

6:07 AM

The edit is totally against the site's intentions. It uses table and column names that come from godly intervantion and nowhere to be found in the question. If this newly provided table and column names were to be somewhere, it should be in the question itself. — ypercubeᵀᴹ 10 secs ago

@AndriyM ^^^

@ypercubeᵀᴹ I was felt like educating both the OP and the reviewer yesterday, but eventually thought against it.

*I felt

Is there a way to determine (only for a moderator, apparently) if this edit could be from the OP?

6:26 AM

@AndriyM Yes it is, as far as I can tell.

@PaulWhite Thank you. Voted to approve.

@AndriyM Cheers. I added a comment as well.

I always forget to click Improve.

6:43 AM

Oh no. Actually they posted another one later, under a new account, too.

0

Q: how to select the minimum of a calculated value with out sorting it

so i have a query dealing with geo distances the query super fast roughly .1175 seconds on my 2.24 million rows however i only need the lowest distance and using the built in order by is way too slow is there anyway to just keep track of a running minimum and just give me that? for example city...

Sorry, @Paul, so much trouble, and probably for nothing.

Duplicate of dba.stackexchange.com/questions/134024/… — ypercubeᵀᴹ 3 mins ago

@AndriyM Thnx. I had actually voted for this one to be closed as not clear. Didn't realize, when you mentioned the other q here, that they were 2.

@ypercubeᵀᴹ Perhaps we should close the older one as a duplicate of the newer one, because the newer question was posted under a newer account too. The OP won't be able to take control of the original question (not immediately, anyway).

Such a mess, and, to a great extent, I am to blame.

7:18 AM

Ah shoot, I answered a question that was crossposted to SO (including my edits from here)

Today's going very well all around :)

I'm gonna go and play UniKong!

@AndriyM The new account is a login-based one, so that sort of makes sense.

Closed as duplicate the other way around so he has control of the open question.

As a bonus, the answer over there is wrong

level 3

7:23 AM

@TomV Will you keep teasing or will you finally post a link?

Hi there, you have posted this question on dba too. Please don't cross post questions. Pick a site and stick with it. Flag for migration if you think the question was posted on the wrong site and you want it on the other. — Tom V 2 mins ago

At last!

@TomV Thanks :)

I'll see if another mess can be created out of that one too

Flagged on SO and DV'd the answer there.

Yes cross posting is not allowed

SSRS is back in game

Yay.

7:31 AM

@Mathematics How's your report coming along?

TIL April fish is a local habit

Yes we're weird like that

> This includes attempting to attach a paper fish to the victim's back without being noticed.

Sounds pretty cool actually.

Yes, loads of fun for kids

I just told my wife. If we remember, next year we will attempt the paper poisson.

I don't really see how lying is fun :/

@TomV not too bad to be honest, I haven't started on adhoc reporting yet though

8:01 AM

There's one thing I hate about MSDN forum, people who answer the thread can mark it as a answer too, maybe one day Microsoft purchase SE, SO
OR at least they update there forum to something like SO/sE

It's probably inevitable. Some people make mistakes, others learn from them.

The SO phenomenon could be attributed to someone's genius – or it could be seen as something bound to happen at some point, what with so many less successful attempts made at Q&A by others.

8:31 AM

Microsoft is just too slow yet in game

0

A: Performance of a=0 and b=0 and ... z=0 vs a+b+c+d=0

I would guess that the separate AND conditions would be preferred since the optimizer would be more able to short-circuit the operation if a single one of them is 0, without needing to do a computation first. Still, since this is a question of performance, you should first set up a test to deter...

Can think of an answer? Easy! Just copy two others!

@AndriyM Hey!, Please, don't worry. It's OK. ;) +@PaulWhite

Ha! We haven't done that for a while :)

LOL

And I knew that was going to happen only after the grace period was over :)

8:51 AM

The BI crew has a query they want optimized. I told them it was a good April fools joke.

3

gist.github.com/anonymous/a37988118b1c4932a0d0ee7db5895790

Except it wasn't a joke

9:22 AM

brb

@TomV I like the aliasing. From "DATAAREAID" to "C0" and then again to "DATAAREAID"

Oh, and the triple underscores in the table aliases ;)

@ypercubeᵀᴹ I bet it came out of Cognos or something

In any case, I'm not touching it

@TomV Haven't used it ever. Seems to produce less crap than EF.

10:16 AM

This q seems off topic to me:

0

Q: Why is AWS RDS Oracle so cheap?

I am planning on using oracle on AWS but surprised at how cheaper it is compared to SQL Server. With the same exact server configuration oracle is cheaper than SQL Server. How can this be? is there some gotcha if I start developing against oracle? PostgreSQL Oracle SQL Server

sql-server oracle aws license

A funny title:

0

Q: select sql query

i am kind of new to SQL language. i have a below query and need a select sql for it. i have a table in database for same identifiers there are say 5 fields in table i need a sql where i can get all those values in different columns e.g my table is ID type value a 1 125 a 2 154 ...

Three words: select, sql and query. Aren't they tags synonyms?

-2

A: How can I update a json element in postgresql json datatype

Please try it, I'm using postgresql 9.5 with dataType column jsonb UPDATE "user" SET "profiles"='{"Facebook":{"social":{"facebook": "test"}}' WHERE "id" = 1;

please send this into oblivion

11:18 AM

@dezso is -6 ok with you? ;)

@ypercubeᵀᴹ getting better

Copying entire sections of the documentation as your whole answer is not normally well received here, particularly so if it is poorly formatted and not attributed. See How to Answer and How to reference material written by others. — Paul White ♦ 34 secs ago

@PaulWhite does the answer add anything more? I had the passage copied from MSDN in my answer already.

@ypercubeᵀᴹ It doesn't. I'm was giving leeway to a new user. I hadn't noticed your answer! Thanks.

Fixed. By painting it pink.

0

A: Quickest way to migrate mirroring to AG

If you want to ensure you minimize the amount of time you are without HA during your migration, here's a trick I recently used: Set up the AG with a "dummy" database so that your AG is ready in advance. Log ship the database(s) to both your primary & secondary AG replicas--at this point, the l...

Seems like a neat trick.

11:35 AM

@PaulWhite Pink is the new black

@PaulWhite We did exactly this a few months back because the DB was 2.5TB and the two FCIs were in different physical sites. Transfering a FULL backup across the line would have hurt

@JamesAnderson So a big Mythbuster confirmed tag then? Cool.

@PaulWhite Yeah worked a treat

To be fair, that might have been what Allan Hirt was referring to in his answer, but he didn't spell it out.

> ...but to another DB you could then make an AG later

possibly but he may have been saying: logship to 1 DB when ready add it to the AG, then do a full backup to prep the secondary.

the logshipping to both nodes\FCIs means no FULL backup is required (other than the one to start log shipping in the first place)

11:42 AM

Right.

In any case, I much prefer the new answer.

Agreed

12:35 PM

New Post: Microsoft Discontinues SQL Server Support for Windows https://www.brentozar.com/archive/2016/04/microsoft-discontinues-sql-server-support-windows https://t.co/72fVnOUwWX

Tweeted by BrentOzarULTD on April 1, 2016 at 12:16 PM

@PaulWhite and it wouldn't actually surprise me, given the madness of the last few weeks

This C# lark is soooooooo easy

yesterday, by Paul White

I just don't know how we'll spot Microsoft's April 1 joke this year.

Yep.

#SQLServer 2014 Developer Edition is now free! Download through #VSDevEssentials:http://msft.it/6011Bi3ZL https://t.co/LFEA5qHNLv

Tweeted by SQLServer on March 31, 2016 at 9:17 PM

Not a joke. Why they would announce it on April 1 is beyond me.

12:51 PM

@PaulWhite is it really not a joke?

@PaulWhite They didn't, they just forgot about some of the time-zones

@Lamak Really.

uh

I wasn't expecting that

Free Visual Studio, Basic Team Services, Pluralsight, $25 Azure Credit, R Server Dev Ed, Xamarin too.

@PaulWhite Probably because it was announced in the conference? channel9.msdn.com

which is 3 days, started March 30

12:59 PM

Sure. It just seems every year there is a serious announcement on April 1.

@PaulWhite At Microsoft, they haven't got the note that the New Year now starts at January 1st

New Year is the time at which a new calendar year begins and the calendar's year count increments by one. Many cultures celebrate the event in some manner. The New Year of the Gregorian calendar, today mostly in use, falls on 1 January (New Year's Day), as was the case both in the old Roman calendar (at least after about 713 BCE) and in the Julian calendar that succeeded it. The order of months was January to December in the Old Roman calendar during the reign of King Numa Pompilius in about 700 BCE, according to Plutarch and Macrobius, and has been in continuous use since that time. Many countries...

> March 25: Feast of the Annunciation (Christianity), and its related observances:
> Historic start of the new year (Lady Day) in England, Wales, Ireland, and the future United States until the adoption of the Gregorian calendar in 1752. (The year 1751 began on 25 March; the year 1752 began on 1 January.)

@PaulWhite $25 Azure Credit? Where does it say that?

Ah, I have found it. $25/month for 12 months

user image

That's pretty awesome as I was planning on playing around with DocumentDB

$25 might not buy you much, but it is $25 better than $0

1:10 PM

@PaulWhite It buys you a DocumentDB collection for a month, so not bad

@PaulWhite is this an April Fools joke, too?

brentozar.com/archive/2016/04/announcing-mail-order-dbas

No idea. Honestly who can tell.

Ah, it probably is

> Global coverage
>
> Your local talent wants way too much money. We scour the globe to find people with a much lower standard of living, then help you take advantage of their situation.

> Photography
>
> A picture is worth a thousand words, so we photograph all of the candidates. We capture them discussing projects with the team, troubleshooting stressful outages, and relaxing during lunch so that you get a complete understanding of how they work.

Obviously a mailorderbrides reference

> offshore candidates that you’d never ordinarily get the chance to meet. You can try them each out, select one that works best for you, and then we’ll work together to get the necessary legal paperwork done

But well worked out, with a real site and everything

yeah, it even has customer reviews

> Join and quit, join and quit – every time I thought I’d found a good DBA, they left me high and dry for some startup. MailOrderDBAs.com found me a lifetime relationship with someone who won’t let me down.

1:16 PM

Ha. Yes. Though the "lower standard of living" part is a bit close to the truth.

1:48 PM

Unikong is surprisingly fun.

@PaulWhite surprising because we hate fun?

@bluefeet Yes!

Well, no. I was more surprised that it was so playable, and enjoyable. Even if I couldn't get the Konami code to work.

@ypercubeᵀᴹ "Won't let me down" – of course.

"Won't give me up" either, I suppose.

2:07 PM

anyone got a second to help me understand why my SQL query isn't working the way I expect? I'm querying an Oracle database with: SELECT * FROM MYTABLE WHERE COL_A != 7 AND COL_B != 1... I expect results that would include, for instance, 2 in COL_A and NULL in COL_B, but I get an empty set.

Col = NULL and Col != NULL never evaluate to true or false, but to unknown. For null tests, use IS NULL or IS NOT NULL.

I don't care if it is null or not, I just don't want results where both COL_A = 7 and COL_B = 1

Doesn't help that I didn't get enough sleep last night :P

So to cover nulls as well, change it to (COL_A != 7 OR COL_A IS NULL) AND (COL_B != 1 OR COL_B IS NULL)

Ahhh, that seems to make sense then

Thanks @AndriyM

@DavidWilkins No problem

2:23 PM

@DavidWilkins By the way, if you want to invert specifically COL_A = 7 AND COL_B = 1, the correct form would be (COL_A != 7 OR COL_A IS NULL) OR (COL_B != 1 OR COL_B IS NULL) (brackets are now redundant, of course). The AND variation I posted earlier would be the inversion of COL_A = 7 OR COL_B = 1.

2:40 PM

i'm just here for the april fool's pranks

2:58 PM

What is the difference between "Delete" and "Recommend Deletion" (aside from the obvious) in the Low Quality Posts review queue:

user image

this is the review: dba.stackexchange.com/review/low-quality-posts/67550

this is the answer: dba.stackexchange.com/a/134037/10832

the answer does not show any "Delete (1)" indicator, or anything else other than the standard "This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - From Review "

@MaxVernon you have delete privileges so in review you are voting to delete. The other person does not so if they think it should be removed they recommend delete

so the "recommend" bit is about pushing the user who posted the answer to "self delete"?

112

Q: Let's get rid of the 10K flag queue

The 10K tools are pretty cool... You get a birds-eye view of activity on the site, a "dashboard" view of what's happening. Some of the individual tools haven't scaled particularly well with Stack Overflow's growth, but the concept behind them is still sound: we trust you to enough to be a bee wat...

feature-request status-completed review moderator-tools flag-queue

in other words, it doesn't actually do anything?

If anyone had downvoted it, yes.

> 2. Post accumulates 3 Delete votes (can only happen when post scores <= 0 and reviewers have >= 20K rep). Outcome: post is deleted, flags are marked "helpful".

3:05 PM

or

> Task accumulates 6 RecommendDelete + Delete reviews.
Outcome: mark flags "helpful". If the post scores > 0 then raise DisputedLowQuality mod flag, else just delete post (current behavior).

I seem to remember some other differences between Delete and Recommend as well, but Max can search meta just as well as I can.

@PaulWhite point taken. thanks for pointing me in the direction.

Oh it goes back to recommend when you run out of delete votes for the day. That was one thing.

what about motivation to participate in the site? does it do anything to help that?

@swasheck Not by voting, apparently.

3:14 PM

sumbit

:-D

3:28 PM

-2

Q: How to make connection with Mongolab using c#

In details, I want to make a ssis package for data migration from sql server to Mongolab. I referred https://rajendersehgal.wordpress.com/2015/07/14/data-migration-between-mssql-nosql/ I am new in c#, please let me know what else required for connection with Mongolab.

c# ssis mongolab

VtC, gimmie das codez

argh, another SO post

They should come with a warning.

feature-request SO link one boxes should be red. Or invisible.

user image

@swasheck - I promise to fact-check all my answers as thoroughly as possible prior to posting them.

if you're gonna get schooled on Postgres, I guess who better to do it than Craig.

On the upside - I'm really glad that I know that about PostgreSQL now. Who'd have thought the on-disk format would be tied that closely to the version of PostgreSQL and the architecture of the machine.

clearly the inferior technology to mysql

@swasheck - the sarcasm is strong in you.

3:42 PM

yes. i've not yet pooped

presumably when you made the line about Fox News yesterday that is what you were talking about? Or was it some other crapness I laid yesterday? (I'm presuming being compared with Fox News is not a compliment)

@MaxVernon no. @PaulWhite mentioned you were being "balanced"

@swasheck ahhhh :-)

I thought perhaps I was getting the wrong end of the stick on that.

@PaulWhite ahhh souza

Do you folks enable TF 1118 globally?

3:49 PM

yes

I'm noticing that we don't have it.

@swasheck Yes

he's a funny guy even when Brent's not pretending to be him

@Zane I think it's on by default in 2016.

@PaulWhite so I'll have in here in 2022 sweet.

:)

3:54 PM

@Zane I try to.

1117 is good too.

Enable all the flags.

declare @tf int = 0
while @tf <= 10300
begin
   dbcc traceon(@tf,-1);
   set @tf = @tf+1;
end

@swasheck lol I was just about to post something similar.

hmmmm. that might be fun to try.

@MaxVernon how would you document the behavior changes?

3:56 PM

Trace flag 699 - too late for April Fools

you'd need a mole in PSS ... they have the descriptive headers for the TFs

@swasheck They go to 10300.

user image

@PaulWhite well fine, captain one-upsman

@swasheck Captain Pedant McNitpicker, please

With caps.

3:58 PM

user image

@PaulWhite Ah, I thought you were posting code to hack the UniKong into some ridiculous high score...

@ypercubeᵀᴹ Been done and fixed already.

Someone managed to score a million.

@MaxVernon Yes, it's a pity. I hope it gest fixed in the future.

It also affects streaming replication / restore from basebackups. Has to be dome in a machine with "same" or simialr characteristics (bitness, etc)

@ypercubeᵀᴹ even though I know almost nothing about PostgreSQL, I could see that being a major downer.

the kind of thing that could really bite you in the ass

@MaxVernon Yes, it could. But really, if you actually need to restore, you usually restore in the same or similar machine.

4:06 PM

@ypercubeᵀᴹ as long as it didn't die a horrible death.

and you can still find the binaries.

and the binaries for the OS

Yeah. If your 10-year old machine died in horrible death, you amay be fucked.

I know if someone asks me the pros-and-cons of SQL Server vs PostgreSQL, that's going to be pretty up-there on the list.

@MaxVernon The binaries of the OS is not a problem. Postges usually runs in Linux

@ypercubeᵀᴹ as Craig noted in his answer, the NAS the guy was running on might have compiled PostgreSQL with some weird flags, necessitating that he find the old firmward version for the NAS.

And you can always restore using other types of backups, to any type of OS/bitness and version

4:08 PM

not that I'm saying it's a good idea to run any RDBMS on a NAS.

@MaxVernon On the good side, there is a cool new tool I'm testing, that allows replication between different major versions and even OSes.

@ypercubeᵀᴹ sweeet. that's definitely a plus sign.

@MaxVernon Yeah. My plan is to use it to upgrade from 9.4 with 9.5, with zero downtime.

More as a test, not that we really need it at this point.

Zero? Instant replication?

always good to have those avenues mapped out before you actually need them

4:12 PM

@PaulWhite OK, not exactly zero.

The time you need to do a failover.

Ah OK.

@PaulWhite it uses quantum teleportation as a transport mechanism.

It's like replicating from 2012 to 2014. I guess that is not possible in SQL Server. Right?

Honestly don't know.

I think you can go up versions. Of course, I'm probably wrong.

having said that, you can use mirroring to accomplish the same thing, with around 10 to 20 seconds of downtime, maybe less.

4:15 PM

It's probably different for repl/mirroring/AGs/clustering.

Log shipping works too. Same thing really.

yep

mirroring is essentially log shipping on steroids since the source is continually shipping log records to the target.

> An unarmed man who was shot and killed by an Arizona police officer in January cried, complied with police orders and begged for his life ... according to a newly released police report.

Just the time to apply the final log.

naturally, he's dangerous so we should shoot him

@swasheck clearly deserved it then

4:18 PM

Assume he was shot at least a dozen times, just to be sure?

and driven over

Not that guns kill people.

April fools day sucks. I was prepared for all the news people not being funny. What I forgot about was all of my coworkers not being funny.

@Zane cellophane on the toilet seat

5

Q: Can I replicate a database from SQL Server 2012 to SQL Server 2014 (with 2014 distributor)?

I am planning to have database replication running from SQL Server 2012 (publisher) to SQL Server 2014 (both distributor and subscriber) -- pull replication. Has anyone done this type of cross-version replication and knows if there are any issues with it? Thank you!

sql-server sql-server-2012 replication sql-server-2014

So yes then.

4:21 PM

@swasheck so original, yes

@PaulWhite Oh great, thnx.

people suck.

theguardian.com/technology/2016/apr/01/…

Haha, they roled back my edit. At least they didn't do the same with Paul's.

dba.stackexchange.com/posts/134068/revisions

4:36 PM

@ypercubeᵀᴹ yeah, made complete sense

why formatting if you can just post a pile of garbage

@swasheck if someone was really fired because of that, it was possibly too late to leave that job anyway

one of the dba's here just asked why would they make developer edition free.

the same reason they gave you 100 GB of OneDrive and then took it away

the same reason your first bump from a drug dealer is free

2

@MaxVernon your dbas arent very smart, are they?

4:55 PM

@swasheck apparently it's easier to not have to explain things to developers if they don't have the Enterprise-equivalent version at home. or something. I lost interest.

but then I like explaining things to ~~mere mortals~~ developers.

At. Great. Length.

@PaulWhite I do try.

5:48 PM

Cool, multithreaded log writer in SQL Server 2016. exadat.co.uk/2016/04/01/…

they've done some work on the logging

6:06 PM

@swasheck 'twould appear so.

2 hours later…

8:18 PM

I'm feeling like i sit in a chair with 3 legs only.... It looks good, but can kill you.

2 hours later…

9:53 PM

And so it continues: zdnet.com/article/head-of-oracle-linux-moves-to-microsoft

Microsoft is changing in ways I never thought I'd see. I literally cannot wait until at some point they maybe focus on Windows Phone.

« first day (1914 days earlier) ← previous day next day → last day (2951 days later) »

Transcript for

Apr '161

The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile