The Heap™ – Consultancy ©®

6:46 AM

@jcaron, That's a rude and unhelpful comment. — Cerin 3 hours ago

@Cerin: It does have a point, though. One of the ways to solve your problem might be to revisit your schema so as to split that rather fat (sorry if I'm being rude) table into a few leaner ones. — Andriy M 6 mins ago

Mr.Brownstone

7:01 AM

if anybody is online can you vote to close this as off-topic please? dba.stackexchange.com/questions/128230/…

Paul White

7:34 AM

@Mr.Brownstone Self-deleted.

@TomV Phew! Thank goodness ;)

ypercubeᵀᴹ

8:20 AM

@LucasPossamai: I tested with Postgres 9.5. Maybe VALUES in Postgres 9.2 behaves slightly differently. Sorry if that's the case. The solution is the same either way. Your input has not been reliable in your last couple of questions - there is still a syntax error in your VALUES expression (dangling comma) indicating that you manually altered the query, hence my theory. (And it's '44' in the example, not '40'.) — Erwin Brandstetter 6 hours ago

Another one that managed to get Erwin upset.

Paul White

8:48 AM

@ypercubeᵀᴹ Same person isn't it?

ypercubeᵀᴹ

@PaulWhite No, another (Italian): dba.stackexchange.com/questions/125985/…

> Note: This answer addresses a couple of basic problems, but it's not the final solution. The question was still inconsistent after several requests for clarification, so I stopped processing.

@PaulWhite Could be from the same company ;)

Paul White

@ypercubeᵀᴹ Ah true. Still, it is the same person as the check-constraint saga - which is still a little unclear to me.

ypercubeᵀᴹ

@PaulWhite yeah, the whole thing makes little sense.

It's a wonder that such awful question managed to gather 4-5 good answers.

Paul White

@ypercubeᵀᴹ Indeed. The eventual outcome may (or may not) be useful to the site. My main concern at this point is with the amount of community effort involved in those two questions.

dezso

9:19 AM

@Cerin no, it's not rude (where do you see the rudeness?) and also not unhelpful. This sort of problem that you describe above stems more often than not from bad design - what seemed a good idea at project start might turn (terribly) wrong as the requirements evolve and the data amount grows with time. It might be the first sign saying 'please, redesign me'. — dezso 16 secs ago

@Mr.Brownstone good morning, long time no see

still nuclear?

Phil

9:34 AM

Morning

Had a near-death experience last night. Cooked myself a ribeye steak, chopped a big bit off to scoff, didn't chew it properly & it ended up stuck in my throat backed up with some broccoli. Couldn't breathe for a good minute until I manage to finally cough it up and vomit my dinner out. Longest minute of my life!

Mark Sinkinson

aaaaand VSO is down. Back to bed then...

ypercubeᵀᴹ

@Phil you were alone?

dezso

9:57 AM

Does anyone else see SQLFiddle not finding an otherwise should-be-there table?

sqlfiddle.com/#!15/9eecb7db59d16c80417c72d1e1f4fbf1/5955

bummer, I was to flag a comment from @PaulWhite as obsolete, but it's gone

Paul White

@dezso The updated answer? I was notified so up-voted the improvement and removed my comment.

Mark Sinkinson

@dezso Is the Build Schema section supposed to be blank?

dezso

@MarkSinkinson not at all

I am getting now another error

Mark Sinkinson

@dezso It doesn't even appear for me. All I could see was the one INSERT statement

Paul White

@dezso "ERROR: relation "trigger_test_source" does not exist Position: 17"?

That's what I see (eventually) anyway.

dezso

10:10 AM

yeah

eh, I cannot create a function there if there is a quote inside it

Phil

@ypercubeᵀᴹ Yeah

dezso

@MarkSinkinson the schema would look like here shameless plug

0

A: Execute system commands in postgresql

You can easily do what @a_horse_with_no_name suggests in his comment. But there is also an interesting way to do it, using PL/pgSQL as the function language. This uses a feature of the COPY command, introduced in PostgreSQL 9.3. It can now take a command as target/source, exactly where you'd...

