What is Index Segmentation ?
A segment is a part of relational data base and consists of
one or more extents. Each extent is further divided into
blocks. Every segment has an index for holding all of its
data for quick data retrieval. Index segments can be created
explicitly by using the CREATE INDEX command. Storage
parameters for the extents of the index segment can be
specified along with this command.
Is This Answer Correct ? | 4 Yes | 1 No |
Explain the difference between delete,drop and truncate in SQL Server?
List the types of recovery model available in sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Diffrences between sql server 2000 vs 2008
4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10
What is the purpose of the model database?
Why is sql server log file full?
What is the command used to recompile the stored procedure at run time?
What is the difference between commit and rollback?
Is it safe to delete log files?
explain different types of constraints? : Sql server database administration
How to create database with physical files specified in ms sql server?