initial extent
Home > SQL Server Definitions - Initial extent
SearchSQLServer.com Definitions (Powered by WhatIs.com)
EMAIL THIS
LOOK UP TECH TERMS Powered by: WhatIs.com
Search listings for thousands of IT terms:
Browse tech terms alphabetically:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

initial extent



Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

DEFINITION - The initial extent is a set of contiguous blocks in a database segment that is automatically allocated when the segment is created. Any set of contiguous blocks allocated after the initial extent is called a next extent. The total number of extents that can be allocated in a database is limited by the amount of storage space available, or in some cases, by the program used.

The term extent is sometimes used in reference to any contiguous space (for example, a set of sectors) on a hard drive that is reserved for a particular file, folder, or application.

LAST UPDATED: 01 Apr 2005


Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Managing the development lifecycle with Visual Studio Team System 2008
Learn how Visual Studio Team System 2008 Database Edition can add and modify objects, generate deployment scripts and manage the development lifecycle...
A first look at Visual Studio Team System 2008 Database Edition
Learn about Microsoft Visual Studio Team System 2008 for database professionals, a useful tool for database development with Microsoft SQL Server.
Testing transaction log autogrowth behavior in SQL Server
Shrinking SQL Server transaction logs can undermine server performance. An expert runs various tests to determine how transaction log file size...

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
binary tree  (SearchSQLServer.com)
block  (SearchSQLServer.com)




initial extent Solutions - SQL White Paper Library
HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts