The Heap™ – Consultancy ©®

Thomas Ward

12:14 AM

wow that was painful, sorta. Had to convert a small database to SQL Server from PostgreSQL

the evil was the routines >.<

Evan Carroll

12:35 AM

I ASKED A QUESTION.

Answer it for glory and greatness dba.stackexchange.com/q/158323/2639

Thomas Ward

SQL Server Pros: Is there any easy way to get a dump of a database's schema and functions to a SQL file from within SQL Server Management Studio? (I know how to do this with postgresql, but I need the schema from a MSSQL database)

Paul White

3:18 AM

@ThomasWard Right Click on the database in Object Explorer, hit Tasks ... Generate Scripts

deostroll

4:51 AM

Can anyone tell me the significance of the the yellow or red key icons...I know they are meant to signify primary keys...but anything more than that...? dev.mysql.com/doc/employee/en/images/employees-schema.png

Andriy M

6:49 AM

@deostroll I think the red ones are foreign keys. (Although they might also be taking part in primary keys, not sure.)

Good morning everyone (including @dezso)

Mikael Eriksson

7:08 AM

Good (best to be specific about this I guess) morning.

hot2use

Good Morning to you all.

ypercubeᵀᴹ

7:31 AM

morning

ypercubeᵀᴹ

7:44 AM

Item review in Amazon

>
the colours these give off is like no other i have ever seen. they get an exact likeness of digital images and the colours mix superbly!

... for a black ink cartridge

Andriy M

7:58 AM

@ypercubeᵀᴹ Maybe that's a new generation of black cartridges, they give you all the colours necessary.

Tom V

8:26 AM

@ypercubeᵀᴹ Seems to fit many cartridges google.be/…

hot2use

8:41 AM

black != colour

dezso

@AndriyM I hope this will end at some point

Tom V

@hot2use Depends if you look at it from a "Colour as light" perspective or a "Colour as pigment" perspective

I'll escort myself out :)

hot2use

@dezso don't bet on it

@TomV Yes. true.

colormatters.com/color-and-design/are-black-and-white-colors

dezso

a NULL morning to everyone

hot2use

Have you set CONCAT_NULL_YIELDS_NULL to FALSE? Otherwise your output does not exist.

Tom V

8:45 AM

A pedantic morning it seems

dezso

@hot2use ERROR: unrecognized configuration parameter "concat_null_yields_null"

hot2use

@dezso Is that PostgreSQL?

Hmme

dezso

@hot2use what else?

hot2use

@dezso should have been SET CONCAT_NULL_YIELDS_NULL OFF [SQLSERVER]

@TomV TGIF

James Anderson

Would you guys agree with my comment on my answer here? dba.stackexchange.com/questions/158339/removing-tde-from-server/…

Tom V

8:58 AM

@hot2use Last Friday before vacation

James Anderson

I think rebuilding fragmented indexes before a shrink will cause the shrink to reduce the size of the DB further than it would have done.

Andriy M

Does TDE stand for Transparent Data Encryption in that question?

dezso

@AndriyM Truly Dreadful Enemy

Andriy M

@dezso I'm thinking of editing in the expansion. Could you please substantiate yours with a link? :)

@dezso Or can I use the link to your message in my edit?

dezso

@AndriyM absolutely, but only with ™©®

Andriy M

9:03 AM

@dezso Good idea. That will make it look authoritative enough.

dezso

I seem to be unable to find an acronym faker that was out there about 15 years ago, and would produce some scifi-thriller themed solutions

like Transgalactic Dimension Enhancer

James Anderson

@AndriyM I hope so

Andriy M

9:31 AM

@JamesAnderson Only just noticed you've added the tde tag.

I still think expanding the abbreviation in the text won't hurt.

Tom V

I hate Excel

dezso

9:56 AM

@TomV which language?

James Anderson

10:06 AM

@AndriyM Ah just seen that you have done that. Yep I agree

