SQL-Bits.com

We give you quick SQL recipes on Twitter and on SQL-Bits dot com. Because SQL matters!

[Federico Razzoli @FedericoRazzol1]

MariaDB and MySQL don't use indexes for regular expressions, even when they theoretically could. But in some cases you can solve the problem with this optimisation, that I call "REGEXP AND LIKE".
https://t.co/R0xSyXbGK1

[Vettabase @vettabase]

What's new in @MariaDB's latest Long-Term Support release? We have selected a list of most interesting features and explained them all for you! Read the new post by our Founder @FedericoRazzol1 covering the recent MariaDB LTS release: https://t.co/TD2NOFFyoa #MariaDB #database

[Vettabase @vettabase]

In #SQL, this can’t use a regular index: WHERE DATE_PART(YEAR, date) = '2021'. This is an equivalent expression that can use a suitable index, if it exists: WHERE date BETWEEN '2021-01-01' AND '2021-12-31'. #database #Vettabase #VettabaseWeeklyTips

[Swiss Oracle User Community @swissOUC]

🗓 Get ready for the first edition of #datacomconf2022!

💬Meet the data infrastructure and platform community on 3 November in #Bern!

[Swiss Oracle User Community @swissOUC]

💬 Be part of this years #OracleBeerBern meets #tvdpdays!

Meet the performance experts for the Q&A session on Wednesday afternoon! ⁉️

Register now! 🖊
https://t.co/Z4ZY6t80FF
#SwissOUC

[Vettabase @vettabase]

Storing filenames, urls or alphanumeric codes in #MariaDB/#MySQL? Consider storing them with #ascii charset and ascii_bin collation. This makes searches faster and physical tables smaller. #database #opensource #DBMS #Vettabase #VettabaseWeeklyTips

[Vettabase @vettabase]

“Don’t use an #RDBMS as a cache” - yet another rule that we shouldn’t follow strictly. #Caching the results of a query in a table means that we can join it to other data, use a stricter WHERE or a different ORDER BY at a low cost. #database #Vettabase #VettabaseWeeklyTips

[Fatih Arslan @fatih]

My friend @ask_dba’s new book is out and released. Check out if you’re interested in MySQL and using it at work.

[Pantea @Pani_trng]

"Data Concurrency and Consistency"

In a single-user database, a user can modify data without concern for other users modifying the same data at the same time. However, in a multiuser database, statements within multiple simultaneous transactions may update the same data 1/2

[SQL-Bits.com @sql_bits]

Do you know how to use GROUP BY to group results by *ranges* of values? #SQL
https://t.co/q7woI3QFFX

[SQL-Bits.com @sql_bits]

We can write very advanced #SQL queries just by nesting GROUP BYs. Check this example & explanation!
https://t.co/PRi6x3vZln

[Vettabase @vettabase]

Do you know what #PostgreSQL autovacuum is, and how to tune it? Check this article from @kwaku_mikey!
https://t.co/9JDd4RssZ7

[Federico Razzoli @FedericoRazzol1]

The idea is amazing, it should seriously reduce resources used for data centres powering and water treatment. These guys are great.
https://t.co/1o1IWQS4XV

[SQL-Bits.com @sql_bits]

Here are some creative uses of the LIKE operator. Maybe you won't use them often or at all, but it's good to know them.
https://t.co/bZKiD0aqSH

[SQL-Bits.com @sql_bits]

How to work with IDENTITY columns in #Db2:
https://t.co/9F6sI9ZfYR

[SQL-Bits.com @sql_bits]

How to copy tables in #MySQL and #MariaDB.
https://t.co/KMmbyztYmx

[SQL-Bits.com @sql_bits]

#SQLServer: Understanding the differences between CHECKSUM(), CHECKSUM_BINARY(), HASHBYTES()
https://t.co/dyYt102RxX

[SQL-Bits.com @sql_bits]

#SQLServer: Learn how to count the occurrences if a substring in a string
https://t.co/s97crtT7CE

[SQL-Bits.com @sql_bits]

Learn how to find values above the average in #SQL.
https://t.co/pPKByvHeKZ

[MariaDB Foundation @mariadb_org]

https://t.co/FpKZxAc2NJ: FOSDEM22 MariaDB devroom talks https://t.co/xR7ex3zn70