The Heap™ – Consultancy ©®

8:03 AM

worst question title (and initial question in there) ever:

0

Q: Atomic transaction

Is possible to create atomic transaction in PostgreSQL? Consider I have table category with these rows: id|name --|--------- 1 |'tablets' 2 |'phones' And column name has unique constraint. If I try: BEGIN; update "category" set name = 'phones' where id = 1; update "category" set name = 'tab...

11:56 AM

crickets

^^ just to be faster than @mmarie

Not that she's actually here at the moment

12:48 PM

we are not here, either

touché

ypercube

there is no here

Mike Fal

This shit got way to existential for me,

@MikeFal if you actually mean excrement, than there are a few others having the same problem

Kin

1:58 PM

Hello All ...

hi

Kin

can anyone check this discussion .. may be I am just misunderstanding or Tim is just being a pain .. dba.stackexchange.com/a/46258/8783

I don't know nearly enough about SQLCMD to have an opinion

2:17 PM

@Kin I'm not quite awake yet, but is that a dupe of dba.stackexchange.com/questions/3727/…

@billinkc Tumbleweed update, eh?

@Kin What could be the underlying problem behind the question? Why might the OP want to use a script variable? If it's just to display the value in the SELECT, that makes no sense, you could use a T-SQL variable for that.

hello heapers

One reason might be that they wanted to parametrise a server name. If you set a script variable to @@servername, you won't be able to use it in the context where an actual server name, but not @@servername, is expected.

@bluefeet Hi!. How's the new job going

2:28 PM

@Lamak it's really good

nice

@Kin That is, you'd be unable to use it in e.g. SELECT * FROM $(source_server_name).dbname.schema.tablename.

Kin

@AndriyM thats true and so I have the OP put an extra variable that will hold the server name

I will ignore that ... and move ahead .. seem to me that Tim has not tried or understood the question

I think I got into the new navigation alpha team

@Kin You mean the @source_server_name variable? But you wouldn't be able to use @source_server_name in my example above – meaning that $(source_server_name) wouldn't work either if you set it to @source_server_name.

2:35 PM

@billinkc on SO?

Yup

You can disable it if you want

then it got weird

facebook.com/Flairtender/posts/…

right, @KrisGruttemeyer?

@bluefeet Nope, I signed up for a reason

@billinkc okie

2:36 PM

Thank though oh most helpful SE employee :D

@billinkc what is this?

Meta MF, do you read it!

@billinkc I try

@swasheck Sorry, this content isn't available right now

Kris Gruttemeyer

@swasheck Indeed it did. More so for my wife, though.

2:37 PM

meta.so. you will never find a more wretched hive of scum and villainy. we must be cautious.

Kris Gruttemeyer

Long night last night

@Kin As Tim has said, the script variable is evaluated by the client. By the time the script is sent to SQL Server, there is no $(source_server_name) in it, it is replaced with @source_server_name. And so the above example would look like SELECT * FROM @source_server_name.dbname.schema.tablename and fail to compile.

@billinkc Sorry, this content isn't available right now

Kris Gruttemeyer

Ahh yes, there we go

sql-server-2008-r2 restore

2:40 PM

ach, a success story

and a not-so-success story:

-1

Q: How to recover a database?

I have a dead database. I looked at the backups but the last backup was made three weeks ago, then the operation was executed with an error and I didn't notice: - (mdf and ldf aren't copied by the conductor. Errors in the file. Using Active File Recovery I have copied the mdf. Then I passe...

another satisfied customer

nice comment

very constructive ;)

another satisfied customer

@bluefeet ... how's the community? properly managed?

Who's Jim?

i need @ConcernedOfTunbridgeWells in here to help interpret the pop culture

2:44 PM

@swasheck ha, considering it's been a week. I'm still learning and will be for a long time

Okay, a quick lookup kind of suggests it's to do with Star Trek.

@AndriyM yes. star trek. "bones" has a bit of a phrase "i'm a doctor not a ..."

Right, hopefully I'll have memorised that by the time of my pop culture exams (should there be any).

@swasheck You rang?

you're better off without detailed knowledge of u.s. pop culture, to be honest

2:49 PM