hot2use

@JamesAnderson upvoted comment

Andy K

10:24 AM

Hi

question (quick or not that quick)

Would raid1 be good to do a backup of a Postgres database, whilst the db is still running?

From what I've read, the answer would be yes but I still ask, in case

James Anderson

10:38 AM

@hot2use Thanks

dezso

@AndyK how does the RAID level and the backup relate to each other?

you want to store a backup (is it a physical backup or a DB dump?) on RAID1?

Andy K

@dezso it is a physical backup of the whole drive where is also the postgressql, which is on raid1. The sys eng wants to backup that drive

and restore it when needed

I have doubts about it, that's why I'm asking

ypercubeᵀᴹ

11:46 AM

@AndyK I don't think you have to stop the database to take a back up in Oracle.

Neither in SQL Server or Postgres.

dezso

12:00 PM

@AndyK so it is not a PostgreSQL backup (<- only one s there!), but something external? then no idea. When handling corruption, the first thing one has to do is to take a low level backup, and then the DB must not run

not sure if there are tools that can take a consistent backup of the filesystem or even lower, without knowing anything about the state of the DB engine itself

furthermore, it is advisable to keep the DB on its own disk, and use its own tools for backups

Tom V

12:20 PM

0

Q: cannot connect with sql

I have problem with SQL server I can not connect with SQL server Error message:

"Please don't post error messages as screenshots" > "OK, will photos do then?"

6

hot2use

@TomV :-| duh

ypercubeᵀᴹ

@TomV I'm sure they'll post a video if requested

hot2use

@ypercubeᵀᴹ Couldn't they do a live stream? That would be even better.

hot2use

12:42 PM

@TomV you know when you down vote and stackexchange pops up a message asking you to "Please consider leaving a comment if you think....." Well I did consider leaving a comment, but I didn't think it would change anything. Is that bad for my karma?

ypercubeᵀᴹ

@hot2use Do you get a pop-up each time you downvote? I can't remember getting any.

Ah, it could be a rep thing. I get it at superuser

Andriy M

Perhaps it pops up on some sites and not others.

Or depends on the rep, indeed.

ypercubeᵀᴹ

18

Q: Base the "Please consider adding a comment ..." popup on maximum SE reputation

When downvoting an answer on Super User, I got the "Please consider adding a comment if you think this post can be improved." pop-up. Apparently, the message is based on my Super User reputation (215) and not on my maximum Stack Exchange reputation (3166 on Stack Overflow). Since the user inter...

feature-request comments voting popups

Yes, apparently, 2K rep is needed to get rid of the bad-karma annoyances

and here: meta.stackexchange.com/questions/135/…

Lamak

@ypercubeᵀᴹ weird that it never was implemented

Andy K

1:00 PM

@dezso many thanks for your precious advices

ypercubeᵀᴹ

@Lamak never ?

hot2use

@ypercubeᵀᴹ then bad karma it is then.

ypercubeᵀᴹ

@hot2use you are half way through, at least at dba.se!

Andy K

@Lamak I almost did not recognize you...

ypercubeᵀᴹ

@Lamak with "never" were you referring to the suggestion the popup to be based on the whole network rep?

hot2use

1:08 PM

@ypercubeᵀᴹ It's hard work, but I'm enjoying it.

ypercubeᵀᴹ

stackoverflow.blog/2016/12/…

Lamak

@ypercubeᵀᴹ yup, that

@AndyK who are you?

;-)

Andy K

lol @Lamak

ypercubeᵀᴹ

@AndyK Lamak was upgraded to version 2.0. Apparently some contacts were lost in the process ;)

Andy K

ha ha @ypercubeᵀᴹ

I need to add this room

Lamak

1:26 PM

@ypercubeᵀᴹ is it 2.0 already?

ypercubeᵀᴹ

Oh, the introspections module is broken, too. We might have to roll back the upgrade.

2