ypercubeᵀᴹ

@dezso Did you create the trigger in the left or the right pane?

dezso

@ypercubeᵀᴹ left

ypercubeᵀᴹ

We see an empty left pane with your link.

dezso

10:18 AM

yeah, I know - is this any different? sqlfiddle.com/#!15/7ae9a/1

ypercubeᵀᴹ

@dezso Yes

> ERROR: unterminated quoted string at or near "' BEGIN COPY trigger_test (command_output) FROM PROGRAM quote_literal($$echo 123$$)" Position: 96

dezso

exactly - this remains the same (or 'unterminated dollar quoted string') with any combination of quoting I can think of

not really a big issue, though

Paul White

@JakeFeasel ^^^ if you're interested.

ConcernedOfTunbridgeWells

12:20 PM

@billinkc Dunno. What do the coloured girls say?

ypercubeᵀᴹ

12:35 PM

Okay, this is great news (as, in MongoDB this is different AFAIK). — Golo Roden 1 min ago

snark comments, anyone?

Andriy M

1:11 PM

@ypercubeᵀᴹ Looks fine to me. The OP has learnt about advantage of RDBMS over NoSQL (MongoDB) in a certain respect and is merely acknowledging that.

Paul White

@GoloRoden not necessarily - if some other transaction commits before the second SELECT starts, the two may see different data. In this case, you might need REPEATABLE READ. — dezso 6 mins ago

@dezso Or a transaction around the selects? Asking because I don't know.

dezso

@PaulWhite wait a minute

Paul White

60...59...58...

dezso

    BEGIN;

                                        BEGIN;

    SELECT * FROM my_favourite_table;
     id
    ────
    (0 rows)

                                        INSERT INTO my_favourite_table VALUES (1);
                                        INSERT 0 1

                                        COMMIT;

    SELECT * FROM my_favourite_table;
     id
    ────
      1

    COMMIT;

the default isolation level is READ COMMITTED

Paul White

@dezso Thanks.

dezso

1:23 PM

@PaulWhite you are very welcome - it's always nice to remind myself, too

Paul White

It seems repeatable read in Postgres is similar to snapshot isolation in SQL Server.

And read committed in Postgres is similar to read committed snapshot isolation.

Royi Namir

INSERT 0 1 ???

(what's that?)

Lamak

1:40 PM

@RoyiNamir you really need to give context to your sudden questions

Tom V

@Lamak Deszo's query I suppose

Royi Namir

sudden ? It's about the last discussion between paul and dezso

Lamak

@TomV ah, didn't read the previous comments, sorry @RoyiNamir

dezso

@RoyiNamir postgresql.org/docs/9.5/static/sql-insert.html#AEN84915

basically a success message

Tom V

Grmbl, I remember a comment on one of my answers I saw on mobile a while back but forgot to include in the answer and I can't seem to find the post now

ah, I should've ranted earlier :)

Paul White

1:45 PM

@RoyiNamir Click the right arrow to link your comment to a previous one for context, or @ping the user in question.

Royi Namir

You right, I should have done that

ypercubeᵀᴹ

@PaulWhite Right.

And maybe slightly better ;)

Paul White

@ypercubeᵀᴹ In the sense of...?

ypercubeᵀᴹ

Can we get phantom reads in SQL Server snapshot isolation?

Paul White

@ypercubeᵀᴹ No

Citing myself as a reference :)

Well sort of citing myself.

Under RCSI you can, but not under SI.

dezso

1:58 PM

@PaulWhite en.wikipedia.org/wiki/… seems to suck

Paul White

@dezso In what respect specifically?

dezso

@PaulWhite at least mixing the concepts from the standard and some very implemetation-dependent details

ypercubeᵀᴹ

@PaulWhite thnx

Paul White

@dezso Oh probably.

Tom V

@PaulWhite I was under the impression RCSI always used row versioning, but you mention 2 separate isolation levels for RCSI

Paul White

2:02 PM

