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

a day 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

9 months ago

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

SQL Performance Tips retweeted
_backslashzero Profile Picture

Shreyansh Gupta @_backslashzero

9 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

9 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

10 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

10 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

11 months 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

12 months 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

a year ago

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

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

a year 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

Baylor
11,9 B posts
#UFCParis
38,2 B posts
Iowa
32,7 B posts
Julian Sayin
2.024 posts
Austin Simmons
Karen
250 B posts
Ole Miss
4.867 posts
San Jose State
4.776 posts
Duke
25,9 B posts
Austin Peay
1.787 posts
Carnell Tate
Syracuse
6.768 posts
Mason Jones
1.853 posts
UConn
5.424 posts
Grambling
3.357 posts
Mizzou
5.716 posts
Boo Carter
Ty Bryant
Caleb Downs
Oregon
34,7 B posts

You might like

The world's most popular open source database
MySQL
@MySQL
226K 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
327K Followers
Blog entries from members of the PostgreSQL community
Planet PostgreSQL
@planetpostgres
41K 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
Follow PHPClassesEarly for early insights about upcoming site features. Free ready to use contributed PHP class scripts, book reviews, jobs, specialist forums
PHP Classes of Object...
@phpclasses
44K 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