Andriy M

@Lamak Must be, given that the logo has changed.

Lamak

I see

dezso

@Lamak I don't

Lamak

you might have some unrelated problems then

dezso

1:55 PM

@AndyK I think your question need a new try - if I understand you correctly, it's not 'My sys admin wants to backup the postgres database that sits on a raid1 disk', but 'My sys admin wants to backup the raid1 disk on which a Postgres database is sitting'

Tom V

@hot2use I was considering flagging it, but I don't know the habits on SuperUser so I left it alone

ypercubeᵀᴹ

2:10 PM

@dezso My sys admin thinks that backing up the raid1 disk is adequate as a Postgres backup.

dezso

@ypercubeᵀᴹ that's a better fit for area51.stackexchange.com/proposals/66048/health

Tom V

2:26 PM

1

A: SSAS Dimensions Hierarchy causes deployment errors

I've often found errors reported from SSAS indicating a duplicate key value in the dimension. When I've reviewed the source data, the duplicates aren't found. While I can't shed light on why this error is popping up in the dimension, I can offer a solution that bypasses the error and allows the...

ON ERROR RESUME NEXT

Andy K

2:58 PM

@dezso it is that

thanks for the wording

done @dezso

@ypercubeᵀᴹ sounds interesting. would you mind asking your sysadmin to put an answer on my question by any chance, please? dba.stackexchange.com/questions/158352/…

ypercubeᵀᴹ

3:14 PM

@AndyK I meant that to be in quotes (what your sys admin thinks). Not an actual statement from me.

Andy K

yes

Thanks @ypercubeᵀᴹ

Thomas Ward

3:42 PM

@PaulWhite Thanks, I'm still getting used to how SSMS is laid out for tasks like that. Easy in PostgreSQL, just load up pg_dump and dump everything. Not as easy to find such functions in SSMS.

(I'm a PostgreSQL guy, not an MSSQL guy by nature...)

dezso

@ThomasWard so you are doing unnatural things right now?

Thomas Ward

@dezso well

kinda.

Andy K

@ThomasWard nothing is unnatural or natural

Thomas Ward

my listserv implementation is in use with heavy modifications with a company I work with. their DB system is MSSQL

Andy K

if it was the case, I would have seen my 3 legs cat riding a bike for a long time

Andriy M

3:54 PM

@dezso Naturally, given the fact that thing is not a proper database

Andy K

lol

Thomas Ward

so i've had to port everything to MSSQL so I can have all my functions for the statistics table in my listserv implementation available for "easy import" into their database backend

this is one of the few reasons I keep an MSSQL server lying around

Andy K

there is a dump with mssql

if I'm not mistaken

Thomas Ward

@AndyK yes, there is, but I don't know how to get to it, and don't like Windows CLI

so, SSMS question :P

Andy K

@ThomasWard put something like cder

and you will have the best of both world

in term of cli

wait

I give you the link

cmder.net

Thomas Ward

3:57 PM

well I already have the script so... :P

I feel weird, though, installing MSSQL inside of LInux... the preview build helps a little for testing things, and to have a non-production MSSQL environment where I can build these things, but... blurgh.

hot2use

Hope you all have a fantastic weekend. Enjoy and see you soon.

Andy K

4:12 PM

see you @hot2use

bye folks

dezso

tschüß

Tom V

4:41 PM

@ThomasWard Welcome to the dark side, unfortunately the thing about us having cookies wasn't real

Thomas Ward

@TomV heh.

How fortunate most of my functions I have to port over are not difficult, they just need put into MSSQL flavor instead of postgres

swasheck

@AndyK love this tool

MDCCL

@AndriyM Does Rextester require to have a registered account to post code samples like the one included in your following answer:

5

A: Get names of games that have the highest number of guilds

One obvious solution is to get all the counts, sort them in the descending order and retrieve just the topmost row: SELECT gName, COUNT(Name) AS GuildCount FROM Guild GROUP BY gName ORDER BY GuildCount DESC LIMIT 0, 1 ; That would work only in cases where only one game can have the...

ypercubeᵀᴹ

@MDCCL I think no.

MDCCL

@ypercubeᵀᴹ I've noticed that tool is getting popular here in DBA.SE. I'm gonna inspect how it works

ypercubeᵀᴹ

4:54 PM

The Oracle site/tester requires login I think

Jul 1 at 19:07, by ypercubeᵀᴹ

Oct 27 '15 at 15:37, by Phil

Ok, https://livesql.oracle.com/ is amazing. Oracle's own superpowered sqlfiddle

MDCCL

The vendors of the other major platforms should definitely supply tools like that

swasheck

@MDCCL not sure which vendor would do it for postgresql

MDCCL

5:11 PM

@swasheck (when applies) :)