@TomV RCSI and SI are completely different isolation levels. (I have a feeling I'm not parsing your question correctly.)

Mark Sinkinson

We got bitten by RCSI yesterday...thought it worked in a way it didn't

Tom V

I mean the diff between "read committed" and "read committed using row versioning"

Paul White

@TomV Default read committed uses locks.

@MarkSinkinson It's a lot more subtle than is commonly appreciated.

I was reading the Postgres documentation for read committed yesterday where they note some similar concerns. People do tend to assume these things are magic complexity-removal mechanisms.

Tom V

@PaulWhite I just realized I haven't had anything to do with isolation levels for so long (you don't get to pick with AX) that I need to refresh that part of my memory :)

dezso

@PaulWhite also, in PostgreSQL the new row won't turn up in the second query's output

Paul White

2:07 PM

@dezso Same as SI in SQL Server.

@TomV Does AX force uncommitted?

Tom V

@PaulWhite readcommitted

Paul White

@TomV Sorry, forgot the smiley.

Tom V

and in the database properties is_read_committed_snapshot_on=1

while snapshot_isolation_state=1

@PaulWhite so I was under the impression that we where using RCSI with those settings, that's why I got a bit surprised by your comment that we could get phantom reads

Paul White

@TomV I see.

ypercubeᵀᴹ

Where in the MySQL documentation does it say about CREATE RULE? Where does it mention ON UPDATE DO INSTEAD NOTHING syntax? ... — ypercubeᵀᴹ 1 min ago

Why the answer has 1 upvote when it uses Postgres syntax in a mysql question ...?

Mark Sinkinson

2:22 PM

@PaulWhite We had a cross-database transaction, both with is_read_committed_snapshot_on that did a read, then an update in a sub-procedure. Whoever had written it assumed that the data between the read and update statements was consistent.

Paul White

@MarkSinkinson Oh dear. Mind you, the documentation isn't at all clear about (the lack of) consistency guarantees with cross-database transactions.

One might be able to get something working using MSDTC and serializable, but I have no direct experience of that. AFAIK once more than a single database is involved, all bets are off.

Mark Sinkinson

@PaulWhite I think that's the problem. Learned more from your article on sqlperformance than the documentation ever 'clearly' explained

Paul White

@MarkSinkinson Thanks. I should probably write something about the cross-db problems at some stage. I didn't think of it at the time I wrote the series.

Mr.Brownstone

2:42 PM

Good Morning

@dezso hi, how are you? I no longer work in the nuclear industry I moved to the US in October and I now work for a trading company :)

Paul White

@Mr.Brownstone Which country were you in before?

Mr.Brownstone

@PaulWhite I'm originally from the UK

billinkc

2:59 PM

@ConcernedOfTunbridgeWells The usual: doot, dadoot

dezso

3:58 PM

@dezso, He makes a snide judgement about my application knowing only the number of columns and indexes in my largest table. My table stores dozens of descriptors about a customer, and the indexes (many of them partial indexes) are for speeding up very routine queries run by users. It's perhaps un-common, but far from a problem with the schema. — Cerin 16 mins ago

judgement, oh my

Mr.Brownstone

@dezso wow, I guess the guy didn't actually want an answer or an opinion on how he could improve ;)

Tom V

@dezso I don't speak that RDBMS well, but does that make sense? rebuilding indexes because he thinks the indexes are rebuilt in the background and up to date 6 months later

or is he likely hitting a treshold 6 hours later that triggers a stats update?

dezso

@TomV REINDEX won't possibly help, yes

in my latest edit of my latest comment I am asking about the latter

@PaulWhite everyone was nice there, I think

of course, not by @MaxVernon's company's standards

Tom V

yet @PaulWhite is irked

Paul White

@dezso I am looking to nip things in the bud before the niceness drops below the threshold. Phrases like "snide judgement" are not an encouraging sign.

dezso

4:11 PM

@TomV he cannot do much if we add one constructive criticism to one snide judgement in every comment, HA-HA-HA evil laughter slowly fades away

Paul White

sigh :)

Vérace

