The Heap™ – Consultancy ©®

hot2use

6:25 AM

'

ypercubeᵀᴹ

6:55 AM

m

Andriy M

n

McNets

7:23 AM

o

dezso

instead of any greeting, one more argument on the side of my hatred of IoT: theregister.co.uk/2017/03/26/…

Tom V

internet connected dishwashers, how did we get by without them?

McNets

7:41 AM

because till now you call your mum... ;)

abinjacob

hello

McNets

hi

abinjacob

i want to drive a dc motor using pwm from stm board

can i get a help in this

here is the link which i made in electrical section

Tom V

@abinjacob VtC Unclear what you're asking :)

abinjacob

Thank you Tom, i will share the link

Tom V

7:45 AM

Oh it's about electronics

McNets

@abinjacob this chat room is about DBA, I'd suggest another site on SO

Tom V

I'm not sure you're in the right chat room then

abinjacob

0

Q: How to get 6V DC motor running using PWM through STM board

simulate this circuit – Schematic created using CircuitLab I have taken help from previous posts to redraw the circuit, but the 6v motor is not driving at all. However, instead of connecting PD12 pin, if I connect 5v pin from STM board , motor rotates good without PWM. MOSFET Gate is conne...

ok which one

Tom V

Maybe this one?

Electrical Engineering

A place to talk with friends from the EE community about vacuu...

1

abinjacob

thank you Tom again, have a good day

McNets

7:47 AM

May be youll find some room here:

chat.stackexchange.com/…

abinjacob

nobody is there bro, in elecctrical

dezso

@abinjacob they will possibly turn up later

it's also not always very busy here

abinjacob

OHhk. dezso, good day

ypercubeᵀᴹ

8:35 AM

