I guess when you are running a partition you effectively have the same
thing: a bunch of spaces in the file system of another Operating
system - VIOS or IBM i Operating System. You have no more visibility
over the internals of that than windows does over an SQL Server
database.
On Wed, Jan 30, 2013 at 12:53 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:
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. .
