SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
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 Previous Topic Topic Next Topic  

aakcse
Aged Yak Warrior

India
568 Posts

Posted - 10/10/2012 :  08:05:37  Show Profile  Reply with Quote
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
8760 Posts

Posted - 10/10/2012 :  08:14:05  Show Profile  Visit webfred's Homepage  Reply with Quote
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.
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2202 Posts

Posted - 10/10/2012 :  08:14:46  Show Profile  Reply with Quote
In SQL Server,

I think

Pages,
Extents,
Files and Filegroups

--
Chandu
Go to Top of Page

aakcse
Aged Yak Warrior

India
568 Posts

Posted - 10/10/2012 :  10:19:58  Show Profile  Reply with Quote
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
Go to Top of Page

robvolk
Most Valuable Yak

USA
15655 Posts

Posted - 10/10/2012 :  10:42:21  Show Profile  Visit robvolk's Homepage  Reply with Quote
Filegroups are the closest equivalent to Oracle tablespaces.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000