`dba.stackexchange.com/questions/168134/…

Pity that bounties prevent me from voting to close.

hot2use

9:37 AM

@ypercubeᵀᴹ I answered anyway

ypercubeᵀᴹ

9:49 AM

@hot2use good. I think you missed a \ at the first character

Philᵀᴹ

10:56 AM

I actually answered a question on SO! First time for a very long time... stackoverflow.com/questions/43017082/…

Philᵀᴹ

11:20 AM

Soon I will be a MySQL expert, just like @ypercubeᵀᴹ !

ConcernedOfTunbridgeWells

@Philᵀᴹ Oh, how the mighty have fallen. Next stop: PHP.

dezso

@ConcernedOfTunbridgeWells our next WAMP expert?

Philᵀᴹ

@ConcernedOfTunbridgeWells I've been writing PHP on & off for years

I just don't like to boast about it :P

ConcernedOfTunbridgeWells

11:53 AM

@Philᵀᴹ Now, just substitute 'furry porn' for PHP and see how that reads.

McNets

1:28 PM

INSERT INTO Table1
SELECT * FROM Table2 WHERE a=b;
TRUNCATE Table2;

Is it possible that TRUNCATE doesn't delete any row?

SQL-Server

dezso

@McNets sure

if table2 is empty, for example

or a <> b

McNets

@dezso No, rows are still there.

Joe Obbish

@McNets If the TRUNCATE is blocked, sure

perhaps some kind of trigger could prevent the TRUNCATE from working

If the transaction is rolled back then the table won't be empty

McNets

No, I'm importing rows from a temp table, avoiding duplicates. Then I delete the temp table.

Andriy M

@JoeObbish Does TRUNCATE invoke triggers? I forget.

McNets

1:38 PM

pastebin.com/kGkRQbLJ

There are no triggers involved. It is simply a phone calls history table, data comes from and old telephone switchboard, (more than 20 years old). I get this info from an Excel file, first upload data into a temp table, and then insert new records. At end I want to empty temp table. I could use DELETE too.

Joe Obbish

@AndriyM No for DML. I thought so for DDL but that might not be correct. Documentation isn't great on this

ypercubeᵀᴹ

@McNets How do you know that the table is not truncated?

McNets

because after execute the procedure I can select records

but, if I execute it twice, there are no inserts and table becomes truncated.

Tom V

I've never seen truncate leave records behind

Joe Obbish

survival of the fittest

Forrest

1:51 PM

Maybe the TRUNCATE line is unable to obtain the Sch-M lock, and you're not seeing it time out or error?

McNets

I call the SP from a Console app.

Andriy M

If TRUNCATE can be executed in a specific case, it can't leave rows behind. If it appears that it does, I would double-check the names.

McNets

Let me fill temp table and execute it from SSMS

Nice, on SSMS works fine.

Tom V

try{
truncateTable();
}
catch{
//TODO: implement error handling
}

McNets

@TomV Let me try, thanks

@TomV which classes holds this method?

Tom V

2:04 PM

@McNets I was only joking, maybe your console app silently ignores errors

McNets

@TomV Ah, no I've enclosed the whole program on a try - catch block

Yep, DELETE FROM Table2; works fine.

Tom V

TRUNCATE needs different permissions than DELETE

McNets

and no error returned?

Tom V

it shouldn't fail without an error

McNets

Ok, thanks, I'll investigate later, by now I can use DELETE TABLE

hot2use

2:23 PM

@ypercubeᵀᴹ thanks

McNets

It is permissions issue, I've logged on SSMS using the same user.
Msg 1088, Level 16, State 7, Line 4
Cannot find the object "***" because it does not exist or you do not have permissions.

But I should receive a Level 16 error.

Andriy M

Investigate your catch block then.

In the application

JNK

what kind of console application is it?

Lamak

2:44 PM

a ghost appeared!!!

Tom V

It's a dude

McNets

what kind? New project - Console App

C#

What happened?

Lamak

@TomV and apparently, he disappeared again

it was a quick little haunting

Tom V

3:04 PM

@McNets JNK appeared (briefly)

McNets

The icon is still here.

JNK

I am still here

ish!

@McNets just wondering what you're using that didn't escalate errors

or if you don't have a try/catch set up

what class are you calling the STP with?

McNets

@JNK my code is executed inside a try/catch block. But I do not receive this specific error about TRUNCATE TABLE.

JNK

what class are you calling to exec the STP, he asked again? :)

McNets

SqlCommand

JNK

3:16 PM

what method?

error handling is different for query vs non query

McNets

It's a class I use from a long time ago @JNK, it is .ExecuteNonQuery()

JNK

yeah thats weird then

I would expect severity of 16 to hit the catch

now theres not a try/catch in the STP too is there?

McNets

I'll investigate later, I'm sure the error is there and I'm doing something wrong but the boss is waiting for the results...

JNK

ok

I have ahd this happen when someone put a try/catch in the STP but didn't reraise

McNets

This probably the issue.

ypercubeᵀᴹ

3:59 PM

@Lamak see OP's comment: dba.stackexchange.com/questions/167363/…

Lamak

@ypercubeᵀᴹ hi

So, my answer is still valid?

ypercubeᵀᴹ

@Lamak Yes. and you could use balance - ... instead of MIN

Lamak

@ypercubeᵀᴹ I don't think so. I mean, I understand that that's the literal interpretation of op's comment, but I think he's struggling with english. I think he meant that it must be the same value for balace for every row for the same CaseID. I mean, even the sample data is like that

ypercubeᵀᴹ

@Lamak Yes, same balance for same CaseID. That you can use just balance is my conclusion.

Anyway, I'd prefer to use FIRST_VALUE or MIN still. To be defensive, in case the data is not consistent.

Lamak

@ypercubeᵀᴹ ah, yes, your conclusion is right then

@ypercubeᵀᴹ I think that that was my initial thinking

Lamak

4:31 PM

so......reading about the Walking Dead show, I found this:

> However, if you ask McIntosh, she'll tell you that they call themselves "the Heapsters" on set, in reference to living in the heap of trash which is the junkyard seen at the end of Rock in the Road

6

MDCCL

@Wilson My pleasure!

McNets

5:29 PM

I'm looking for a FDA pre-validated (compliant) software (ERP, MES), any advice will be welcome.

Tom V

5:56 PM

@McNets technet.microsoft.com/en-us/library/hh271563.aspx

Which is not a recommendation

I'd probably recommend zero off the shelf ERP systems

4

McNets

I must try either, validate all our own software, developed over 19 years, or buy a new solution and implement it on the next 4-6 month.

Max Vernon

4-6 months is not enough.

itshambles.wordpress.com/2014/05/25/…

Thomas Ward

just to make a point the same thing can be said for migrating older code to newer code - what could have been an easy two week process turned into a grueling 18-week fight with Python to make it work. (Just as a point of comparison, but not worrying about more than RFC compliance of course, since it handled email listservs and such)

(and I had to recode half of it heh)

McNets

@MaxVernon Unfortunately I know.

Philᵀᴹ

@TomV they are all shyte...

Tom V

6:06 PM

@McNets 4-6 months will buy you contract negotiations but not an implementation

McNets

We have made a lot of work, but software validation is still pending, We are ISO certified from long ago.

And now, my CEO, after a week on Cologne, has decided to implement a pre-validated software.

Max Vernon

@McNets make him read that IT Shambles blog-post above

McNets

@MaxVernon I'll try, thanks.

ypercubeᵀᴹ

@McNets he has decided you (and your colleagues) to implement ...

Philᵀᴹ

@McNets what software have you been looking at?

McNets

6:15 PM

@ypercubeᵀᴹ IT deparment, yes. Well, we have 'contracted' external consultants.

From a year ago

@Philᵀᴹ I'm considering MS-Dynamics.

About 250 users.

Forrest

@McNets There are actually multiple Dynamics products. Do you remember which one in particular?

McNets

Navision

SAGE X3

Actuallly we use SAGE Murano for financials and accounts, all the rest has been developed by our department.

I swear you, I'm a bit scared.

Forrest

I support Dynamics Navision (now NAV) myself.

McNets

@Forrest how many users?

Forrest

20-30

McNets

6:31 PM

I'm talking about 250, 30 sales team, 2 online orders portal, mobile software, b2b automotive software, all our production, data adquisiton software, a lot of ms-access, docuware, on.premise and on-line, quality control, exchange, few sql servers, crm, etc

Forrest

In 4-6 months?

McNets

At least the medical plants.

50 %

Tom V

Not sure nav will do 200+ users

@McNets rightfully so

@McNets 6 months won't replace that

McNets

I'm sorry, I don't want to bore you with my problems. But I've received the good news today.

Tom V

And you'll be ripped off by the vendor during contract negotiations if you are in a hurry

McNets

6:43 PM

@TomV I know, there are a lot of 'bad' vendors, no matter if we talk about NAV or SAP.

Well it's time to change my working hours again.

Forrest

I'm working with a 10+ year old version of Navision. I deal with about 30 thousand tables with no foreign key constraints, where aggregate info is maintained by table triggers using nested cursors. I am...not a fan.

hot2use

6:59 PM

Sorry @JackDouglas. I broke sqlfiddle. Or my testing did something unexpected.

dezso

@Lamak plagiarists everywhere

Lamak

@dezso yeah!....I mean, we don't really live in a heap of trash, just sometimes....and some of us might be zombies

Joe Obbish

7:25 PM

@Forrest 25k tables here with no foreign key constraints

No triggers... that I know of

Forrest

@JoeObbish What kind of system do you support?

Joe Obbish

7:40 PM

@Forrest Support is probably the wrong word but SQL Server and Oracle servers for an Electronic Health Records vendor

Forrest

I bet that's an interesting system. I'm not envious of having to handle security for medical records.

Tom V

@Forrest it hasn't improved in recent versions

Max Vernon

@Forrest They have Chuck Norris on retainer.

Forrest

@MaxVernon Lol!

Tom V

His number is listed under ICE in their phones

Max Vernon

7:47 PM

@TomV nice

Joe Obbish

Not my area! Well, some people would say that it's everyone's area...

Unfortunately hospitals can be good targets for ransomware

Have valuable data, don't always have the strongest IT departments, and if software is unavailable it can put people at risk

Max Vernon

But, Chuck Norris puts you at risk.

dezso

@JoeObbish it must be a must in such systems - my first inherited DB was very similar as it sounds

Jack Douglas

@hot2use can't see anything wrong, can you give me a link?

Lamak

@hot2use you mean sqlfiddle or dbfiddle?

Jack Douglas

7:57 PM

my brain has autocorrect turned on

hot2use

@Lamak sqlfiddle

Lamak

@hot2use then @JackDouglas isn't really the person you need

he (and his younger version) made dbfiddle

Tom V

@hot2use you mean you were able to try a query on sqlfiddle again?

hot2use

Ooops

Jack Douglas

also, you probably didn't break it @hot2use

Tom V

8:02 PM

sqlfiddle has been broken for months/years

hot2use

Ah ok

Sorry for the fuss

I'm stepping in a lot of it today.

@JackDouglas Works

Jack Douglas

@hot2use doesn't use your index though: dbfiddle.uk/…

Jack Douglas

8:22 PM

Please, this is a comment more than an answer. — McNets 1 hour ago

@McNets it's really an answer not a comment — perhaps a bad answer but even so: a bad answer can be improved and voted on, a comment can't

2

Tom V

@JackDouglas Voted ;)

Jack Douglas

the heap forgives nothing

4

Max Vernon

8:43 PM

And remembers everything

3

ypercubeᵀᴹ

@TomV I wonder who is trolling the mysql users. 2 upvotes ...

Tom V

@ypercubeᵀᴹ As soon as I see "phpmyadmin" I give up

McNets

9:13 PM

@JackDouglas ok, I'll delete or change my comment.

How can a 63 rep user, have 65 gold badges? stackoverflow.com/users/875317/b-clay-shannon

bluefeet

@McNets they have bountied away most of their rep

McNets

@bluefeet ok, thanks. That's really nice.

billinkc

9:29 PM

Burn it with fire, please

0

Q: If give inupts product name,brand ex:sansumg phone,samsung.Need to get all related ecommers sites(ex:amazon,ebay,flipcart ect...)and product prices?

If give inupts product name,brand ex:sansumg phone,samsung if we give these inputs need to get all ecommers sites(ex:amazon,ebay,flipcart ect...)related and product prices save to table we need get lowest price from these sites using ssis? please suggest me is it possible in ssis?

ssis

Evan Carroll

11:52 PM

@bluefeet I doubt that's the only reason.

@McNets it's likely an account linked with a warehouse of mindless drones in a factory. he's the guy that answers all of their questions without knowing anything about technology.

StackExchange gets gamed by lots of people like that.

All of his answers on are self-answered.

He gave all of his bounties on his own questions

ypercubeᵀᴹ

@EvanCarroll so?

Electrical Engineering

Transcript for

The Heap™ – Consultancy ©®