Cesar Amaya

[Programmer Humor @PR0GRAMMERHUM0R]

breakTheViciousCircle

[Cesar Amaya @Csr_32]

@TonyStroonck @InvictosSomos Y uno lo mira porque es una semifinal y espera que por lo menos así hagan algo decente

[Cesar Amaya @Csr_32]

@code @VisualStudio could you add this feature too?

[Cesar Amaya @Csr_32]

@TonyStroonck @InvictosSomos Jajaja 😂
Igualito
Que partido tan aburrido

[Visual Studio Code @code]

A quick @code tip you may not know: you can select bracket and string content with a simple double-click 🖱️

[Massimo @Rainmaker1973]

In India, a woman tricked police and civic teams into cleaning an open drain for 3 hours by falsely claiming someone had fallen into it.

[Anton Martyniuk @AntonMartyniuk]

𝗦𝗲𝗰𝗿𝗲𝘁𝘀 𝘁𝗼 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗶𝗻𝗴 𝗦𝗤𝗟 𝗤𝘂𝗲𝗿𝗶𝗲𝘀

Here are 20 proven techniques I use regularly to optimize SQL queries:

✅ Use Indexes Wisely:
Index critical columns used in WHERE, JOIN, ORDER BY, and GROUP BY clauses.

✅ Avoid SELECT *:
Fetch only the columns you need to minimize data transfer and processing time.

✅ Implement Pagination Properly:
Use OFFSET and FETCH NEXT or seek-method pagination for efficient result paging.

✅ Limit Rows Early:
Apply filters early to reduce the dataset size as quickly as possible.

✅ Avoid Functions in WHERE:
Functions on columns prevent index usage; rewrite conditions to use raw columns.

✅ Reduce JOIN Complexity:
Minimize the number of joins and avoid redundant joins wherever possible.

✅ Choose Correct JOIN Types:
Use INNER JOIN, LEFT JOIN, or EXISTS appropriately to avoid unnecessary data processing.

✅ Use Proper Data Types:
Match column data types exactly in JOIN and WHERE clauses to utilize indexes effectively.

✅ Query Only What Changed:
Implement incremental data processing rather than repeatedly querying entire tables.

✅ Batch Operations:
Group inserts, updates, or deletes to reduce transaction overhead.

✅ Eliminate Redundant Subqueries:
Use joins or common table expressions (CTEs) instead of repetitive subqueries.

✅ Use EXISTS Instead of IN:
The EXISTS clause often performs better than IN with large datasets.

✅ Normalize Wisely:
Balance normalization with denormalization for performance-critical queries.

✅ Use Materialized Views:
Pre-calculate complex aggregations and queries to speed up read operations.

✅ Analyze Execution Plans:
Regularly check query execution plans to spot and optimize costly operations.

✅ Avoid Wildcards at Start:
LIKE conditions with leading wildcards (%abc) prevent efficient indexing.

✅ Keep Transactions Short:
Minimize transaction duration to reduce locking and contention.

✅ Update Statistics Regularly:
Keep database statistics current to ensure accurate query planning by the DB engine.

✅ Use Query Hints Sparingly:
Only use query hints after thorough testing and when necessary for specific optimizations.

✅ Monitor and Tune Continuously:
Regularly monitor query performance and proactively tune slow queries.

Optimizing SQL queries is part art, part science — but it always pays off.

How do you optimize your SQL queries? Let's discuss 👇

📌 Save this post for future reference!

—

♻️ Repost to help others optimize their SQL queries

➕ Follow me ( @AntonMartyniuk ) to improve your .NET and Database Skills

[Massimo @Rainmaker1973]

The Armadillo Lizard bites its tail in a unique defensive posture, this posture makes it more difficult for predators to swallow, and it protects their belly.

[Abdulkadir | Cybersecurity @cyber_razz]

Apt

[Massimo @Rainmaker1973]

The NATO phonetic alphabet is the most widely used radiotelephone spelling alphabet.

Its use ensures clarity in transmission of critical information, commonly used in military and aviation communications.

Do you know all the letters?

[Cesar Amaya @Csr_32]

@JoseJua36380113 @TrungTPhan Jajaja 😂

[Massimo @Rainmaker1973]

An exercise to develop both hemispheres of the brain

https://t.co/d63K2glHSd

[.NET @dotnet]

We are increasing the length of support offered for .NET Standard Term Support (STS) releases from 18 months to 24 months. This change is effective starting with .NET 9, which means .NET 9 will now reach end of support (cont) https://t.co/5a9rMfGT7k

[Cesar Amaya @Csr_32]

@Mohd_Saif_2002 @ZorinOS @linuxtoday It will, I have a 2011 Sony Vaio and it works fine with zorin 17. I have an issue with my wifi card but it is happening with another distros too. So, your 2015 laptop will work fine with zorin

[Cesar Amaya @Csr_32]

Minúsculas*

[Cesar Amaya @Csr_32]

@BancoRepublica Buenas tardes señores.

Tengo una duda con respecto a las llaves de Bre-B. La plataforma va a distinguir mayúsculas de minúsculas en las llaves alfanuméricas?

Pregunto porque un banco me generó una llave en mayúsculas y otro banco me la generó en mayúsculas.

[Làzaro @lazaro45ive]

I spent 30 days creating these 20 seconds

[non aesthetic things @PicturesFoIder]

Two dudes in 2003, unaware they were making a legendary song