Question : I have seen the 8KB (8192 = 96 Header + 36 Row Offset + 8060 Free space) page […]
Page Number in SQL Server database is not starting from zero
Question : I have a question on SQL Server page, I have created a new database with only one new […]
Mysql: Query which orders by default and rank (pin/hold up entries?)
Question : I have a products table which contains all my products. Those products table gets filled permanently with new […]
How to alter tables safely to set row_format as Compressed or Dynamic in Mariadb Galera Cluster?
Question : We have some tables with row_format=Compact. The biggest table is around 30Gb, so how safely i can alter […]
migration from mysql 4.1.0 to mysql5.6.2
Question : I have been trying to backup data with structure from my old legacy server to my local server […]
Why doesn’t row data show up in SQL Developer?
Question : I’m using Oracle database and I’ve created a test table “Table1” with a varchar column “column1”. I ran […]
Fix Oracle Database chained rows
Question : A Oracle 12c Database has a table with Chained rows: select owner c1, table_name c2, pct_free c3, pct_used […]
PostgreSQL – Date added row metadata
Question : Is there a means of differentiating rows added after a certain date without explicitly storing that information as […]
How to check for row lock level when FOR UPDATE is used in PostgreSQL?
Question : Related to previous question here From the pg_locks documentation, row level lock information is not available when FOR […]
How does DYNAMIC Row format handle NULL storage MYSQL 5.7?
Question : As a newbie to Mysql I just can’t understand how NULL values are stored in each row formats. […]