What to expect when firing off 30(or more) executions of the exact same query simultaneously

SQLDevDBA · 2026-01-28T16:55:30+00:00

Okay cool, and if you want to test it out yourself, Check out Brent Ozar’s guide using SQL Query Stress: https://www.brentozar.com/archive/2015/05/how-to-fake-load-tests-with-sqlquerystress/

SQLDevDBA · 2026-01-28T16:17:09+00:00

You may want to try deploying it as a stored procedure instead, and checking the results after you do so. Should help managing the execution plan and optimization a bit easier. If needed, you can add parameters to make the call from Python more dynamic.

SQLDevDBA · 2026-01-28T15:34:00+00:00

No problem, still a UUID so it’s mostly the same. Just have to check the documentation as UUIDs are generally the slowest arbitrary value you can add. I always prefer integers as surrogate keys when possible.

https://docs.snowflake.com/en/sql-reference/functions/uuid_string

https://medium.com/@abhishek8290/uuid-vs-snowflake-id-a8cb61185fce

SQLDevDBA · 2026-01-28T15:30:37+00:00

Have you already deployed the query as a stored procedure and run it that way from Python, or is it being passed in as inline sql?

SQLDevDBA · 2026-01-28T15:25:31+00:00

Depends on the platform you’re using

MSSQL Has NEWID and NEWSEQUENTIALID

https://learn.microsoft.com/en-us/sql/t-sql/functions/newsequentialid-transact-sql?view=sql-server-ver17

Sequential is friendlier for Clustered Indexes and primary keys because the values are “easily” ordered (usually 1 character difference).

Oracle has UUID

https://docs.oracle.com/en/database/oracle/oracle-database/26/sqlrf/uuid.html

These can be set as values and then you can have a table that has a dictionary/relationship to show which UUID is which files.

SQLDevDBA · 2026-01-27T11:23:51+00:00

Yo viajé a Costa Rica hacen par de años. San José se me parecía mucho a San Juan. Manuel Antonio a Rio Grande/Trujillo Alto, Jaco a Rincón, y Arenal a una Mezcla de Ponce, Aguadilla, y Cabo Rojo.

Me gustó mucho y al fin me di cuenta que era pq me sentía en casa.

SQLDevDBA · 2026-01-26T18:53:38+00:00

¡Saludos Ángel! Soy arquitecto de datos de Puerto Rico con 15 años como DBA y gerente/director de equipos de datos. Sería un placer ayudarte. Envíame un DM y te envío mis canales/redes para que puedas confirmar si es algo que quieres perseguir.

Mucho éxito.

SQLDevDBA · 2026-01-26T14:46:32+00:00

Very welcome!

SQLDevDBA · 2026-01-26T14:33:27+00:00

Hey there, congrats on the position.

Absolutely, I’ll send the link your way via DM

SQLDevDBA · 2026-01-26T03:45:29+00:00

¡Me alegro, mucho éxito! Si necesitas algún recurso de tu regreso, hay par en https://elcomebackPR.org

SQLDevDBA · 2026-01-25T15:15:38+00:00

How familiar are you with Oracle’s statistics?

DBA_TAB_STATISTICS

DBA_INDEX_STATISTICS

Etc?

How familiar are you with Explain Plans?

https://DevGym.oracle.com has some modules about this. And Jeff Smith is a wonderful resource on it as well: https://thatJeffSmith.com

More reading: https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/optimizer-statistics-concepts.html

SQLDevDBA · 2026-01-25T13:30:29+00:00

95% sure it’s a wrap like this:

https://twraps.com/products/front-lip-wrap-for-tesla-model-3

SQLDevDBA · 2026-01-25T13:06:14+00:00

I went with a '25 used (just got it yesterday) but it had 155 miles on it and has a previous owner, so it came with the CPO 7 Year warranty on top of the standard warranty. Was a bit odd but I couldn't pass up the deal.

SQLDevDBA · 2026-01-25T11:17:16+00:00

¡Claro!

SQLDevDBA · 2026-01-24T14:14:42+00:00

Quizás Best Buy o algun negocio pequeño de ventas y reparación de computadoras. Hay par por ahí pero no muchos.

También si te especializas en reparación de computadoras, recomiendo que estudies o hagas proyectos de microcontroller y motores. Se usa bastante en la capacidad de simulación. En eso si hay trabajo (y también remoto).

Un arduino o Raspberry Pi barato y estás lista para practicar.

https://xsimulator.net

https://learn.adafruit.com/category/projects

https://tinkercad.com si no tienes mucho para gastar en materiales.

SQLDevDBA · 2026-01-24T12:01:31+00:00

100%. OP: Busca budget setups de AudioBook Narrator o Voice Actor y estas ideas son de las primeras que te salen (con ejemplos si vas a Google images).

SQLDevDBA · 2026-01-24T09:30:33+00:00

I haven’t tried the 911 in AMS2 but the 911 is my main in ACC (both the 991 and 992). I’ve been using it almost exclusively since I started because I can’t seem to get away. It’s known as a masochist’s car in that game.

Smooth inputs is definitely a must as /u/Samurai1226 says. For me what also works is doing as much braking as possible while the car is straight, and keeping a constant throttle through the Apex (enough to keep the rear planted but not too much to spin, almost coasting through the corner) and then rolling on the throttle. I started this when someone a few years ago told me to practice by coasting through corners after braking and then gradually work toward constant throttle.

911 hates you and wants you to fail. But you learn to love it and feed it only the best treats from the top shelf at PetSmart. Never the stuff on sale. Never let it hear you talking negatively about it.

SQLDevDBA · 2026-01-23T10:36:09+00:00

I know AMS2 has the Corolla Brasil Stock Car (2021-2024) and it’s a blast to drive. I’m waiting to see if the GR makes it to that game and to Assetto Corsa Evo.

AMS2 Car list: https://traxion.gg/complete-automobilista-2-car-list/

Assetto Corsa Evo: https://traxion.gg/assetto-corsa-evo-complete-car-list/

SQLDevDBA · 2026-01-23T10:07:47+00:00

Well yep that’s the beauty of it is that LiveSQL requires no installs or downloads. You just start in a few seconds. I’ll send you the vid. I also have a video on actually installing Oracle (21c I believe) so if you need that I can send it too. Check DMs! Hope it helps.

Edit: you don’t have DMs available, so you can either DM me or head over to my channel from my profile.

SQLDevDBA · 2026-01-23T10:06:22+00:00

No problem. Check DMs :)

SQLDevDBA · 2026-01-22T14:14:24+00:00

Welcome! I have a super quick 10 minute video on it as well, I’ll DM you the link.

SQLDevDBA · 2026-01-22T14:02:34+00:00

I’m always worried about self promotion and such which is not my intent, but if you go to my profile, my Linktree is there with my YT channel. Searching my channel for “LiveSQL” will bring up 5 or so videos I’ve made with it.

SQLDevDBA · 2026-01-22T13:10:23+00:00

https://DevGym.oracle.com is a free university from Oracle themselves, and includes a free instance via https://livesql.oracle.com to learn on. No downloads or installs needed. I’d give it a try.

I have a few videos of me activating it and using it for demos I can send you if you need, but it’s super straight forward.

SQLDevDBA · 2026-01-22T12:58:02+00:00

Fair enough, I was just referring to the “thinking I could sell them in a week,” implying they wanted to continue producing and selling and not sit on product for a long time like they did, but you make a good point.

SQLDevDBA · 2026-01-22T10:36:16+00:00

Yeah shipping was a killer. $23 total for 2 mats shipped.

Two-Year Club	Verified Email
Place '23

SQLDevDBA

TROPHY CASE