Re: How the SQL Server World Lives

[Alan Campin <alan0307d@xxxxxxxxx>]

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


On Tue, Jan 29, 2013 at 4:10 PM, Richard Schoen <richard@xxxxxxxxxxxxxxx>wrote:

> To turn the question around, how many of you have seen corruption in your
> SQL Server databases ?
>
> Knock on Wood SQL Server has been pretty stable for our usage.
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> Where Information Meets Innovation
> Document Management, Workflow, Report Delivery, Forms and Business
> Intelligence
> Email: richard@xxxxxxxxxxxxxxx
> Web Site: http://www.rjssoftware.com
> Tel: (952) 736-5800
> Fax: (952) 736-5801
> Toll Free: (888) RJSSOFT
>
> ----------------------------------------------------------------------
>
> message: 1
> date: Tue, 29 Jan 2013 13:02:16 -0800
> from: Roger Harman <roger_harman@xxxxxxxxxxx>
> subject: How the SQL Server World Lives
>
> One of the newsletters I subscribe to is http://www.sqlservercentral.com
>
>
>
> A recent article, "My SQL Server Database is Corrupt - Now What?!", had
> some interesting statements from the author:
>
>
>
> .         I was asked how often corruption really occurs in the real world.
> My answer was, "hundreds to thousands of times every week across the
> world, in the tens of millions of SQL Server databases.".
>
> .         Every single week I receive multiple emails asking for some
> advice
> about corruption recovery. When I'm teaching about corruption in our High
> Availability and Disaster Recovery Immersion Event, I always tell the class
> that I expect every DBA to see database corruption at some point during
> their career.
>
> .         I'll end by saying this: if you think that corruption won't
> happen
> to you at some point in your career, I think you'll be surprised. Be
> prepared!
>
>
>
> I'm curious..  How many of you have seen corruption on our platform?  In
> 25+ years on S/38, AS/400, and IBM-i, I have NEVER had an issue with
> corrupt files/tables.  In 1 year of SQL Server at my former employer, I saw
> it happen at least 3 times.  I was shocked but the Microsoft bigots in the
> company just shook it off as status quo.
>
>
>
> Here's the article but you have to be a member to read it.
> http://www.sqlservercentral.com/articles/Corruption/96117/
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.