swasheck

:)

soooo ... small thing. i'm trying to decide which i prefer

if () {
}

or

if()
{
}

jcolebrand

Indent style

In computer programming, an indent style is a convention governing the indentation of blocks of code to convey the program's structure. This article largely addresses the free-form languages, such as C programming language and its descendants, but can be (and frequently is) applied to most other programming languages (especially those in the curly bracket family), where whitespace is otherwise insignificant. Indent style is just one aspect of programming style. Indentation is not a requirement of most programming languages, where it is used as secondary notation. Rather, programmers indent to better...

swasheck

i'll keep you posted

jcolebrand

So, I prefer the first one and I'll tell you why

It's easier to tell where segments begin and end

(when you're used to reading it that way anyways)

It's less vertical line space

swasheck

i see your point

jcolebrand

5:15 PM

It's how the original C lang was written

swasheck

i've always done the Allman (<<--- TIL) style

jcolebrand

If you write C-like code and javascript, it's helpful to remember that this breaks javascript because of this example:

function example() {
  return
  {
    a : 1
  }
}

ASI bites you in the ass there

swasheck

fascinating

i'm writing powershell

jcolebrand

Consistency is the key

I prefer OTBS but that's just me

Other people follow the microsoft spec of using Allman style

MDCCL

@swasheck I prefer the second option, but think the first one is more popular

jcolebrand

5:23 PM

Most people writing in corporate codebases write using the standard put forth by Sun and Microsoft which was that style, I believe. I can't recall about Sun, but I think that was the case. Definitely with Microsoft's recommendations.

If that's how you write code at work, that turns into how you write code at home too

Because again, consistency is the key

I realize I'm doing a bit of the ole mansplaining, so my apologies for that, but I thought if there was a discussion on brace styles it would help people be informed why they make the decisions they do

swasheck

@jcolebrand i take everything you say with a grain of salt soooooo ... there's that

jcolebrand

HA!

Now if I could get everyone to do the same thing

I'm glad Seth understands me people, listen to your new king :p

swasheck

thinking of changing my avatar to Set

jcolebrand

As in the Egyptian god?

Set (deity)

Set /sɛt/ or Seth (/sɛθ/; also spelled Setesh, Sutekh, Setekh, or Suty) is a god of the desert, storms, disorder, violence and foreigners in ancient Egyptian religion. In Ancient Greek, the god's name is given as Sēth (Σήθ). Set is not, however, a god to be ignored or avoided; he has a positive role where he is employed by Ra on his solar boat to repel the serpent of Chaos Apep. Set had a vital role as a reconciled combatant. He was lord of the red (desert) land where he was the balance to Horus' role as lord of the black (soil) land. In Egyptian mythology, Set is portrayed as the usurper who killed...

ypercubeᵀᴹ

@swasheck Seth sounds nicer

swasheck

5:36 PM

@jcolebrand chaos

@ypercubeᵀᴹ 'cause of greek inclinations

ypercubeᵀᴹ

The English pronunciations of Egyptian names sound very funny to me.

I'm sure the Greek might sound funny to you as well

swasheck

diacritics are so hard, though

ypercubeᵀᴹ

I'll allow the Set though. Rather appropriate for a SQL guy.

swasheck

that'd be so meta

billinkc

Python has the best brace style

5

Mercy, where are my manners?

In proper Heap fashion, one of the classic challenges with the various styles is their optionality. Which can lead to subtle logic errors such as

if (condition)
    do a
do b

As the code base evolves, we of course realize we needed to do a and do a'

And the hurried/harried developer makes a quick fix and never tests so we get the resulting code

if (condition)
    do a
    do a'
do b

Appears correct but clearly is not in that a' will always be executed. Many organizations and some languages now remove the option for omitting braces for single statement clauses

Python took the simpler approach by denoting blocks with literal whitespace. If it is left aligned, it's within the same block

end JEAGL;

Forrest

5:59 PM

I'm dealing with a strange dmv bug[?] right now, and I don't know if I can turn it into a proper question. Should I do my best and post it, or run it by chat first?

billinkc

synopsis? (and I assume you've checked your assumption vs BOL - that's bitten me before)

Forrest

Synopsis (and I have searched BOL and several pages of google results): dm_exec_procedure_stats is increasing the execution count of a stored procedure whenever an unrelated trigger in a separate database fires.

ypercubeᵀᴹ

This Duane Lawrence has given some good answers if I remember well, but I can't understand what's his point in this one.

Sorry but how is this related to the question? You can't save the result of LAG and LEAD in a variable, not even if your name is Brent ;) — ypercubeᵀᴹ 3 mins ago

The example is wrong, too. getdate() will be evaluated once.

Evan Carroll

6:28 PM

How many times will it take him to get the answer right, stackoverflow.com/a/41175241/124486

=P

ypercubeᵀᴹ

6:48 PM

@EvanCarroll A lot.

Evan Carroll

hehheh

ypercubeᵀᴹ

Not bad an answer (yours I mean) but I'm not sure you answered what it was asked.

Evan Carroll

Neither am I, as in the case where name != john?

ypercubeᵀᴹ

Replace one of the 37:45 with 37:41. What do you get?

Your answer will return both 41 and 45. When I read the question, I assumed that they want only the 41.

But the question is not clear at that point.

billinkc

7:15 PM

I love @remus

> Nonetheless sooner or later they have to troubleshoot an issue and then is when many of you find my blog and my articles.

rusanu.com/2008/08/03/understanding-queue-monitors

ypercubeᵀᴹ

You are so full of stars today

2

billinkc

Pity I'm blowing my star wad prior to the hat invasion

Evan Carroll

8:26 PM

@ypercubeᵀᴹ that's a good point =(

I'm going to fix that. But, let me awe at the fact that I'm in the top 7% on unix.se without like ever using it.

I've scripted this in like 3 language, I have to think there is a utility to do it

0

Q: Diffing two directories recursively based on checksums?

I'm trying to find what files don't exist by a checksum of their content. I have two directories /foo and /bar Given both of these directories representing arbitrary states on the system, I want to find all files in root bar that do not exist in root foo (recursively). A dictionary of bar...

directory directory-structure diff recursive checksum

@ypercubeᵀᴹ I've updated with a caveat referencing exactly what you said, but it sounds like i did what he wanted. "Note : the intervals are based on the first occurence of the timestamp, and not general intervals as discussed here"

Where the crap did the syntax for CTE's come from?

That's so weird.

I've never seen something so ugly in any language.

ypercubeᵀᴹ

8:42 PM

@EvanCarroll Yeah. That question linked in the "here" looks like a 3rd, different problem. It's so bad when they post unclear questions for complicated problems.

Evan Carroll

Agreed totally.

And then when they don't come back to give you the satisfaction that you read through the bad question and did it right.... there is a special place in jannah for them.

Transcript for

The Heap™ – Consultancy ©®