Re: SQL Server for Oracle DBAs
Date: Sat, 31 May 2008 09:09:25 +0100
Message-ID: <g1r17v$2eo$1$8300dec7@news.demon.co.uk>
> This webpage is near zero-value. An Oracle DBA doing this will be nearly
> clueless based on the very substantial amount of information that is
> either incorrect or missing.
>
> Among the obvious factual errors:
> "Because an extent is a contiguous allocation of blocks, large extents aid
> in better I/O rate while reading huge amounts of data."
>
> "Oracle tablespaces are at the instance level."
So I fully expect you as a professional will go and fix your comparison article:
http://www.psoug.org/reference/sqlserver.html
The SQL Server FILE GROUP maps to a Oracle TABLESPACE and not a Logical File Name as you state.
A Logical File Name in SQL Server is a component of a File Group and there can be many Logical File Names as you put it per File Group
-- Tony Rogerson, SQL Server MVP http://sqlblogcasts.com/blogs/tonyrogerson [Ramblings from the field from a SQL consultant] http://sqlserverfaq.com [UK SQL User Community]Received on Sat May 31 2008 - 03:09:25 CDT