おすすめツイート
SQL Performance Explained — A Book For Developers It focuses on what developers need to know. Just 200 pages…yet covering all major databases. sql-performance-explained.com
Another look into PostgreSQL CTE materialization and non-idempotent subqueries shayon.dev/post/2025/124/…
For this WHERE, what index to create? WHERE subsidiary_id = 42 AND last_name LIKE '%INA%' Is (subsidiary_id) enough or should it be (subsidiary_id, last_name)? use-the-index-luke.com/sql/clustering…
My favorite change is that MariaDB got an improved "WHERE year(...) = ?" rewriting. use-the-index-luke.com/blog/2024-12/d… In picture: the green check mark used to be yellow, with the "a" footnote: Unconditionally rewritten—even if only a matching function-based index exists
Survey on performance optimization for database systems (2023) researchgate.net/publication/36…
#DoYouKnow? If your index is getting too big in size, you can index only a subset of the values using Partial Indexes. Read more here - use-the-index-luke.com/sql/where-clau… #Databases #SQL
Improved RCSI Ghost Cleanup in SQL Server 2022 — by Paul White As always, Paul provides deep insight into the SQL Server implementation. sql.kiwi/2024/12/improv…
sql.kiwi
Improved RCSI Ghost Cleanup in SQL Server 2022
An example of poor update performance under RCSI as compared with locking read committed. Details of an improvement in SQL Server 2022 that can help avoid the worst effects.
At about this time of the day, I run my open-to-everyone trainings. The last training this year is "SQL Performance Explained", for which I have one spot left. It starts Dec 2nd and is delivered in seven 2-hour long in-person sessions each Mon/Wed/Fri. winand.at/sql-training/o…
SQL Best Practices Every Java Engineer Must Know foojay.io/today/sql-best… [IMHO: not just Java Engineers]
TIL about Index-Only Scan for databases ✨ Also I'm in love with this website use-the-index-luke.com/sql/clustering…
In the meanwhile enjoy a discount for SQL Performance Explained if you don't have it yet: 15YrsAnniversary Only valid when purchasing directly from me (not on Amazon, ...): sql-performance-explained.com (but valid for all languages — see language selection at the top).
Learn once, benefit forever. These SQL courses take experienced developers a leap forward. Starting on September 10th! winand.at/en/newsletter/…
The WITH clause is useful to write readable SQL. modern-sql.com/use-case/liter…
There is currently some fuzz about the performance of subqueries vs with clause. Here is my take on it: modern-sql.com/feature/with/p…
United States トレンド
- 1. Good Monday 35.5K posts
- 2. Harada 7,717 posts
- 3. #OrmxHausNowhereBKK 224K posts
- 4. ORM HAUS NOWHERE GOP 218K posts
- 5. Tekken 18.7K posts
- 6. Chiefs 116K posts
- 7. Orm Kornnaphat 18.1K posts
- 8. Mahomes 42K posts
- 9. #JungkookxRollingStone 28.7K posts
- 10. #MondayMotivation 6,506 posts
- 11. #ITWelcomeToDerry 75.3K posts
- 12. Kelce 25.6K posts
- 13. Texans 49.7K posts
- 14. #ออมกรณ์นภัส 113K posts
- 15. FELIX NAVER SPOTIFY CAMPAIGN 9,991 posts
- 16. rUSD N/A
- 17. Proverbs 5,063 posts
- 18. Cambodia 51.2K posts
- 19. andy reid 7,125 posts
- 20. Victory Monday N/A
おすすめツイート
-
MySQL
@MySQL -
Microsoft SQL Server
@SQLServer -
Modern SQL
@ModernSQL -
SQL Daily
@sqldaily -
MySQL Community Team
@mysql_community -
Steve Stedman
@SqlEmt -
OpenJS Foundation
@openjsf -
Planet PostgreSQL
@planetpostgres -
SQLServerGeeks.com
@SQLServerGeeks -
Oracle AI Database
@OracleDatabase -
PHP Classes of Objects and Global Code Scripts
@phpclasses -
Grant Fritchey
@GFritchey -
Markus Winand
@MarkusWinand -
Apache NetBeans
@netbeans -
Kevin Kline
@kekline
Something went wrong.
Something went wrong.