Re: How the SQL Server World Lives -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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. .

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.