The Heap™ – Consultancy ©® - 2017-08-02 (page 1 of 2)

Joe would probably make it custard (he likes cooking)

9:06 AM

@PaulWhite That would be for the database cook book!

Custard Index

snort

@gbn, are you around?

I'll be near, for an hour or two.

I am here

one for us stackoverflow.com/questions/45456225/…

I'll stop at Zurich at noon.

plane? train? or automobile?

9:10 AM

plane. London to Athens

Are you on the plane now?

Landing at noon puts you over Paris right now

McNets

@ypercubeᵀᴹ hollidays?

@gbn No, I guess noon wasn't very accurate. Take off at 12, so around 15 at Zurich

(12 in UK, 15 in Swiss time ;)

@McNets yes

how long do you have in zurich?

1 hour and a half I think

McNets

9:17 AM

@ypercubeᵀᴹ enjoy it!

Heathrow is in the news. Total cock up it seems by British Airways

And Gatwick

@gbn Wasn't that a month or two ago?

Another one telegraph.co.uk/business/2017/08/02/… and other newspapers

@gbn ah reading now.

It's good that I don't fly with BA today! It's pretty quite at terminal 2.

This is me "It's good that I don't fly with BA". One ariline I do not like

9:27 AM

I hope there is not much delay in Zurich, due to the security measures.

Not normally. It's quite efficient, even for non-Schengen arrivals. And the airport is quite compact anyway. I transferred va Paris CDG a month or 2 ago: I walked for ever, then waited for some time at passport control

@gbn I read that the increased measures has caused issues. But mostly in touristic areas, Spain, Portugal, etc.

I had another pass through Zurich, 2 years ago. It was efficient, yes. I had less than an hour I think between flights.

@ypercubeᵀᴹ I saw that too. And gave thanks I don't live in the UK. We've been there twice in 4 years and that's too much

Q: Stored Procedure count and list the occurrence using like from another table

9:58 AM

Old cross-post:

1

Actually this is my first procedure apart from basic "Hello world" procedure. I have two tables like this: cars users ------------------------- --------------------------- | car | description | | name | car_owned | ------------------------- -...

1

Q: MySQL count and list the occurrence using like from another table

I have two tables like this: cars users ------------------------- --------------------------- | car | description | | name | car_owned | ------------------------- --------------------------- | BMW | Good Choice | | abcd | BMW, nano ...

mysql procedure sql-like

What can/should we do?

@AndriyM No upvoted answers, one is a copy of the SO one, closed and deleted.

@PaulWhite Thanks.

I can go to lunch now

Yes you may.

10:56 AM

:)

A: Delete almost 10 million rows each day

12:03 PM

I think this edit should be rolled back:

1

I think you should delete with this query : WHILE 1 = 1 BEGIN DELETE TOP (10000) FROM tableName WHERE condition; IF @@rowcount < 10000 BREAK; END You wrote : SET cnt = ROW_COUNT(); . Do you mean @@rowcount? Thanks for answering, Ali Bagheri Shakib I guess both while block looks ...

AKS added a comment to the answer.

rolled back

@dezso Cheers

even though the person answering approved the edit

An unintended consequence of a new functionality.

@hot2use Thanks. Please raise a custom mod flag next time as well.

Q: SQL Server - how can a select be so long

why

why was this the first question i clicked on today

0

I was wondering if it is normal to have a simple query like below taking 6-7 secondes on a table with 'only' 300 000 rows. I'm working on SQL server 2014 and a sgbd taking so much time to return "not that much" data is quite surprising to me. SELECT [Id] ,[b] ,[c] ,[d] ,[e] ,[f] ,[g]...

sql-server optimization select

@ypercubeᵀᴹ would a constraint on a binary column have delusions of gender?

2

12:16 PM

@sp_BlitzErik No doubt the nvarchar(max) column contains a nested database

"what's the nvarchar(max) for?"

"guids stored in xml"

Or more boringly he's running SSMS on an old Nokia

No worries on Tom Tom's Nokia

@sp_BlitzErik Actually it's a rather clever new form of xml he's calling Jason.

i should stop calling mine fred, then.

What kind of monster names their columns a,b,c,d...

12:19 PM

the anonymonster

Heh

@PaulWhite will do. Was on the verge of doing that.

@sp_BlitzErik Any fule knows it should be unsigned tinyint

ISO/IEC 5218

ISO/IEC 5218 Information technology — Codes for the representation of human sexes is an international standard that defines a representation of human sexes through a language-neutral single-digit code. It can be used in information systems such as database applications. The four codes specified in ISO/IEC 5218 are: 0 = not known, 1 = male, 2 = female, 9 = not applicable. The standard specifies that its use may be referred to by the designator "SEX". The standard explicitly states that no significance is to be placed on the encoding of male as 1 and female as 2; the encoding merely reflects existing...

@hot2use Cheers. Others can take care of the immediate issue but it's good to make the mods aware of things like this, and flags don't get missed like chat messages can.