@PaulWhite Saw your edit and remarks about too many comments. As a past culprit, I will follow this style guide in future.

Paul White

@Vérace Thanks.

Phil

Heh, someone copied me! bbc.co.uk/news/uk-wales-south-east-wales-35490011

Zane

@DanielHutmacher I think you may be misunderstanding how unrelated these training are. I will never ever have any connection with any data that comes in contact in any way with what happens at a branch. I'm about 12 sub companies removed from who this training is for.

dezso

4:22 PM

@Phil only mildly funny

Paul White

7 hours ago, by Phil

Had a near-death experience last night. Cooked myself a ribeye steak, chopped a big bit off to scoff, didn't chew it properly & it ended up stuck in my throat backed up with some broccoli. Couldn't breathe for a good minute until I manage to finally cough it up and vomit my dinner out. Longest minute of my life!

...

@Vérace Regarding this answer, wouldn't it be more accurate to say "statement" rather than "transaction" in the second paragraph?

> This read level will give you a snapshot of what has been committed before your transaction starts. It will allow other transactions to read and write to your table, you just won't be able to see any writes made after the start of your transaction.

^ The paragraph I am referring to.

billinkc

Curse of the deleted question stackoverflow.com/questions/35205879/…

It doesn't work. "Hmm, it should" Nope, double checked. goes off to code up a repro DELETED!!!111ONEONE

Daniel Hutmacher

@Zane Bummer. I use those types of "meetings" to organize my inbox and to-do lists. :)

swasheck

why do you look at me when you hate me

Paul White

4:39 PM

@billinkc So, if you will allow me to paraphrase slightly, you are surprised to encounter a muppet on Stack Overflow?

dezso

1

Q: PostgreSQL not using index during count(*)

I have a COUNT(*) query in PostgreSQL that runs often, and looks like: SELECT COUNT(*) FROM customer WHERE source_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16); This query takes between 30-60 seconds to run and searches millions of records. EXPLAIN ANALYZE shows it's doin...

billinkc

@PaulWhite a muppet?

dezso

should I ask about how many columns that table has?

Paul White

@dezso Ha! No!

muppet

Noun: muppet ‎(plural muppets)

(Britain, Australia, New Zealand, slang, pejorative) An incompetent or foolish person.
Sally is such a muppet, the way she always misses the train....

billinkc

swasheck

4:41 PM

@dezso fields, man, fields

billinkc

@PaulWhite Ah. Surprised no, vexed yes

Although, maybe I'll add this to the blog list

Paul White

@billinkc People suck. I don't know what to tell you about that.

dezso

@swasheck aye, sorry

swasheck

@PaulWhite so do vacuums

billinkc

Perhaps taunting Antipodians will make me feel better

Paul White

4:43 PM

I rather like that one.

@swasheck Especially on Postgres?

dezso

@swasheck and they try to count about three quarters of their records, wondering why an index is not utilized by their unperformant query

2

billinkc

(the above muppet is Lew Zealand and quite possibly the most wonderful of all muppets)

swasheck

@dezso awesome. starring for @AaronBertrand's amusement

Paul White

@billinkc Oh! I had no idea. None.

muppet.wikia.com/wiki/Lew_Zealand

There's a muppet Wiki!

Though what a boomerang has to do with NZ I have no idea. None.

billinkc

Aboriginals and their weapons, do they teach you nothing school?

If I ever needed a non sequitar answer in high school, I'd always respond with "I got the paper towels"

youtube.com/watch?v=J1Uefvn7-r0 youtube.com/watch?v=Xd80BDTRT00

and back to work

ConcernedOfTunbridgeWells

5:18 PM

@billinkc Hey babe, take a walk on the straight side

And the chartered accountants say to do, to do, to do ...

@PaulWhite My boomerang is made in Scotland.

Paul White

@ConcernedOfTunbridgeWells I honestly don't know how to respond to that news.

Andriy M

5:34 PM

How did they end up with 1.5 trillion here?

Oops, too late

swasheck

5:46 PM