@swasheck (in the voice of CoTW) knowyourmeme.com/memes/dammit-jim-im-a-doctor-not-a-x

@swasheck I'll keep that in mind too, thanks

(how embarrassing)

@swasheck ??

@swasheck ???

@AndriyM ????

2:53 PM

@billinkc ?????

i mixed my homophones

@dezso ??????

@swasheck homoffones

@swasheck That's ok. It's legal to do that in most states now.

@dezso as you like it

@ConcernedOfTunbridgeWells it makes me all cringey and stuff

2:55 PM

It's a homonym youtube.com/watch?v=U6j5p5f7sto

@swasheck It helps if you avoid watching Fox News and listening to talkback radio.

> In linguistics, a homonym is one of a group of words that share the same spelling and the same pronunciation but have different meanings. This usually happens as a result of the two words having different origins. The state of being a homonym is called homonymy.
A homophone is a word that is pronounced the same as another word but differs in meaning. The words may be spelled the same, such as rose (flower) and rose (past tense of "rise"), or differently, such as carat, caret, and carrot, or to, two and too.

My, aren't you a cunning linguist

ypercube

@swasheck ??

(too late for the party, I know)

a dislocated f

3:08 PM

@Lamak ... way to go, Chile!

@billinkc I see what you did there ...

wait. watching the replays. nvm.

@swasheck ah, thanks

we have to thank Jara, the proctologist

Jara ... that was ... something. what's the mood there on Jara? gamesmanship, or WTF?

3:24 PM

@swasheck kinda of an embarrasing WTF.

But also, kind of an "Uruguay deserve to have that kind of play that they invented done to them"

yeah. it's not uruguay is a clean, innocent team that just happened to be pillaged by the big, bad chileans

@swasheck exactly. So, it's both embarrassing and "meh, they deserve it". They almost kill alexis sanchez yesterday. And afterwards they hit the referee and got no card at all

5:52 PM

There's a developer conference in town this week so we wanted to have fliers for our SQL Saturday available at the community booth. Being team last minute, I didn't have them printed yet but @mmarie agreed to pick them up and take them to the conference since I'm not making it there.

As part of the filling out the form to get them printed, they had a "Special instructions" field. I wrote "give Meagan a high-five for picking these up". Mission accomplished as the high-five was delivered

@billinkc I would've assumed that "special instructions" were for "special" people.....like you

Ouch

Corozon de mi es brokeno

@billinkc at least they didn't print that on the fliers

@billinkc you're improving your spanish I see

@Lamak oui

6:20 PM

@Lamak He's improving his google translate skill sis my guess.

@Zane It's good enough that he seems to be "improving"

This seems a tad bit excessive.

engadget.com/2015/06/25/…

where are all the bollocks gone?

@Zane never too early to overreact

James Lupolt

It's not a good sign when the person handling your case at Microsoft talks about 'the SQLs'.

oh many sql's does your environment have?

Is it MySQL or is it YourSQL?

James Lupolt

6:32 PM

I think the data is in MyExcel

a friend of mine reported an issue with a support script of exasol (exaplus, maybe) to exasol, clearly describing the situation - the answer: what script is it? who wrote it? where is the source code?

^^ quick edit so that I can pretend I have multiple friends

So we just got office 2013 but it requires more ram to run everything and now my shitty work laptop is strapped from ram 100% of the time.

Somehow it's even less reliable than before.

7:12 PM

it's the same story with every release (of nearly everything)

this home notebook started diing as the two browsers evolved (to nothing I really value, but at least a thousand version numbers)

Aaron Bertrand

8:10 PM

All right, so, @bluefeet, it has come to my attention today that aspfaq.com (DO NOT GO THERE) has been gobbled up by some really nasty malware people. Is there anyway to unilaterally remove all links to *.aspfaq.com from all questions and answers? I started modifying them all to use web.archive.org links but quickly realized that could take months.

There are 347 answers on SO with links there according to my quick search (only 13 on dba.se).

@AaronBertrand checking

Aaron Bertrand

I can probably very easily identify them using data explorer

8:25 PM

@AaronBertrand Is the content stored anywhere else? Besides web.archive?

Aaron Bertrand

@bluefeet I don't think so

Scrapers maybe