@gbn is chanelling Joe Celko today it seems

@PaulWhite "Cool Joke"

12:21 PM

Gender (BIGINT) NULL

D:

Some of us need bigint for our gender

2

Deary me

depends on the unit of measure, probably ;)

"Hi Erik,

Could not able to post throwing some JavaScript error which blocking failing to post."

@sp_BlitzErik Ångströms?

@PaulWhite Smoots!

12:23 PM

@sp_BlitzErik A linguine and a bit theregister.co.uk/2007/08/24/vulture_central_standards

Smoot

The smoot is a nonstandard, humorous unit of length created as part of an MIT fraternity prank. It is named after Oliver R. Smoot, a fraternity pledge to Lambda Chi Alpha, who in October 1958 lay down repeatedly on the Harvard Bridge (between Boston and Cambridge, Massachusetts) so that his fraternity brothers could use his height to measure the length of the bridge. == Unit description == One smoot is equal to Oliver Smoot's height at the time of the prank, 5 feet 7 inches (1.70 m). The bridge's length was measured to be 364.4 smoots (2,035 ft; 620.1 m) plus or minus one ear, with the "plus...

So glad context arrived on that one

@gbn how many bobcats per second is that?

er...

> Vulture Central Weights and Measures Soviet

Curious

Is the word "Soviet" used jokingly or seriously here?

12:37 PM

if you have to ask, it's probably a joke

@AndriyM Where?

sheep velocity article

Oh the register one.

@sp_BlitzErik My immediate thought was it was a joke. On the other hand, I'm not up to speed with changes in vocabulary. I'd think "council" would work fine there as it has done many times before. But maybe someone liked the word ("Soviet") so much they started a trend and it caught up or something.

English is a borrowing language. Native English speakers (especially Brits) abroad like me will mix languages in one sentence.
So the word "soviet" is more amusing to us than "council", especially because of the historic meaning

I would never say "I'm off to Zurich train station". It would always be "I'm off to the Hauptbahnof"

12:49 PM

same

So, a jocular translation of "council", perhaps.

Genau

In itself an example, it's more natural to say "Genau" instead of "exactly"

ConcernedOfTunbridgeWells

@gbn "Genau" and "ganz genau" perhaps?

@sp_BlitzErik There are folks who wouldn't view that as binary.

ConcernedOfTunbridgeWells

1:01 PM

@hot2use Not heard "ganz genau" in the wild. But of course the Swiss have "exactly" and "completely exact". Nothing is inexact

2

@PaulWhite When I was at university we had a lecturer called Tad Takaoka who used to write C code with variable names like that. He was a mathematician by background and did algorithms research - he claimed that he found it easier to read. We used to refer to his code as TadC.

Q: ODBC trace that has been activated but how can I deactivate it?

@hot2use janz jenau around here

Andy K

1:16 PM

afternoon

probably laughable but if you have any idea

0

My colleague has activated an odbc trace to troubleshoot the issue we currently have. But alas he has created another issue e.g the tracing is activated each time we are running the msaccess program even though we have deactivated the log in odbc. We are using an msaccessprogram that works as a...

windows-7 postgresql odbc

Philᵀᴹ

1:30 PM

Someone just phoned the Helpdesk to complain their desk phone wasn't working at all. They phoned from their desk phone. /facepalm

@Philᵀᴹ Have you been promoted from DBA?

Philᵀᴹ

@gbn They sit opposite me. Poor chaps :(

billinkc

I would expect sitting opposite you would be a lamentable location, regardless of job role

@billinkc a good {part-of-day} to you, too

@sp_BlitzErik good one!

billinkc

1:38 PM

Miss you all

Your aim never was very good

for those interested in minimal logging: blogs.msdn.microsoft.com/sql_server_team/…

TF 692 is the one that I knew about

Tom V

@billinkc You're the one who walked out on us

The Heap™ is quite like a tower defense game - @billinkfc appears, throws something at someone, then the others start throwing things at him

4

Max Vernon

@PaulWhite - that was an excellent answer you wrote on the fallibility of the hash match row distinct. Never in a million years would I have thought about a spill.

Lamak

1:46 PM

@dezso sounds about right

but he deserves for going MIA

Philᵀᴹ

2:00 PM

Bill's in KFC in KC?

2:47 PM

@MaxVernon thanks

What did you think of the edit?

swasheck

Congratulations to @aaronbertrand

Got it

breakingburgh.com/…

@JoeObbish Was fine thank you

Glad to hear that. I will aim to edit more often.

> Any time you see a post that needs improvement and are inclined to suggest an edit, you are welcome to do so.

2:57 PM

yeah, but, you know how it is

Did anyone happen to read that MS blog post about minimal logging? My interpretation is that they're saying that TF 610 has no effect in SQL Server 2016.

@JoeObbish I know. It's an ongoing battle.

@JoeObbish They pretty much state that explicitly, yes.