When you look at how SQL Server vs OS/400 implements the database it would
not be surprising the SQL Server would become corrupt. OS/400 maintain each
table at the OS level. Each table and index is a separate object.
In contrast SQL Server is just a single binary file storing everything. SQL
Server not part of the OS, just a program sitting on top of the OS. Think
about must go in when you write a new records with variable length. Data
must be copied from one location to another, space allocated and
de-allocated. The surprising thing to me how well SQL Server manages to run
giving the complexity of what it must do constantly but corruption is just
about inevitable. .
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact