The Heap™ – Consultancy ©®

7:23 AM

Morning

John K. N.

8:10 AM

Morning

4 hours later…

John K. N.

11:47 AM

@EvanCarroll now at -21

3 hours later…

2:36 PM

Good morning. Any clue why SSIS won't execute a follow up task from a failed component?

Trying to change the max errors in every place I can

It's not in the mood

Probably not a bones day

nbcnews.com/pop-culture/pop-culture-news/…

@McNets It is grumpy all the time

3:04 PM

Component or task? Got a screenshot of what your trying to do?

ypercubeᵀᴹ

3:31 PM

This question should better be split into two: one for the underlying issue (why inserts are slow and what to do, should I convert to heap or add/remove indexes, etc) and another for the strictly limited one (how to convert a 200GB clustered table into a heap). Otherwise, we are mixing comments and (probably) answers soon. — ypercubeᵀᴹ 24 mins ago

the most frightening thing in that question is OP's name ;)

1 hour later…

4:44 PM

It is a no bones day twitter.com/NoodlesBonesDay/status/1450458718211039233

Was at a lecture this afternoon - guy talked about a CONSTRAINT to be that the employee's salary couldn't be greater than their manager's! I said that as far as I knew that this was table level assertion and hadn't been implemented by any of the major vendors - he said it was implemented by some systems. Which one(s)? Firebird allows SQL in CHECK constraints (see here),

but it's easy to circumvent (example conceived on train - so maybe mistakes...). I asked on the FB lists and was told that just because I could do it, didn't mean that I should (by a heavy hitter). So, my question - is there any system that is in commercial use - by more than, say, 5 companies that implements table-level asserts/constraints?

5:02 PM

@billinkc Task. Gimme a second, stuck in meetings.

@Vérace I mean, they all do either through triggers or scalar functions

Alternately, you certainly could restrict CRUD operations to stored procedures and check the logic there

Evan Carroll

@JohnK.N. Can't help that. =(

I hope this network dies in a fire.

@bbaird Sorry - should have been more explicit - the guy specifically talked about CHECK constraints - I know all of this can be done in SP logic - that's not the issue. It's whether there are any systems which have table level asserts/constraints via simple DDL?

@Vérace Sybase and SQL Server allow CHECK constraints to use scalar functions, which is essentially the same thing.

DB2 and Oracle may allow something similar, but I've not developed on those

Evan Carroll

I find it funny though. While I can find a question to be duplicate others can refuse that conclusion, and an answer that I believe will answer both questions can't be posted to both questions. How do they even expect someone that can't draw a distinction to pick or to know how to further tailor their answer to the question.

5:20 PM

You can always make the trigger throw a similar error text to check constraints. :P

6:04 PM

CHECK constraints have a number of issues where they won't work on empty tables or on DELETE, but in any case, I think a better way to enforce that kind of thing (it's not actually much of a sound business rule in the first place, though) really would be to have an INSTEAD OF trigger. Because it's symmetric, you can't reduce a manager's salary below the highest employee either.

And then you also need to look to enforcing it on organizational changes, and handle the cases where some people might temporarily not have a boss.

Even as a declarative statement about the table overall, it's likely to need to be temporarily be broken if you didn't also have some kind of deferred constraint.

2 hours later…

7:56 PM

There are some scenarios where your manager deserve a lower salary.

8:19 PM

@McNets Some?

@bbaird hmmmm, I'm trying to be polite...

@bbaird Would you care to demonstrate with a small fiddle

@McNets I had a project manager tell me once that I didn't have to understand his schema, I just had to programme it! :-)

there is a meme here that says something like:
That's my dog, his name is Project manager, don't be afraid, he does nothing.

8:52 PM

@Vérace dbfiddle.uk/…

I bill at 500 USD an hour, minimum 2 hours

Good man

Would also want a check constraint to make sure there isn't a manager loop, but that's not what we're trying to demonstrate

If the subtask is a Execute Package Task and that package generates an error, it's going to percolate up to the caller. At least, I never could find a way to quash it.

@billinkc It's more than when "Stage BIDW Account" fails it isn't triggering "Set APCAS Status Error"

@bbaird Or 1 bottle of Middlleton's? ;)

8:56 PM

I've set the maximum number of errors to 2 - I'll test tomorrow to see if that does the trick

@Vérace I accept payment in aged whiskeys, so that'll do

Oh, that's because the two precedent constraints leading into Set APCAS Status Error is an AND operation so Stage BIDW and the offscreen task would both have to fail

Double click the connector and change the bottom most thing to OR. Can't recall what the text is

Red line will go to a red dashed line

DUH

@billinkc omg how did I miss that

Thanks Bill

No problem, it's a fairly common stumbling block so don't be too down on yourself. I mean, you should feel some shame but it should pass in a few hours

I owe you some cheese curds

Or Surly beer - something adequately minnesotan

Q: How is StackOverflow Talent different from a job board?

9:19 PM

Do the rest of you savages, aka non-'Muricans, know the glory of cheese curds? If it squeaks, it's good

Cheese curd

Cheese curds are the moist pieces of curdled milk either eaten alone as a snack, or used in prepared dishes. These are chiefly found in Quebec, in the dish poutine (made of French fries topped with cheese curds and gravy), and in the northeastern, midwestern, mountain, and Pacific Northwestern United States, especially in Wisconsin and Minnesota. Curds are sometimes referred to as "squeaky cheese". == Production == Cheese curds are made from fresh pasteurized milk in the process of creating cheese when bacterial culture and rennet are added to clot the milk. After the milk clots it is then cut...

Hannah Vernon

10:01 PM

@billinkc one word, Poutine.

1 hour later…

Evan Carroll

11:09 PM

not sure if you saw this but SO is moving out of job posting..

-13

The text on the marketing page is confusing, Our Company Awareness solution helps you build a strong candidate pipeline, tell an ongoing employer branding story, and stay top of mind and engaged with candidates. Yet, they say, Job Postings/Slots and Profile Search were open to everyone, not re...

support stack-overflow-talent

11:26 PM

Weird

I got my current job through Stack Overflow and I think my employer is pretty happy.