@PaulWhite ... flagged this as a comment

0

A: Migrating Sql Cluster Installation To New Drive

Just passing by...I wonder how this went.

Paul White

@AndriyM Advanced mathematics!

@swasheck Processed thank you.

swasheck

@PaulWhite np. you said you love flags

Andriy M

@PaulWhite I shouldn't dare advise them anything then.

swasheck

had my first arak experience last night

Paul White

@AndriyM Possibly emotionally charged mathematics.

TRILLIONS!!1!!!

@swasheck And? Is it like Pernod?

swasheck

5:51 PM

@PaulWhite never tried pernod. the most natural initial comparison for me is ouzo

i'm not a huge fan of licorice ... so there's that ... but overall an interesting experience

Paul White

Me either. I don't particularly enjoy Pernod/Pastis.

swasheck

@PaulWhite i didnt think you drank alcohol ... for some reason. but now i'm confusing you with lexmark

dezso

@swasheck with water or without?

swasheck

@dezso with. naturally i sampled without just to say i did and that was extremely strong. i tried straight ouzo at the greece/turkey border once in a truck stop or something like that, and it nearly flattened me

Paul White

@swasheck No I'm the one that doesn't eat meat. Alcohol ... totally different :)

Lamak

5:57 PM

@PaulWhite you eat alcohol?

that may explain some things

Paul White

@Lamak Oh shush!

swasheck

@PaulWhite wait. you dont drink beer, right?

billinkc

I ferment the blood of animals

Paul White

@swasheck Take that back!!!

dezso

I've just read this: theplayerstribune.com/a-guy-like-me

swasheck

5:58 PM

@PaulWhite i thought i said that i owed you a few beers and you said you dont drink beer

or something. yeesh. i'm losing my mind

Paul White

@swasheck I don't drink at conferences

swasheck

oooooooooooohhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh

dezso

@PaulWhite that's weird, isn't it?

Lamak

@billinkc so, ñachi?

swasheck

i find that the only way i can find Bob Ward comprehensible is to get hammered and walk in

Lamak

5:59 PM

@PaulWhite sounds like a good thing

Paul White

@dezso A bit, I guess. Part of it is that conferences usually feel like work for me.

swasheck

@Lamak it really is a good thing. especially with many of the shenanigans that occur.

billinkc

@Lamak mmmmmm, but no it needs to ferment so I get a buzz

swasheck

@billinkc not sure there're many fermentable sugars in animal blood

Lamak

@billinkc yeah, though you still get quite a buzz

billinkc

6:01 PM

@swasheck Murican animals have diabeetus

4

swasheck

@Lamak @billinkc then inevitable endorphin rush from barbarism?

@Lamak i think that this is why @PaulWhite is a vegetarian (vegan)

Paul White

Not vegan. I'm not masochistic.

Lamak

@swasheck there is a rush, don't think that it's from barbarism, something in the blood

Paul White

Passing thought: should regulars on this site be known as DeBAsers?

I'm imagining a new site logo and t-shirt for that.

Also: Pixies.

swasheck

@PaulWhite sure. why not?

ypercubeᵀᴹ

6:04 PM

@PaulWhite or DeBAshers?

Paul White

debase

Verb: debase ‎(third-person singular simple present debases, present participle debasing, simple past and past participle debased)

(transitive) To lower in character, quality, or value; to degrade.
(transitive, archaic) To lower in position or rank.
(transitive) To lower the value of (a currency) by reducing the amount of valuable metal in the coins.

Seems about right.

Perhaps not then.

ypercubeᵀᴹ

basher

Noun: basher ‎(plural bashers)

One who bashes something, figuratively or literally.
One who engages in gratuitous physical or verbal attacks on a group or type of people.
He was beaten up by a queer-basher.
a Paki-basher
(Britain, slang) A trainspotter. [1]

Paul White

Crikey!

ypercubeᵀᴹ

trainspotter

Noun: trainspotter ‎(plural trainspotters)

a person whose hobby is train spotting
(by extension) an obsessive follower of any minority interest or hobby

swasheck

@dezso what'd you think?

> So when someone from the NHL calls me and says, “Do you think this is something your kids would be proud of?”

nice to see that the NHL has the same hypocritical machinations as the NFL

i'd hoped that it was a bit more pure than the nfl ... but it looks like league execs are the same

ypercubeᵀᴹ

6:21 PM

@swasheck I read the hwole thing and understood, nothing.

Was he sent to a team that plays in lower league?

swasheck

@ypercubeᵀᴹ he was traded to another professional team who then relegated him to a lower league

"transfer" and "relegated"

ypercubeᵀᴹ

@swasheck and all this without him knowing? Does the system works like this is in professional hockey?

swasheck

@ypercubeᵀᴹ most professional sports in the US are like that

ypercubeᵀᴹ

I only know about football (soccer I mean) and I thought it's entirely different

swasheck

theres generally a rumor mill

but not always, especially surrounding some of the less glamorous players

ypercubeᵀᴹ

6:24 PM

Isn't he a good player? WHy would they send him off if he's in an All-star game/title (whetever that is)?

swasheck

lower and mid-tier players get traded without notice

@ypercubeᵀᴹ all-star games are exhibitions where the best play against each other.

though not as hard as they can because they dont want to risk injury

and this guy was voted in by fans (a gimmick to include fans because fans dont like these exhibitions as much anymore because those "stars" selected dont play hard)

and he doesnt possess the typical skill set associated with what you'd want to see at one of these exhibitions

(skating, speed, shooting power/accuracy, stickhandling, etc.)

Paul White

There was hockey on our sports news tonight. Some guy banned for 20 games or something for running down a referee.

Don't recall if it was the US or Canada though.

swasheck

us

billinkc

That'd be a terribly impolite thing for a Canadian to do

swasheck

but it's hockey which is where canadians would consider it a poor match if there was no blood

billinkc

6:35 PM

I thought it was a poor match if someone spilled the syrup or poutine or ketchup potato chips

Mmmmmm I think I'd like a bowl with all of that in there

Zane

6:52 PM

What's up cats and kittens?

My attempt to sound hip appears to have fallen on it's face. Now everyone will know I'm a huge nerd...

Tom V

@PaulWhite I am a chien andalou

Last band I saw live, was a bit nostalgic and disappointing at the same time

I did like their interview before the tour though "why are you touring again?" "We ran out of money sooner than we expected"

dezso

7:10 PM

@ypercubeᵀᴹ teams usually keep him around to have someone who can beat up the opponent

bluefeet

Damn @Zane your head is huge!!

Paul White

@TomV Oh no! Really? That's quite sad. I saw The Pixies live exactly once and they were awesome.

Tom V

@PaulWhite Especially the girl has lost her voice

dezso

what he says here is that the teammates feel safer because there is someone around who can defend them

Paul White

@TomV :(

ypercubeᵀᴹ

7:13 PM

mmarie

Tom V

@PaulWhite It was great fun though, but for other reasons than quality of the performance

Paul White

@TomV Oh good.

Tom V

This guy is righter than me on that question

2

A: What is the fastest way of pulling data from a foreign database

This sounds like a job for the Data Import/Export framework within Ax 2012.

push him to the top :)

Paul White

@TomV He might be right, but he can learn a lot about writing a good answer.

Tom V

yes but it's the better option and I didn't consider it, it doesn't feel right to include that suggestion now after he posted it

billinkc

7:19 PM

Incorporate their suggestion but provide a better explanation on how one uses AX import/export etc

Paul White

@TomV Can you edit his answer to improve it? Or suggest he does so?

dezso

but voting him into the All Stars game was trolling from the fans

(sorry, I am getting interrupted)

Paul White

But yeah billbytheminuteinkc is right about improving your own answer as well.

dezso

@bluefeet is it a rainbow armadillo in the background?

Tom V

Hi, I upvoted your answer as it is a very good option I failed to consider. Could you please elaborate a bit on how this would work? Maybe it's sufficient for the OP and me, but an answer with more detail might convince others why it's helpful and a good solution (possibly better than mine considering the AX version). — Tom V 51 secs ago

