Posted by DA Morgan on 08/07/06 13:43

Erland Sommarskog wrote:
> DA Morgan (damorgan@psoug.org) writes:
>> Erland Sommarskog wrote:
>>> Correct. A binary collation comes with a price. So does raw partitions.
>> Would you please explain what you intend with this comment about block
>> devices. With any database, other apparently than Microsoft's, there is
>> an advantage that accrues to those who forgo file systems. Why is SQL
>> Server different?
>
> It occurred to me that is another reason why SQL Server is different, which
> is inherent in its architecture. Other engines have to support multiple
> platforms and file systems, so they need to implement some abstract
> interface to handle the file system. Using a raw device means that that
> layer they can cirumventet.
>
> Since SQL Server supports only Windows, it can be spared that layer of
> abstraction, and thus the gain with raw devices is not equally compelling.
>
> I like to stress that all this is pure speculation on my part.

Thanks.

I've seen this in other aspects as well. Being limited to a single
operating system, and one you control, moves many things from the
database to the operating system.

Of course if Vista shows up as a fattened pig ... that may not be such
a good thing. ;-) Again Thanks.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[Back to original message]