Answer / hari krishna

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.

How to list all stored procedures in the current database using ms sql server?

0 Answers  

---

What is sql server profiler trace data file?

0 Answers  

---

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

---

What is usually the first word in a sql query?

0 Answers  

---

What is table join?

0 Answers  

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---

What is an example of a foreign key?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---