dezso

7:22 PM

@swasheck seems like they don't like to play according their own rules

Tom V

@PaulWhite Commented, I'm interested in his arguments, if he doesn't come back and I don't forget I'll edit myself

Paul White

Yep I saw.

Ooo I love spam flags.

billinkc

@PaulWhite I also accept BillFreely since I'm a consultant and all

Paul White

@billinkc Yes that's probably better, what with the conciseness and all.

Max Vernon

@billinkc what about "FrillyBill"?

Kin

7:32 PM

@PaulWhite Nicely done .... You will like this computer science guide (it has a .nz at the end) - csfieldguide.org.nz

Tom V

I cannot get my head around this one

0

Q: SSAS MD dimension joins to same table twice (but processing fails as attribute has 2 names for same ID)

My cube has a product dimension, and each product has an "availability" status attribute. In the database, SellableItemAvailabilityId in DimSellableItemVersion (which contains products) joins to Id in SellableItemAvailability (which contains the statuses). See the image below for the tables used ...

sql-server ssas dimensional-modeling dimension cube

what do you have physically in stock? widgets of a certain size or colour or widgets. Why would you design your model like that

but if I posted that as a comment I may be rude and not helpful :)

Zane

@bluefeet apparently

I've spent more on headphones in the last week than I have in my entire life\

Max Vernon

@swasheck just in case you're interested, I figured out what that login-name maps to. I wrote up a quick blog post about it - sqlserver.science/tools/…

swasheck

Sweet. Just got recruited for a helpdesk support position. Thinking about it.

@MaxVernon nice. And a . Science domain

Max Vernon

@swasheck yah, it was cheap. Apparently it's "well known" for containing loads of scam sites... so be careful ;-)

this one I host myself, so not overly concerned.

Zane

7:52 PM

@swasheck lol me too

Got a call like 10 minutes ago.

@MaxVernon I like this.

Max Vernon

@Zane thanks!

I really must spend more time writing.

Zane

8:04 PM

I feel you there.

Max Vernon

so I just went to this page support.microsoft.com/en-us/kb/2022254 and it shows only this:

sad microsoft

Zane

I've got a few things in my brain that I feel would be worth sharing with the world but just haven't had the time to write them down.

Tom V

@MaxVernon works here

swasheck

@Zane you should take some time to write them down. that tends to solidify concepts for me

Max Vernon

@TomV oh well.

Lamak

8:06 PM

@MaxVernon works for me

Max Vernon

@Lamak hmmmm.

Zane

@swasheck Hard to do if I'm still trying to be a good puppy owner and attempt to maintain a social life.

swasheck

for me too. must be a "no winnipegians allowed" firewall rule

Max Vernon

@Lamak maybe microsoft is trying to tell me they think I'm not a person.

Paul White

@MaxVernon sqlblog.com/blogs/adam_machanic/archive/2010/06/23/…

Max Vernon

8:07 PM

@swasheck must be.

swasheck

@Zane nice priorities

Tom V

@MaxVernon This error has a limited impact and does not prevent a restore operation from succeeding. ...

solution: update to recent CU

Max Vernon

@PaulWhite oh dammit Paul, I knew there was something about that. Thanks for pointing it out!

I shall update my post!

Paul White

I read pre-publish posts for people so often I can't help but proof-read as I go, sorry.

swasheck

i just got a new project!!!

Zane

8:08 PM

@swasheck I like it. I'd like to get reading back on that list but that seems to be more of a summer time thing.

swasheck

downgrade sql server editions.

@Zane reading (for fun)is something i've not done in a while

Paul White

@Kin Very cool.

Zane

@swasheck I bring books to the dog park in the summer.

Max Vernon

@PaulWhite no, no... thanks very much! I appreciate it!

I'm a little reluctant to ask for proof reading since it can be painful.

Zane

8:22 PM

@PaulWhite something new everyday.

Paul White

8:32 PM

0

