The Heap™ – Consultancy ©® - 2015-02-25 (page 1 of 2)

billinkc

12:05 AM

That'd have been pl/python/ps1 which is still in alpha

Zane

2:37 AM

@MikeFal you're right I am going to apply for that job.

Jumping in the deep end has always been my MO. Can't see why I shouldn't try now.

swasheck

2:56 AM

@MikeFal postgres has language support for powershell?

also, can you whip up a quick trie for me in posh?

Paul White

7:20 AM

@swasheck Thanks!

dezso

12:27 PM

0

Q: EXECUTE format not working

DO \$$ DECLARE customer_list varchar[]; customer_schema varchar(100); portal_row a.portal%ROWTYPE; var1 varchar(100); temp varchar(100); BEGIN customer_list=ARRAY(select cname from customer); EXECUTE format(' %s'...

that hurts

dezso

12:47 PM

@user606521: That's like telling a French person that he should "finally understand that he must not expect proper French in his conversations, but gibberish from Google translate is equally valid". It's the other way round: ORM users must understand that ORMs are crude crutches that are popular with lazy developers trying to avoid learning SQL. Fair enough, I am lazy, too. But don't turn it around on us. To use the full potential of your RDBMS, you need to speak the native language, which is SQL. Your ORM is doing a poor job. Besides, "SQL database" is a misnomer. SQL is a query language. — Erwin Brandstetter 6 hours ago

dezso

1:08 PM

massages:

0

Q: Select the last massage for each user

Please help me with a query. I want to write a query that selects every last massage from each user (I want to create a dialog page for my site). My tables: users: id, name, surname massages: id, sender, recipient, text, date This is what I tried, but it doesn`t work: SELECT users.id AS id, ...

sql select

ypercube

Interesting read: davidmichaelross.com/blog/a-living-fossil-of-computer-history

dezso

ypercube

There is one to one massaging system so we need one userID to fetch message or related to given userID — Ajeet Kumar 3 hours ago

"massaging system"

James Lupolt

1:24 PM

heh

Lamak

@ypercube one to one

Tim Stone

1:52 PM

@dezso Hah, I need this. :P

JNK

Let's hear it for covering indexes!

bluefeet

Hip Hip Hooray! Covering Indexes!

how's that?

JNK

perfect

James Lupolt

@JNK Have you tried using NOLOCK instead?

JNK

2:08 PM

@JamesLupolt oh good idea

First I'll just see how long I can hold my breath...

Paul White

2:50 PM

Hi @spaghettidba

billinkc

@ypercube I nearly had to work on a pick system in 2000/2001. Fortunately(?), I got put onto a different project which ended up being converting dBase4 forms app to Access

spaghettidba

Hi @PaulWhite

Paul White

@spaghettidba So you had some questions about site moderation?

Specifically regarding this question:

0

Q: How can we select data from another table during an insert?

I tried the statement as follows... insert into wtdocversion values (( select id from wtdocmaster),'col2','col3');

sql-server sql

spaghettidba

Yes, I'm having a hard time understanding why legitimate questions get closed for "lack of clarity"

I admit it's subjective, but I see this pattern here more than elsewhere

Lamak

@spaghettidba well, what's the question that's been asked in that post?

Paul White

2:53 PM

@spaghettidba The close "reason" doesn't always reflect the first vote reason. Five people (or one mod) have to vote to close a question. They can select different reasons.

spaghettidba

@Lamak the one that's been answered

I see

Lamak

@spaghettidba what was answered was how to insert data from another table, the title hints to something else, hence the lack of clarity

Paul White

I think that one is a pretty poor question by any measure. It's all a bit basic for this site. Basic questions are often closed by the community, particularly if it's just basic syntax.

spaghettidba

I'm under the impression that the site's purpose is beyond helping people then.

It's a shame, because that's what I'm here for

Paul White

@spaghettidba As I understand it, the main goal is to create a library (wiki) of good questions and answers that have wide applicability for future users of the site. It's not a forum, where the goal is often to ask and answer as many questions (including duplicates) as possible. Neither is necessarily better, just different.

spaghettidba

2:57 PM

I see

bluefeet

@spaghettidba If you understand the question, then you have the ability to edit into something that would be usable and udnerstandable to anyone with the same problem.

Paul White

@spaghettidba Also, closing is not permanent. As you can see, the question is "on hold". If the question is improved, it can be reopened.

spaghettidba

I don't have enough privileges to edit questions

Lamak

@spaghettidba it's what @PaulWhite says, but still, it is to help people with advanced issues about databases, for a question that basic, you should google it

bluefeet

@spaghettidba you can suggest an edit, it will go into a review queue

Lamak

2:58 PM

(or, not you, but the user asking)

Paul White

Anyone can suggest an edit.

spaghettidba

OK then, so I was right thinking that my mindset doesn't fit properly with the rules here.

Paul White

@spaghettidba And more to the point, you can still "help" the questioner in comments to the question. Such help can include getting them to improve the question so it becomes on-topic again.

@spaghettidba What is your mindset?

billinkc

And after using your search engine if you are unable to find an answer, then come here. Show what you've done, explain what you're attempting to do. Provide table structures, sample data. That's helpful for you because it shows you've really tried. It's helpful for those who answer questions because that's what we need to know. It's helpful for posterity as you have then defined the reference question for everyone else trying to solve the same problme

spaghettidba

I've always thought that there's no such thing as a poor question

Paul White

3:01 PM

@spaghettidba How can I fix my SQL problem?

There's a poor question right there :)

spaghettidba

And I also find inappropriate smacking people for asking poor questions

Lamak

@spaghettidba really?

spaghettidba

@PaulWhite Here's a poor answer: "google it"

Lamak

how can you think that there are no poor questions?

billinkc

Have you read dba.stackexchange.com/help/asking

Paul White

3:02 PM

@spaghettidba I know. I got sick of that sort of response on SSC ;)

@spaghettidba Placing a question on hold isn't "smacking" anyone. It's inviting improvement.

Lamak

@PaulWhite it's actually banned (or was)

Paul White

@Lamak Quite right too.

Lamak

yup, I agree

spaghettidba

@PaulWhite That's where I come from, as you know

bluefeet

@spaghettidba poor question

Paul White

3:03 PM

@spaghettidba That's why I mentioned it.

@spaghettidba Besides, if you really want to "help" someone with a forum-style extended discussion, that's what chat rooms are for.

Create a chat room for you and the questioner, invite them there for discussion.

So, I don't really see what the problem is, unless the problem is "this site doesn't work the way I am used to on SSC".

Lamak

@spaghettidba have you spent some time in SO?. There are so many ways a question can be poor, lack of information, posts that don't include any question, questions that haven't been researched, questions that have been asked thousands of times

Paul White

Also, there are plenty of good SQL questions that aren't on-topic here. That doesn't mean they're not interesting or valid, just they don't fit the Q & A model very well.

ypercube

What was the deleted comment in that q?

Paul White

@ypercube Snark.

spaghettidba

@PaulWhite Yes, that's probably part of the problem. More specifically, that's not how I treat people, here or anywhere else. I don't like abrasive comments in particular, especially when directed to newbies in desparate need.

bluefeet

3:08 PM

@PaulWhite which rightly should be deleted

Paul White

Something like "do you even understand your own question?"

ypercube

ah

@spaghettidba We all agree then, snark is not good.

billinkc

I would think if they were in desperate need, they'd have stuck around. Looks like they asked their question and went away

bluefeet

@spaghettidba part of the problem is people are frustrated with bad questions and users who don't care to post anything that has quality. That's where the snark comes in. But if you see it, then flag it to be removed.

Paul White

@spaghettidba Neither do we, hence the removal.

Lamak

3:09 PM

@spaghettidba that's a good mentality, but it doesn't mean that the question isn't poor

3

spaghettidba

That's certainly a poor question, but not hopeless. The OP can always come back and edit according to the guidelines.

I'm ok with putting it on hold

bluefeet

@spaghettidba that can still happen, and the post can be reopened

Paul White

Violent agreement breaks out.

3

spaghettidba

@PaulWhite :-)

ypercube

@spaghettidba The question was rightfully put "on hold" though. I could see (probably) why the statement failed (and even that the answer solves the issue) but the question needs editing to make everything clear - for everyone. What error they got, what they are trying to do etc. You - everyone - can suggest edits.

spaghettidba

3:11 PM

Ok then

Thanks everyone for steering my understanding of the rules and the general sentiment here

bluefeet

that entire comment thread could be removed from that question

spaghettidba

I can do it for my own comments

Paul White

There are so many alternatives. If reopening failed, you could always paraphrase the question, then ask and answer it yourself. That's another way of adding value to the collective knowledge.

spaghettidba

@blue

@bluefeet done

Paul White

(Up arrow is a quick way to edit a comment in chat)

spaghettidba

3:14 PM

@PaulWhite Thanks ::blush::

Paul White

Ha! Those codes don't work here. You're welcome.

We now return to our regularly scheduled crickets.

crickets

ypercube

and the site agrees (currently down for maintenance)

Oh that was fast maintenance

Paul White

Just a blip. It's back.

bluefeet

I blame the crickets

so really, I blame @PaulWhite

4

billinkc

need a bearded dragon to take care of them

Paul White

3:17 PM

@bluefeet fair enough :)

mmarie

@billinkc I prefer gila monsters

ypercube

The original q should have been deleted and a new one opened but I guess we can follow a simple road and reopen it: dba.stackexchange.com/questions/93747/…

billinkc

@mmarie Declined. Non poisonous lizards plzkthxbai

Paul White

@ypercube Voted.

bluefeet

Well I've edited this into a better question, do we want to reopen it?

swasheck

3:24 PM

cthulhu

not a lizard

billinkc

Still seems poor quality IMO

Paul White

Marginal. Voted to reopen b/c feet of blue put effort into it.

bluefeet

Well at least it makes sense. It's still a ~~RTFM~~ read the manual type of question

Paul White

Four reopen votes should be enough on dba.se

bluefeet

removed the snark

Mark Sinkinson

3:33 PM

I was only second-guessing the answer to that question anyway. I assume that is what the question was about, but quite honestly, it may have been something completely different they wanted...

swasheck

i'm always losing to win

billinkc

Based on title, they could very well have been trying to look up a reference id based on source value

Paul White

@MarkSinkinson We may never know.

billinkc

I'd be willing to wager a frosty beverage that user will never be seen from again

Paul White

Two frosty beverages

billinkc

3:35 PM

one more thing... how to pass variable value to this long string from @command variable — ile 4 mins ago

Oh hooray, an impromptu meeting. Leech can wait

JNK

cleaned up

Paul White

Hooray for mods! And covering indexes!

swasheck

you dont want nekkid indexes

Paul White

@billinkc Nice answer.

2 hours ago, by JNK

Let's hear it for covering indexes!

(for context)

dezso

I am wondering what the context of that one is

JNK

3:48 PM

@dezso argument I had yesterday with coworker

NOLOCK vs a covering index for a blocking issue

the index was applied last night and blocks have dropped drastically

bluefeet

@billinkc probably, they are an unregistered user

swasheck

@JNK a truly scientific test would be to drop the index and implement nolock

@dezso do you know how to get plythonu up and running on pg 9.4?

ypercube

@swasheck Linux/windows/Mac?

swasheck

windows

and none of the SO answers from @CraigRinger help me much

ypercube

@swasheck You can comment on his answer here: stackoverflow.com/questions/24633832/…

He would probably know.

or better post a question at this site?

swasheck

4:01 PM

yeah. i know. it's just soclose to being a dupe, though

Paul White

Craig Ringer. Another ex-SSC person.

swasheck

cringer

ypercube

Windows is quite different when installing python packages.

swasheck

@CraigRinger ... not sure if you get this from me. if not, maybe @JNK could ping you? anyway. HALP!

ypercube

@swasheck Did you have it running with 9.3 (and the problem is only with 9.4)?

swasheck

4:03 PM

@ypercube no. stop with your sensical nonsense.

ypercube

@swasheck ypercube hides under a rock (but not before adding another nonsense: stackoverflow.com/questions/21323236/…)

swasheck

@ypercube yes. that's the answer that i tried last night that started me on this magical mystery tour

user965347

hi experts!

i have some 32~40GB data when i fetch it took long time

is it normal for mysql?

Mike Fal

@Zane Saw what you said about the job. Good luck man, I think it's a good call.

ypercube

@user965347 Not many mysql people here. You may try the mysql-chat-room

user965347

4:12 PM

ok

user965347

4:29 PM

cant even chat

John M

Pretty sure you can, I see about a dozen 'hi's

user965347

oh i have anyway

billinkc

Possibly of interest blogs.msdn.com/b/bethmassi/archive/2015/02/25/…

Understanding .NET 2015

JNK

4:56 PM

@swasheck what do you need from me?

ypercube

@JNK to ping CraigRinger with your mod superpowers

bluefeet

@ypercube I believe anyone any do that with a superping

just use @@ before the name

ypercube

@bluefeet really? I didn't know that!

bluefeet

try it ;)

Paul White

@@Superping !!!

bluefeet

5:02 PM

oops, I should have said

GIVE IT A TRY!!

dezso

@swasheck is there a createlang binary on windows?

billinkc

Now I want to change my name to SERVERNAME or ERROR just so I can get superpinged

JNK

So I didn't apply to the job at BZU but apparently Kendra looked at my linkedin profile this week

I did apply last round though

now I wish I kept my profile updated

billinkc

Wait, comeback!

KENDRAAAAAAAAA

swasheck

@dezso yes. but .... thhhhhpppptttttt

Zane

5:18 PM

So. @AaronBertrand what Super Hero are you going as for SQL Bits?

billinkc

The semicolon

He's going to stand at the end of every statement

4

Zane

@MikeFal I've always learned to swim by jumping into the deep end of the pool

Mike Fal

@Zane It's a large field of candidates, FYI. And the Ozarians are definitely fans of creativity. Think about what you could do to stand out with your application.

Zane

@MikeFal I already applied this morning.

Mike Fal

Cool

Zane

5:31 PM

Hopefully it does. If not I won't exactly be heartbroken.

Mike Fal

Do you know Jes Borland?

Zane

Indeed.

Mike Fal

Let her know you applied, if you haven't already

Zane

She sent me a lovely email telling me to apply.

Mike Fal

Nice

swasheck

5:32 PM

@Zane that's more than i got

Zane

@swasheck I asked for her thoughts on applying on twitter and then we had a quick email conversation.

swasheck

cool

bluefeet

what on earth happened to Mickey Rourke?

Zane

He's old.

bluefeet

that's not just old though

James Lupolt

5:40 PM

He actually looks better lately than a few years ago.

ypercube

5:51 PM

@JamesLupolt That might be true. He doesn't look like Mickey Rourke though ...

JNK

Hard livin

Marian

@PaulWhite Ha! The great @Paul editing @billinkc's SSIS answer on SO? :D

never thought I'd see that

swasheck

@Marian welcome to the land of the living

Marian

@swasheck stranger things have happened, right? :)

Mike Fal

Here's an odd question: If you have a clustered index, and then change the name of a column in that index, does it force a rebuild of the index?

James Lupolt

6:03 PM

@ypercube Yeah he looks like a totally diff person than he did in his 20s. I just find it remarkable that as destroyed as he looks now, it actually seems to be an improvement over a few years ago.

Sorry, why am I talking about this

Time to go home... have a good day

ypercube

@MikeFal with sp_rename?

JNK

@MikeFal pretty sure its metadata change in the table

I don't think the index stores the column names just the column ids

For a filtered index it MIGHT but I'm not sure, I think the filter is stored as a string

but you can see this by looking at sys.indexes

swasheck

GIVE IT A TRY!

2

JNK

yeah that too

Marian

6:20 PM

@MikeFal it's only metadata change.

tested now on a small db :D

Zane

Should I get a Torta or a Vietnamese sammich?

John M

bahn mi?

Paul White

So tempted to kick you for that

2

@Marian :) Just minor formatting.

Mike Fal

@JNK @Marian Thanks, we were just testing that here as well. Just hadn't heard of doing that before.

Marian

@PaulWhite and he didn't jump at your throat yet?

Paul White

6:30 PM

@Marian He's in a meeting. I think.

Marian

@PaulWhite Or getting soft.. (old) :D

Paul White

He looks worse than Mickey Rourke, it's true.

2

billinkc

7:14 PM

I was too busy erasing New Zealand from all the globes in Walmart

3

Zane

@JohnM That's what I got.

John M

@Zane nice choice

Zane

Soooo good.

billinkc

I had Venezuelan and it was superior, although the waiter was slow as molasses

Arepa

Arepa (Spanish pronunciation: [aˈɾepa]) is a flatbread made of ground maize dough or cooked flour prominent in the cuisine of Colombia and Venezuela. It is eaten daily in those countries and can be served with various accompaniments such as cheese (cuajada), avocado, or (especially in Venezuela) split and used to make sandwiches. Various sizes, maize types, and added ingredients are used to vary its preparation. It is similar in shape to the Mexican gordita and the Salvadoran pupusa. Arepas can also be found in Panama, Puerto Rico, the Dominican Republic, and the Canary Islands. == Charac...

Mike Fal

No Indian today?

Lamak

7:23 PM

@billinkc Arepas, nice

billinkc

@MikeFal Nah, met up with Frank K and he doesn't do Indian

@Lamak It's no completos but it'll do

Lamak

true

billinkc

wwwapps.ups.com/WebTracking/…

I thought it was taking a long time for the Summit recordings USB to get delivered. They're close, very close

Zane

@billinkc this is more like a tiny sandwich shop. No waiter involved.

billinkc

facebook.com/ElPortonCafe

Also, hooray for covering indexes

swasheck

7:34 PM

el gordo

billinkc

Si, estoy gordo

mmarie

@billinkc Hey, i was there, too!

Lamak

@billinkc definitely

mmarie

But I <3 Indian food. Chicken rogan josh and naan ftw!

Zane

I got nervous because I got a debt collection call and I thought I'd payed my way out of all that.

Then they said it was 25 dollars. Now I'm happy.

JNK

7:46 PM

@billinkc if you ever come to CT, go to Norwalk and eat at Valencia

best Venezuelan ever

@Zane was it legit?

yup

ok

Apparently I didn't notice a bill for a copay on one of my radiology bills.

swasheck

ah

Aaron Bertrand

7:52 PM

No, I don't think I'm the one who doesn't understand.

I don't think you understand. By "existing" database, I meant the database that is being restored. Which I would think is exactly what you want to do. To clarify: I have a database B on my local system. I make a backup of database A on a different server, copy the *.bak file to my local system, and then use this script to restore the *.bak file to database B. It correctly restores. Obviously database A isn't touched. And my Database B is now a copy of database A. — pmbAustin 2 mins ago

JNK

@AaronBertrand "existing" obviously means "not existing yet"

billinkc

I don't think you understand. Up is Down, Down is purple. Left is mayonnaise. Got it? The restore of the flizziflaze leads to the umblepumple of the files

Yikes

Aaron - Keep your "HELP", it's not needed. — Quent 4 mins ago

Aaron Bertrand

Future valuable community member, for sure

billinkc

I wonder if they'd like to be a mod

They'd be the Yang to Jack's Yin

swasheck

@billinkc he's an angry elf

Zane

8:02 PM

@pmbAustin how would this be useful for others who are searching this? I imagine if they are searching this then they have the same problem as the OP. A problem that this answer doesn't address since you are talking about restoring over and not creating a new copy on the same instance. — Zane 7 secs ago

billinkc

Aaron, do you have a post about how to properly move databases via backup and restore and the perils of just detaching?

mmarie

@MikeFal you around?

Aaron Bertrand

@billinkc hmm, I don't think so

If I did, I would have pointed Quent at it.

Anyway, as it turns out, yes they did try to back up the databases by detaching them, and they haven't learned that valuable lesson yet, but I think it's coming soon...

swasheck

aaron rosin up your bow and play your fiddle hard,
'cause hell's broke loose in SE and quent is a ...

@billinkc i flagged this. why hasn't @JNK removed it yet?

Zane

8:21 PM

@swasheck because it exists to archive forever what a jerk off Quent is.

Aaron Bertrand

Like, seriously

Do you realize that what you've done by "priming" the backup file to the new database using the SSMS GUI or whatever is actually restoring the database WITH MOVE? — Aaron Bertrand 16 secs ago

I always like to perform one-step processes using four steps.

dba.stackexchange.com/review/suggested-edits/41702

Lamak

lol

Aaron Bertrand

Because, you know, we can all act 12

And suggested edit approved by the OP

swasheck

anonymous user

Lamak

wow

swasheck