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)

What are the essential components of sql server service broker?

1067

---

How do you manipulate data?

949

---

What is the concept of optimization?

1111

---

What is entity data services?

1117

---

How to get the definition of a user defined function back?

1088

---

State a few properties of relational databases?

1181

---

Is foreign key a primary key?

1179

---

Explain the difference between HTTP and HTTPS in database?

1098

---

How to connect ms access to sql servers through odbc?

1072

---

Explain what is sql server english query?

1109

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1112

---

List down some advantages of sql stored procedure?

1016

---

What is the difference between ddl,dml and dcl commands?

1160

---

What is Cross Join and in which scenario do we use Cross Join?

1060

---

What is a trace frag?

1136

---