Answer Posted / 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)

Tell me when is the update_statistics command used?

1019

---

Write a SQL command to insert and update only a particular field?

1037

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

978

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

953

---

Where in ms sql server is ’100’ equal to ‘0’?

1017

---

Define cursor locking

946

---

How to get a list all databases on the sql server?

1025

---

How does stuff differ from the replace function?

957

---

What is co-related sub query?

974

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

930

---

Explain about the command-line tool SQLCMD?

1018

---

How to defragment indexes with alter index ... Reorganize?

1024

---

What types of replication are supported in sql server?

997

---

Explain what is meant by replication of database?

956

---

What is the difference between row_number and dense_rank?

825

---