row Archives - DbaFix

How does a integer data record store in SQL Server page

By adminPosted on March 15, 2023

Question : I have seen the 8KB (8192 = 96 Header + 36 Row Offset + 8060 Free space) page […]

By adminPosted on December 22, 2022

Question : I have a question on SQL Server page, I have created a new database with only one new […]

By adminPosted on September 26, 2022

Question : I have a products table which contains all my products. Those products table gets filled permanently with new […]

By adminPosted on September 21, 2022

Question : We have some tables with row_format=Compact. The biggest table is around 30Gb, so how safely i can alter […]

By adminPosted on September 6, 2022

Question : I have been trying to backup data with structure from my old legacy server to my local server […]

By adminPosted on August 30, 2022

Question : I’m using Oracle database and I’ve created a test table “Table1” with a varchar column “column1”. I ran […]

By adminPosted on August 5, 2022

Question : A Oracle 12c Database has a table with Chained rows: select owner c1, table_name c2, pct_free c3, pct_used […]

By adminPosted on July 14, 2022

Question : Is there a means of differentiating rows added after a certain date without explicitly storing that information as […]

By adminPosted on June 29, 2022

Question : Related to previous question here From the pg_locks documentation, row level lock information is not available when FOR […]

By adminPosted on June 7, 2022

Question : As a newbie to Mysql I just can’t understand how NULL values are stored in each row formats. […]