A: How to remove data redundancy in product table if multiple suppliers are there for same product

We have defined via comments the following significant facts about your scenario: A Product can be offered by zero-one-or-many Suppliers, and a Supplier offers one-to-many Products. A Supplier and a Vendor are one and the same entity type, i.e., they represent the same set of things that have ...

Back later.

Tom V

@PaulWhite The question didn't deserve that answer

Paul White

@TomV That's one of the things I like about @MDCCL's answers.

MDCCL

8:56 PM

@PaulWhite Thanks, I hope it can help some other seekers.

Paul White

@MDCCL I'm sure it will.

Max Vernon

thanks, @PaulWhite for the edit

Paul White

@MaxVernon It would have been accompanied by an up-vote, but see the red box above :)

Max Vernon

@PaulWhite :-)

Paul White

Terrible question though.

4

Q: Add [Is Primary Key Column] field to this query

I made this query, to list tables, its columns, data type and etc: select t.name as 'Table', c.name 'Column', ty.name 'Data_Type', c.max_length as 'Max_Lenght', c.is_nullable as 'Null', c.is_identity as 'Identity' from sys.tables t join sys.columns c on t.o...

sql-server sql sql-server-2014 metadata

Title edited to add the word "field"!

Tempted to edit it to "paddock".

MDCCL

9:05 PM

@PaulWhite That question has some sort of overlap with this one:

1

A: SQL - Many-to-Many relationship with same table and with relationship constraint

If I understand your scenario description correctly, you should have (a) one table to store product data that is independent of sellers and (b) another table to retain product information that comes into play in the context of each of the corresponding sellers. Logical model I have depicted suc...

But I consider that they are not duplicates since on the one hand they want to get rid of bad redundancy and, on the other they want to manage some kind of special not bad redundancy.

Paul White

Agreed.

Right. Really going this time. See you all later.

MDCCL

Cheers.

swasheck

9:27 PM

@MikeFal are you available

?

dezso

@swasheck to 2000, I hope

swasheck

@dezso no. Enterprise -> Standard

it's painful

dezso

too small budget? or just no need for the features?

(or too smart people handling the DBs)

swasheck

not using the features, dont want to get dinged for licensing for features that we're not using. we have ~300 instances and about 50 of them need to be downgraded

dezso

@swasheck nice numbers

Mike Fal

10:02 PM

@swasheck You rang?

swasheck

@MikeFal si

Mike Fal

Una cerveza, por favor

swasheck

was wondering if you had a fairly comprehensive posh module for inventorying and scripting objects in a sql server

i've read nelson's

just wondering if you had one

because i trust you moar

Mike Fal

Not specifically. Are you talking about schema backups?

swasheck

@MikeFal as part of my painful downgrade project, i'd like to script out configs and logins and db users and such

and make sure the downgraded (ent->std) version comes up the same as it went down

Mike Fal

10:21 PM

Oh, I have something for logins

My version of sp_helprevlogin

swasheck

yeah

we have that too

anyway ... just wondering if you had a tool to dump all configs

Mike Fal

Sorry mang

Well....actually.

Bleh. My blog is down

I'll get back to you, I have something that could work for you.

swasheck

@MikeFal no worries. thanks

Shawn Melton

Have you considered looking at the Posh scripts folks use with AG environments to keep server level items fresh between replicas?

swasheck

10:37 PM

@ShawnMelton if i could find one i'd love to consider it

Shawn Melton

You might have to add the config part based on what you need, but believe Kehayias had written something for logins and jobs.

Actually no Kehayias was an add-on to SSMS

@swasheck Something like this: gallery.technet.microsoft.com/scriptcenter/… Which Chrissy LeMaire wrote this function and I trust her code pretty well.

swasheck

@ShawnMelton cool

thanks

i dont know whom to trust

Shawn Melton

She has written some cool stuff

swasheck

that looks pretty cool, but i wont have the other instance up and running yet so i'm going to need to dump all of it instead of copying. thanks

i know ... i'm needy

Transcript for

The Heap™ – Consultancy ©®