what is segments in SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

what is segments in SQL Server

Author

Topic

aakcse
Aged Yak Warrior

570 Posts

Posted - 2012-10-10 : 08:05:37

In Oracle we have

Data block: smallest logical unit of storage
Extents : collection of blocks
Segment: collection of extents
table space : collection of segments

Equivalently what we have in SQL Server

Page
Extent
.
.
.

-Neil

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-10-10 : 08:14:05

Please see here:
http://www.simple-talk.com/sql/learn-sql-server/oracle-to-sql-server,-crossing-the-great-divide,-part-3/

Too old to Rock'n'Roll too young to die.

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-10-10 : 08:14:46

In SQL Server,

I think

Pages,
Extents,
Files and Filegroups

--
Chandu

aakcse
Aged Yak Warrior

570 Posts

Posted - 2012-10-10 : 10:19:58

Thanks Webfred/Bandi

Before coming here I went through this web, didn't read it closely. Now I understand that SQL Server do not have Segments.

however one more question what is the equivalent of tablespace then..?

-Neil

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-10-10 : 10:42:21

Filegroups are the closest equivalent to Oracle tablespaces.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources