Databases Archives - Page 2 of 4 - Dev solutions

Follow

Follow

Contact

Home Databases Page 2

Developer parsing XSLT file with XML in SQL Server using XPath, namespaces and queries

Developer parsing XSLT file with XML in SQL Server using XPath, namespaces and queries

Databases

Import XSLT with XML in SQL Server?

byDev Solutions

July 25, 2025

Developer shocked by fast Oracle tablespace growth with LOB and segment overhead labeled blocks overflowing a hard drive icon

Developer shocked by fast Oracle tablespace growth with LOB and segment overhead labeled blocks overflowing a hard drive icon

Databases

Oracle Tablespace: Why Is It Growing So Fast?

byDev Solutions

July 11, 2025

Illustration of MySQL RANK() function displaying ranked numbers over a database table with a bold question mark, suggesting curiosity about the function's return type.

Illustration of MySQL RANK() function displaying ranked numbers over a database table with a bold question mark, suggesting curiosity about the function's return type.

Databases

RANK() in MySQL & MariaDB: What’s the Return Type?

byDev Solutions

June 2, 2025

Database indexing comparison: Status, CreatedTime vs. CreatedTime, Status for log tables, highlighting performance differences.

Database indexing comparison: Status, CreatedTime vs. CreatedTime, Status for log tables, highlighting performance differences.

Databases

Which Index is Better for Log Tables?

byDev Solutions

June 1, 2025

SQL duplicate removal tutorial featuring GROUP BY, DISTINCT, and ROW_NUMBER functions with query examples.

SQL duplicate removal tutorial featuring GROUP BY, DISTINCT, and ROW_NUMBER functions with query examples.

Databases

Remove Duplicate Rows in SQL?

byDev Solutions

May 31, 2025

SQL script to drop all views in Db2 displayed on a command-line interface, emphasizing database automation and optimization.

SQL script to drop all views in Db2 displayed on a command-line interface, emphasizing database automation and optimization.

Databases

Dropping All Views in Db2 – How to Do It?

byDev Solutions

May 22, 2025

SQL query with LEFT JOIN and a warning sign indicating a filtering mistake causing missing rows.

SQL query with LEFT JOIN and a warning sign indicating a filtering mistake causing missing rows.

Databases

How To Show All Rows Using a Filter?

byDev Solutions

May 17, 2025

Illustration of a recursive SQL query in SQLite, showing a looping database hierarchy with arrows, on a dark-themed background with glowing syntax highlighting.

Illustration of a recursive SQL query in SQLite, showing a looping database hierarchy with arrows, on a dark-themed background with glowing syntax highlighting.

Databases

SQLite Recursive CTE: How to Use Them?

byDev Solutions

May 14, 2025

SQL Server EXISTS short-circuiting issue explained with a frustrated developer, a speedometer showing performance optimization, and SQL query execution analysis.

SQL Server EXISTS short-circuiting issue explained with a frustrated developer, a speedometer showing performance optimization, and SQL query execution analysis.

Databases

Does SQL Server Short Circuit EXISTS?

byDev Solutions

May 13, 2025

Oracle vs PostgreSQL implicit data conversion comparison, highlighting database migration challenges.

Oracle vs PostgreSQL implicit data conversion comparison, highlighting database migration challenges.

Databases

Orafce Implicit Data Conversion: Does It Work?

byDev Solutions

May 10, 2025