Picture

SQL Performance Tips @SQLPerfTips

Tips to get best SQL performance. Covering all major SQL databases. https://t.co/pPX9UrXm8p is my book. SQL-Performance-Explained.com/l/ Vienna, Austria Joined April 2011
  • Tweets
    5K
  • Followers
    54K
  • Following
    2
  • Likes
    269
SQL Performance Tips retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

4 weeks ago

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

SQL Performance Tips retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

10 months ago

Survey on performance optimization for database systems (2023) researchgate.net/publication/36…

SQL Performance Tips retweeted
_backslashzero Profile Picture

Shreyansh Gupta @_backslashzero

10 months ago

#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

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

10 months ago

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 Performance Tips retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

11 months ago

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…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

11 months ago

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…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

a year ago

SQL Best Practices Every Java Engineer Must Know foojay.io/today/sql-best… [IMHO: not just Java Engineers]

SQL Performance Tips retweeted
AmelieBenoit33 Profile Picture

Amélie Benoit 🦋 @AmelieBenoit33

a year ago

TIL about Index-Only Scan for databases ✨ Also I'm in love with this website use-the-index-luke.com/sql/clustering…

SQL Performance Tips retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

a year ago

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).

SQL Performance Tips retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

a year ago

Learn once, benefit forever. These SQL courses take experienced developers a leap forward. Starting on September 10th! winand.at/en/newsletter/…

SQL Performance Tips retweeted
ModernSQL Profile Picture

Modern SQL @ModernSQL

2 years ago

The WITH clause is useful to write readable SQL. modern-sql.com/use-case/liter…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

2 years ago

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…

SQL Performance Tips retweeted
kotovr Profile Picture

Roman Kotov @kotovr

2 years ago

Have finished reading the "SQL performance explained" book from @MarkusWinand (creator of the use-the-index-luke.com). Have already known about indexes and B-trees, but the book helped to understand how they affect SQL operations under the hood. Highly recommend!

SQL Performance Tips retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

2 years ago

Just announced new training dates. There are still seats left in my next performance training in April. The remaining courses take place in fall. winand.at/sql-training/o…

Trends for United States

Good Tuesday
26,9 B posts
Pete Hegseth
45,1 B posts
Nicki
278 B posts
Wikipedia
53,9 B posts
#FELIXxLVSS26
146 B posts
Latto
31,3 B posts
Quantico
17,7 B posts
#tuesdayvibe
1.222 posts
Schumer
283 B posts
#TuesdayMotivaton
St. Jerome
1.263 posts
Patton
2.298 posts
#Postseason
6.103 posts
LISA PARIS FASHION WEEK
462 B posts
Watching Giverep
#Wordle1564
Medvedev
10,2 B posts
Generals
39,3 B posts
Medicaid
52,7 B posts
Zendaya
28,5 B posts

You might like

The world's most popular open source database
MySQL
@MySQL
227K Followers
Unleash the power of your data—on-premises, in the cloud, or at the edge—and reveal insights to transform your business. #AzureSQL and #SQLServer news & more.
Microsoft SQL Server
@SQLServer
261K Followers
Resources for #Developer, #DBA, #BusinessIntelligence, and #Data Professionals. #SQL #Database #AI #AzureSQL #AWS #Cloud #Python #SSIS #Performance #PowerBI
MSSQLTips - Free Dail...
@mssqltips
21K Followers
Daily Oracle SQL tips from the Oracle Developer Advocates for SQL
SQL Daily
@sqldaily
26K Followers
This is a group for MySQL developers/DBAs to expand their expertise, share ideas, and help develop better applications
MySQL Community Team
@mysql_community
16K Followers
SQL Server DBA, Owner/Founder at Stedman Solutions, LLC., Entrepreneur, Instructor, and Geek. Get your free SQL Joins poster here: https://t.co/ZEnsX3l1kp
Steve Stedman
@SqlEmt
11K Followers
A home for those who love JavaScript.
OpenJS Foundation
@openjsf
326K Followers
Blog entries from members of the PostgreSQL community
Planet PostgreSQL
@planetpostgres
42K Followers
SQL Community led by SQL Server obsessives. We share knowledge around SQL, Azure & related technologies through our blogs, webcasts & in-person events.
SQLServerGeeks.com
@SQLServerGeeks
4K Followers
Available on-prem or in the cloud, #OracleDatabase enables you to simplify relational #database environments and reduce management workloads.
Oracle Database
@OracleDatabase
188K Followers
Grant Fritchey is a database geek, a Microsoft Data Platform MVP and an AWS Community Builder. He works for Red Gate Software as a DevOps Advocate. Call: KC1KCE
Grant Fritchey
@GFritchey
15K Followers
SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of https://t.co/6oKhq87B43 and https://t.co/RrIy2AY7Tl.
Markus Winand
@MarkusWinand
9K Followers
Apache's one and only free & open source development environment, tooling platform, and application framework.
Apache NetBeans
@netbeans
61K Followers
Data and Analytics expert, author, and speaker. 'SQL in a Nutshell' & many more. Tweets and opinions are my own.
Kevin Kline
@kekline
11K Followers
Open Source Databases Run Better with Percona. Our expertise, software, services, and 24x7 support empower orgs to scale, optimize, and innovate w/o limits.
Percona
@Percona
16K Followers