Answer / bhagwat sharma

When data volumes increase, organizations are faced with
problems relating to data retrieval and posting. They feel
the need for a mechanism that will increase the speed of
data access. An index, like the index of a book, enables the
database retrieve and present data to the end user with
ease. An index can be defined as a mechanism for providing
fast access to table rows and for enforcing constraints.

Answer / rajeev

Index is used for fast searching and batter performance.

Answer / murtaza

INDEXES:
1.indexes are used for performance as well as query
optimization issues in database.
2.indexes are by default created when u create an primary or
unique index on a particular column in a table.
3.In sql server there are 2 types of indexes
1.clustered index
2.non clustered index
4.By default non clustered index are created in sql server 2005.
WHEN TO CREATE INDEXES:
1.indexes should be created on the tables which will be used
frequently.
2.it should be created on d tables which has large amount of
data.

Answer / radhakrishnan

index : increase the performance of sql statement.

When we create :
1) large number of data in table
2) most of null value in specific column
3) multiple join in sql statement
4) less than 2% of data retrive from table

when we not create :
1) frequently update the table
2) less number of data

Type of Index :
1) clustered index
- primary & unique constaint cretae autoatically for this
index
- only one clustered index per table.
- data sorted physical order
- Eg : book front index
2) non clustered index
- create multiple index per table.
- Eg : book back index

Syntax :

Create index index_name on tablename (column name)

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

---

What is use of except clause? How does it differ from not in clause?

0 Answers  

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

What is side by side migration in sql server?

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

---

How to provide values to user defined function parameters?

0 Answers  

---

How to populate a table in sql server?

0 Answers  

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---