SQL Server Forums - what is segments in SQL Server

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

what is segments in SQL Server

New Topic

Reply to Topic

Printer Friendly

Author

Topic

aakcse
Aged Yak Warrior

India
517 Posts

Posted - 10/10/2012 : 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
Flowing Fount of Yak Knowledge

Germany
8513 Posts

Posted - 10/10/2012 : 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
Flowing Fount of Yak Knowledge

India
1390 Posts

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

In SQL Server,

I think

Pages,
Extents,
Files and Filegroups

--
Chandu

aakcse
Aged Yak Warrior

India
517 Posts

Posted - 10/10/2012 : 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

USA
15557 Posts

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

Filegroups are the closest equivalent to Oracle tablespaces.

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.