.:\dGh/:.<p>Found the antichrist on myself.</p><p><a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PHP</span></a> <a href="https://mastodon.social/tags/Laravel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Laravel</span></a> <a href="https://mastodon.social/tags/EloquentORM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>EloquentORM</span></a> <a href="https://mastodon.social/tags/ORM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ORM</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/DB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.social/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.social/tags/Code" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Code</span></a> <a href="https://mastodon.social/tags/SoftwareDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SoftwareDevelopment</span></a> <a href="https://mastodon.social/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.social/tags/WebDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WebDevelopment</span></a> <a href="https://mastodon.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WebDev</span></a></p>
Recent searches
No recent searches
Search options
Only available when logged in.
dmv.community is one of the many independent Mastodon servers you can use to participate in the fediverse.
A small regional Mastodon instance for those in the DC, Maryland, and Virginia areas. Local news, commentary, and conversation.
Administered by:
Server stats:
175active users
dmv.community: About · Status · Profiles directory · Privacy policy
Mastodon: About · Get the app · Keyboard shortcuts · View source code · v4.3.4
#database
21 posts · 5 participants · 0 posts today
zartom<p>Troubleshooting DB2 REORG in Compound SQL Statements: Why Does It Fail?<br>Troubleshooting DB2 REORG compound statements. Learn the difference between compiled and inlined compound SQL blocks in DB2 LUW to avoid errors and optimize database reorganization. Key takeaways include best practices, error handling, and performance considerations. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/REORG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>REORG</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/Troubleshooting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Troubleshooting</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Performance</span></a><br><a href="https://tech-champion.com/programming/troubleshooting-db2-reorg-in-compound-sql-statements-why-doe" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/programming/</span><span class="invisible">troubleshooting-db2-reorg-in-compound-sql-statements-why-doe</span></a>...</p>
zartom<p>How to Overcome the Listagg Limit of 4000 Characters<br>Overcome the LISTAGG limit in SQL for large datasets! Strategies like chunking and recursive CTEs help manage massive concatenated strings. Learn practical solutions for efficient SQL queries. <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/LISTAGG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LISTAGG</span></a> <a href="https://mastodon.social/tags/StringConcatenation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>StringConcatenation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLQueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLQueries</span></a> <a href="https://mastodon.social/tags/LargeDatasets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LargeDatasets</span></a><br><a href="https://tech-champion.com/database/how-to-overcome-the-listagg-limit-of-4000-characters/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/how</span><span class="invisible">-to-overcome-the-listagg-limit-of-4000-characters/</span></a><br>...</p>
zartom<p>How to Find the Exact Count of Records in All Persistent Tables in a Database?<br>Finding accurate Total persistent table records in DB2 LUW can be tricky. Standard methods aren't always precise, especially in high-transaction environments. Learn alternative, efficient techniques to get accurate counts. <a href="https://mastodon.social/tags/DB2LUW" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2LUW</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Performance</span></a> <a href="https://mastodon.social/tags/RecordCounts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RecordCounts</span></a> <a href="https://mastodon.social/tags/TableCounts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>TableCounts</span></a><br><a href="https://tech-champion.com/programming/how-to-find-the-exact-count-of-records-in-all-persistent-tables-in-a-database/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/programming/</span><span class="invisible">how-to-find-the-exact-count-of-records-in-all-persistent-tables-in-a-database/</span></a><br>...</p>
zartom<p>DB2 for i Date Comparison: A Guide to Efficient Date Handling<br>Master DB2 for i Date Comparison! Learn efficient techniques for accurate & reliable date handling in your DB2 applications. Improve query efficiency & avoid common pitfalls. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/DateComparison" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DateComparison</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.social/tags/iSeries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>iSeries</span></a><br><a href="https://tech-champion.com/database/db2luw/db2-for-i-date-comparison-a-guide-to-efficient-date-handling/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/db2-for-i-date-comparison-a-guide-to-efficient-date-handling/</span></a><br>...</p>
zartom<p>How to Change Column Collation in MySQL<br>Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands & automation tips! <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> <a href="https://mastodon.social/tags/Collation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Collation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/CharacterSet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CharacterSet</span></a> <a href="https://mastodon.social/tags/UTF8MB4" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>UTF8MB4</span></a><br><a href="https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/mys</span><span class="invisible">ql/how-to-change-column-collation-in-mysql/</span></a><br>...</p>
zartom<p>Find the Oldest Even-Numbered Patient Visit Using SQL<br>Learn to extract the Oldest Even Visit SQL record! This tutorial covers various SQL techniques, including CTEs and subqueries, to efficiently retrieve this data. Optimize your queries for speed and handle missing data. <a href="https://mastodon.social/tags/SQLqueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLqueries</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/OldestRecord" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OldestRecord</span></a> <a href="https://mastodon.social/tags/EvenVisit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>EvenVisit</span></a> <a href="https://mastodon.social/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a><br><a href="https://tech-champion.com/database/sql-server/find-the-oldest-even-numbered-patient-visit-using-sql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/sql</span><span class="invisible">-server/find-the-oldest-even-numbered-patient-visit-using-sql/</span></a><br>...</p>
zartom<p>SQL Server String Aggregation: SQL Server 2016 vs. 2017<br>Master SQL Server String Aggregation across versions (2016+). Learn dynamic SQL, best practices, &amp; secure techniques to prevent SQL injection. <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a> <a href="https://mastodon.social/tags/DynamicSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DynamicSQL</span></a> <a href="https://mastodon.social/tags/StringAggregation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>StringAggregation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLInjection" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLInjection</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a><br><a href="https://tech-champion.com/general/sql-server-string-aggregation-sql-server-2016-vs-2017/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/general/sql-</span><span class="invisible">server-string-aggregation-sql-server-2016-vs-2017/</span></a><br>...</p>
zartom<p>Reverse Substrings in SQL Server: Four Efficient Methods<br>Master Reverse SQL Substrings in SQL Server! Learn efficient methods to reverse substring order, transforming "apple-banana-cherry" into "cherry-banana-apple". Explore modern techniques using STRING_SPLIT & STRING_AGG for optimal performance. <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a> <a href="https://mastodon.social/tags/stringmanipulation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>stringmanipulation</span></a> <a href="https://mastodon.social/tags/ReverseSubstring" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ReverseSubstring</span></a> <a href="https://mastodon.social/tags/SQLtips" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLtips</span></a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>programming</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a><br><a href="https://tech-champion.com/database/sql-server/reverse-substrings-in-sql-server-four-efficient-methods/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/sql</span><span class="invisible">-server/reverse-substrings-in-sql-server-four-efficient-methods/</span></a><br>...</p>
zartom<p>Retrieving DB2 C Function Code: A Guide for DBAs<br>Retrieving DB2 C Function code isn't directly possible via standard DB2 queries. Learn how to access metadata for location & characteristics to find the code in its external library. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/CFunction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CFunction</span></a> <a href="https://mastodon.social/tags/UDF" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>UDF</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/IBM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IBM</span></a><br><a href="https://tech-champion.com/database/db2luw/retrieving-db2-c-function-code-a-guide-for-dbas/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/retrieving-db2-c-function-code-a-guide-for-dbas/</span></a><br>...</p>
zartom<p>Calculating Average Record Size in DB2: A Comprehensive Guide<br>Learn how to accurately estimate Average Record Size in DB2. This is crucial for capacity planning & performance tuning. We explore various methods using DB2 system catalogs & RUNSTATS. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/CapacityPlanning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CapacityPlanning</span></a> <a href="https://mastodon.social/tags/PerformanceTuning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PerformanceTuning</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a><br><a href="https://tech-champion.com/database/db2luw/calculating-average-record-size-in-db2-a-comprehensive-guide/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/calculating-average-record-size-in-db2-a-comprehensive-guide/</span></a><br>...</p>
zartom<p>Efficient DB2 SQL Upsert: Inserting and Updating Data<br>Streamline your data management with DB2 SQL Upsert! This single statement handles INSERT & UPDATE operations, boosting performance and data integrity. Master DB2 SQL Upsert for efficient, reliable data handling. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/Upsert" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Upsert</span></a> <a href="https://mastodon.social/tags/DataManagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataManagement</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Performance</span></a><br><a href="https://tech-champion.com/database/db2luw/efficient-db2-sql-upsert-inserting-and-updating-data/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/efficient-db2-sql-upsert-inserting-and-updating-data/</span></a><br>...</p>
zartom<p>SQL JOINs Guide: A Comprehensive Guide to Combining Data in SQL<br>Master SQL JOINs with our comprehensive guide! Learn INNER, LEFT, RIGHT, FULL, and more. Practical examples & best practices included. SQL JOINs Guide <a href="https://mastodon.social/tags/SQLJoins" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLJoins</span></a> <a href="https://mastodon.social/tags/LearnSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LearnSQL</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLTutorial" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLTutorial</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a><br><a href="https://tech-champion.com/database/sql-joins-guide-a-comprehensive-guide-to-combining-data-in-sql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/sql</span><span class="invisible">-joins-guide-a-comprehensive-guide-to-combining-data-in-sql/</span></a><br>...</p>
zartom<p>SQL JOINs Guide: A Comprehensive Guide to Combining Data in SQL<br>Master SQL JOINs with our comprehensive guide! Learn INNER, LEFT, RIGHT, FULL, and more. Practical examples & best practices included. SQL JOINs Guide <a href="https://mastodon.social/tags/SQLJoins" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLJoins</span></a> <a href="https://mastodon.social/tags/LearnSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LearnSQL</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLTutorial" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLTutorial</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a><br><a href="https://tech-champion.com/database/sql-joins-guide-a-comprehensive-guide-to-combining-data-in-sql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/sql</span><span class="invisible">-joins-guide-a-comprehensive-guide-to-combining-data-in-sql/</span></a><br>...</p>
zartom<p>Retrieving DB2 C Function Code: A Guide for DBAs<br>Retrieving DB2 C Function code isn't directly possible via standard DB2 queries. Learn how to access metadata for location & characteristics to find the code in its external library. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/CFunction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CFunction</span></a> <a href="https://mastodon.social/tags/UDF" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>UDF</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/IBM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IBM</span></a><br><a href="https://tech-champion.com/database/db2luw/retrieving-db2-c-function-code-a-guide-for-dbas/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/retrieving-db2-c-function-code-a-guide-for-dbas/</span></a><br>...</p>
zartom<p>Calculating Average Record Size in DB2: A Comprehensive Guide<br>Learn how to accurately estimate Average Record Size in DB2. This is crucial for capacity planning & performance tuning. We explore various methods using DB2 system catalogs & RUNSTATS. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/CapacityPlanning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CapacityPlanning</span></a> <a href="https://mastodon.social/tags/PerformanceTuning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PerformanceTuning</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a><br><a href="https://tech-champion.com/database/db2luw/calculating-average-record-size-in-db2-a-comprehensive-guide/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/calculating-average-record-size-in-db2-a-comprehensive-guide/</span></a><br>...</p>
zartom<p>Efficient DB2 SQL Upsert: Inserting and Updating Data<br>Streamline your data management with DB2 SQL Upsert! This single statement handles INSERT & UPDATE operations, boosting performance and data integrity. Master DB2 SQL Upsert for efficient, reliable data handling. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/Upsert" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Upsert</span></a> <a href="https://mastodon.social/tags/DataManagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataManagement</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Performance</span></a><br><a href="https://tech-champion.com/database/db2luw/efficient-db2-sql-upsert-inserting-and-updating-data/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/efficient-db2-sql-upsert-inserting-and-updating-data/</span></a><br>...</p>
zartom<p>SQL JOINs Guide: A Comprehensive Guide to Combining Data in SQL<br>Master SQL JOINs with our comprehensive guide! Learn INNER, LEFT, RIGHT, FULL, and more. Practical examples & best practices included. SQL JOINs Guide <a href="https://mastodon.social/tags/SQLJoins" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLJoins</span></a> <a href="https://mastodon.social/tags/LearnSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LearnSQL</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLTutorial" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLTutorial</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a><br><a href="https://tech-champion.com/database/sql-joins-guide-a-comprehensive-guide-to-combining-data-in-sql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/sql</span><span class="invisible">-joins-guide-a-comprehensive-guide-to-combining-data-in-sql/</span></a><br>...</p>
Martin Guay 👨💻🌈🎮📱🍁<p>Android News & All the Bytes - Scheduled Maintenance until 2h30 PM Eastern time. <a href="https://mstdn.ca/tags/maintenance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>maintenance</span></a> <a href="https://mstdn.ca/tags/website" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>website</span></a> <a href="https://mstdn.ca/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mstdn.ca/tags/update" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>update</span></a></p>
FOSSASIA<p>Join Alkin Tezuysal's session "Unified Observability: Leveraging ClickHouse as a Comprehensive Telemetry Database" at <a href="https://floss.social/tags/FOSSASIASummit2025" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSSASIASummit2025</span></a> to learn how <a href="https://floss.social/tags/ClickHouse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ClickHouse</span></a> simplifies observability, giving engineers deep system insights while minimizing infrastructure complexity.</p><p>🔗 Click here <a href="https://youtu.be/sCRXGqOPtOU?si=lWcjSCpKkuD_gLHW" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">youtu.be/sCRXGqOPtOU?si=lWcjSC</span><span class="invisible">pKkuD_gLHW</span></a> to watch on the FOSSASIA YouTube channel.</p><p><a href="https://floss.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://floss.social/tags/FOSSASIA" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSSASIA</span></a> <a href="https://floss.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a></p>
ExploreLive feeds
Mastodon is the best way to keep up with what's happening.
Follow anyone across the fediverse and see it all in chronological order. No algorithms, ads, or clickbait in sight.
Create accountLoginDrag & drop to upload