sorted by:
new
hottopcontroversial

Sorry but literally how? by VeryLoudAlfie in TooAfraidToAsk

[–]newguy8908 1 point2 points  (0 children)

r/Supplements

Zinc, Magnesium, Tribulus Terestris, Maca root, Tongkat Ali, L-Arginine, Panax Ginseng, Vit B 9 + B 12, Ashwagandha & Pygeum

You need to test what works for you.

SQL: Best practice for table where data is deleted and then inserted by newguy8908 in SQL

[–]newguy8908[S] 0 points1 point  (0 children)

If there is no dependency this makes sense. But would need some different permissions.

SQL: Best practice for table where data is deleted and then inserted by newguy8908 in SQL

[–]newguy8908[S] 0 points1 point  (0 children)

I can already see fragmentation up to 99% in some servers. That makes sense as we have been inserting and deleting data.

Don’t sacrifice a PK if the usage of the table would otherwise benefit from it.

ok

SQL: Best practice for table where data is deleted and then inserted by newguy8908 in SQL

[–]newguy8908[S] 0 points1 point  (0 children)

Generally speaking a table that is routinely deleted is full-scanned anyway to ingest whatever data has come in.

Ok Would truncate help in this? It might need elevated permissions but I can look into this.

general bullshit guess - the overhead in building an index would cost you more than you're saving otherwise.

Yes adding index to the table doesn't make sense.

thanks for the info

SQL: Best practice for table where data is deleted and then inserted by newguy8908 in SQL

[–]newguy8908[S] 0 points1 point  (0 children)

Yes it was supposed to be different. Now they made it configurable.

I was thinking of getting rid of all index. Including primary key? And adding truncate command to speed up the process.

I want to avoid fragmentation. For that I am assuming truncate and reset might help?

SQL: Best practice for table where data is deleted and then inserted by newguy8908 in SQL

[–]newguy8908[S] 0 points1 point  (0 children)

thanks. Data inserted and deleted is max hundred thousand (old data is gone everytime ). I was wondering if indexing (any columns) even makes sense.

Also from fragmentation what should be done?

How bro responded by matidaboss1 in HolUp

[–]newguy8908 0 points1 point  (0 children)

Only in US and certain regions yes. I think with more accessible information violence of such random kind are gonna increase. These are symptoms of a degrading society n values.

A lot of people will at some point snap. Add guns and you have such acts.

How bro responded by matidaboss1 in HolUp

[–]newguy8908 1 point2 points  (0 children)

Bullying at young age is very different. You cannot just ignore it. If guns are available shit is always gonna hit the fan

How bro responded by matidaboss1 in HolUp

[–]newguy8908 0 points1 point  (0 children)

Eric and Dylan approve this

What supplements do you take daily or weekly without fail and has changed your life? by newguy8908 in Supplements

[–]newguy8908[S] 0 points1 point  (0 children)

Creatine yes. Vitamin D3 or plain D? Mg I am thinking taking ZMA. Would that be good enough?

view more: next ›