The Heap™ – Consultancy ©®

5:49 AM

Good morning

Andriy M

6:27 AM

Morning

Andy K

7:22 AM

morning and evening

7:48 AM

Morning

McNets

8:14 AM

Morning

Colin 't Hart

Morning

Are you affiliated with “BigSQL”? The official APT repository is the preferred method of installation on DEB-based distributions, so your answer is A) wrong on that point, and B) makes it sound like you’re affiliated with them. — Colin 't Hart 2 mins ago

There were 2 upvotes on the question too...

4 hours later…

12:08 PM

@Taryn what's the deal with the posts table on data explorer? brentozar.com/pastetheplan/?id=H1zicIo77

well at least they're index seeks

or something

I must be missing something

i keep thinking the same thing

jadarnel27

12:28 PM

What is PostsWithDeleted? Is dbo.Posts a view or something?

Joe Obbish

Posts does look like a view to me

don't see how you can explain this filter otherwise: Seek Keys[1]: Prefix: [StackOverflow].[dbo].[PostsWithDeleted].DeletionDate = Scalar Operator(NULL)

jadarnel27

@JoeObbish Ah, nice. I didn't see that.

Taryn

1:03 PM

@sp_BlitzErik Posts is a view of PostsWithDeleted - meta.stackexchange.com/a/2678/164200

@Taryn fancy

thanks

@Taryn Ah OK I see, and the deleted posts aren't in the dump

Makes sense

Taryn

@TomV correct no deleted posts are included

1:52 PM

Can you run the SSMS query debugger on SQLSERVER for linux now ?

I've read a thread on microsoft tech website that says you can't but it dates from january so I have my hopes up it could work

2:08 PM

Anyone from UK here

@Mathematics they all had to leave. none of them had chat licenses. quite sad.

ypercubeᵀᴹ

@sp_BlitzErik Yeah. Only the non-UK citizens are left ;)

@sp_BlitzErik oh, I got few, I think I can pass them on

@Mathematics can I have one?

it would be nice to be able to chat again

What can you do in the UK that doesn't require a license

2:14 PM

do you have a permit for that question?

@Mathematics I'm from the UK btw

@JackDouglas here you go, **** ** ***** *, please don't pass it to anyone else or I'll be in trouble

wow did the UK government just packet-censor the license number in flight ?

no it's fine I can see it because it was intended for me

if you post your own password only you will see it the rest of us will see **** :P

bletchley lives

2:17 PM

@sp_BlitzErik everything we say in chat will need to be from a drop-down list of approved sentences soon

@A_V you need a license to view passwords you didn't asked for ;)

@A_V well done

@JackDouglas Validated your question on a 12c installation and everything was kept. I'll be writing up a summary for the REDUNDANCY 2 part. The other bit might take longer.

Even after restoring twice all backup files were kept.

INCARNATION# RESETLOGS_CHANGE# RESETLOGS_TIME      PRIOR_INCARNATION# STATUS       LEVEL PATH
------------ ----------------- ------------------- ------------------ ------- ---------- --------------------
           1                 1 2017-03-08 15:57:31                  0 PARENT           1  -> 1
           2           1490582 2018-07-16 09:27:03                  1 PARENT           2  -> 1 -> 2
           3           1701490 2018-07-17 16:05:13                  2 ORPHAN           3  -> 1 -> 2 -> 3

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
no obsolete backups found

what is this spam

2:24 PM

@hot2use thanks — I reckon it's a 9i bug/deficiency then

@sp_BlitzErik It's for the RMAN nerds.

@JackDouglas You're welcome.

@JackDouglas Could be a bug, yes.

Q: Array-syntax vs pointer-syntax and code generation?

@JackDouglas I am thinking about a new job and LinkedIn isn't helping

Evan Carroll

O'Reilly editors..

I already stopped buying their books, pretty soon they won't be worth reading.

In the book, "Understanding and Using C Pointers" by Richard Reese it says on page 85, The code generated by vector[i] is different from the code generated by *(vector+i) . The notation vector[i] generates machine code that starts at location vector , moves i positions from this location, and...

2:43 PM

@Mathematics in the UK?

LinkedIn is probably going to be more help than the Heap given the number of employers who advertise in here

Q: How to handle ~1k inserts per second

@JackDouglas In 12c the backups for the orphaned incarnations become obsolete after the second backup.

3 hours later…

ypercubeᵀᴹ

6:10 PM

-1

Assuming one has about 1k requests per second that require an insert. Now, there are a lot of answers to this on the internet... but they're technically wrong in this specific context. Yes, pretty much any RDBMS can handle 1k inserts per second on standard hardware but IF AND ONLY IF you drop A...

performance transaction acid

wellington

Hi. I have built a database schema but now I'm completely lost as to how I add a large data set to the database...

The data for the database is a line of products that include an image, descriptions and other attributes. This is a link to my diagram/post to help clarify the database structure: dba.stackexchange.com/questions/212433/…

Greatly appreciate any help you guys can offer

ypercubeᵀᴹ

@wellington Where/how are the data stored now? As text/binary files?

wellington

6:27 PM

I have a shoddy excel sheet

I have been inputting the data on one sheet just so I can make sense of it all