Answer / brijesh kumar

Index is used for fast retrival data from a table. There are
two types of index
1.clustered Index
2.Non-clustered Index
1. clustered index is created on primary key and it can be
only on per table
2.Non-clustered Index can be created any column and it can
be more than one in a table

Composite key:- Composite is the combination of more than
one attribute composite key is created when it is not
possible to identify any column in a table that has unique
value in such
a situation combination of more than column is chosen by
which
record can be identify easly clear it is just like primary
key.

How to create an multi-statement table-valued function?

1 Answers  

---

Explain transaction server isolation?

1 Answers  

---

What is difference between inner join and join?

1 Answers  

---

Do you know sql server 2008 introduces automatic auditing?

1 Answers  

---

List out the differences between global and local temp tables in sql server?

1 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1 Answers  

---

What is sql injection and why is it a problem? : sql server security

1 Answers  

---

Explain indexed views and partitioned view with their syntax.

1 Answers  

---

what is Covering Index ?

3 Answers   Thomson Reuters,

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

What is the concept of optimization?

1 Answers  

---